$ ./guess_the_languageSQL & Databases
SQL & Databases · hard · #17

How many rows does each query return?

SELECT COUNT(*) FROM t WHERE 1 = 0;
SELECT COUNT(*) FROM t WHERE 1 = 0
GROUP BY x;
  1. 0 and 0
  2. 1 and 1
  3. 0 and 1
  4. 1 and 0
An aggregate without GROUP BY always yields one row (count 0); with GROUP BY and no input there are no groups, so no rows.
Play SQL & Databases ▸