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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!