SELECT sum(CASE WHEN column_A IS NULL THEN 1 ELSE 0 END) A, sum(CASE WHEN column_B IS NULL THEN 1 ELSE 0 END) B FROM my_table;