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
| 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
