Question

K	P	G
1	0	red
2	NULL	red
3	0	blue
4	9	red
5	NULL	blue

Table T has 5 rows of 3 columns of data as shown above, where NULL means no data.

The following statement

SELECT P, COUNT(*) as Total FROM T GROUP BY P;

should return a table containing

a.) zero row
b.) one row
c.) two rows
d.) three rows

Answer 1

SELECT P, COUNT(*) as Total FROM T GROUP BY P;

This query returns three rows

d.) three rows