What does the final query return?
CREATE TABLE t (x INT); INSERT INTO t VALUES (1), (NULL), (3); SELECT COUNT(*), COUNT(x) FROM t;
- 3 | 2
- 3 | 3
- 2 | 2
- 2 | 3
COUNT(*) counts rows; COUNT(x) skips rows where x is NULL.
Play Problem Solving ▸
CREATE TABLE t (x INT); INSERT INTO t VALUES (1), (NULL), (3); SELECT COUNT(*), COUNT(x) FROM t;