Original Query:

SELECT t0.N_NAME as N_NAME, SUM(1) AS "cnt:C_NAME:ok"
FROM SNOWFLAKE_SAMPLE_DATA.TPCH_SF1000.CUSTOMER CUSTOMER
  INNER JOIN (
  SELECT CUSTOMER.C_NATIONKEY AS C_NATIONKEY, NATION.N_NAME AS N_NAME
  FROM SNOWFLAKE_SAMPLE_DATA.TPCH_SF1000.CUSTOMER CUSTOMER
    LEFT JOIN SNOWFLAKE_SAMPLE_DATA.TPCH_SF1000.NATION NATION
      ON (CUSTOMER.C_NATIONKEY = NATION.N_NATIONKEY)
  GROUP BY 1,2) t0
    ON (CUSTOMER.C_NATIONKEY = t0.C_NATIONKEY)
WHERE (CASE WHEN ((CUSTOMER.C_MKTSEGMENT IN ('AUTOMOBILE'))
       OR (CUSTOMER.C_MKTSEGMENT IS NULL)) THEN FALSE ELSE TRUE END)
GROUP BY 1;