easy5 pts · first answer countssqlaggregation
COUNT and AVG with NULLs
What does this query return?
-- scores rows: (id 1, score 90), (id 2, score NULL), (id 3, score 75) SELECT COUNT(*), COUNT(score), AVG(score) FROM scores;
What does this query return?
-- scores rows: (id 1, score 90), (id 2, score NULL), (id 3, score 75) SELECT COUNT(*), COUNT(score), AVG(score) FROM scores;