Figuer:
VOTE $$\begin{array} { | l | l | l | }
\hline \text { Name } & \text { votel } & \text { vote2 } \
\hline \text { Bill } & 20 & 15 \
\hline \text { Mary } & 10 & 25 \
\hline \text { Jill } & 15 & 0 \
\hline \text { Bob } & 30 & \
\hline
\end{array}$$
-SELECT Vote2,COUNT(*) FROM VOTE
GROUP BY Vote2
In SQL2,the execution of this query produces the following number of rows:
A) 1
B) 2
C) 3
D) 4

Question

Figuer:
VOTE $$\begin{array} { | l | l | l | } 
\hline \text { Name } & \text { votel } & \text { vote2 } \
\hline \text { Bill } & 20 & 15 \
\hline \text { Mary } & 10 & 25 \
\hline \text { Jill } & 15 & 0 \
\hline \text { Bob } & 30 & \
\hline
\end{array}$$
-SELECT Vote2,COUNT(*) FROM VOTE
GROUP BY Vote2
In SQL2,the execution of this query produces the following number of rows:
A) 1
B) 2
C) 3
D) 4

Quizplus · Accepted Answer

The query groups the results by the "Vote2" column and counts the number of occurrences for each distinct value in "Vote2". The table shows four distinct scenarios for "Vote2": 15 (Bill), 25 (Mary), 0 (Jill), and a missing value for Bob (which in SQL is treated as NULL). Each of these represents a distinct group, resulting in four groups and thus four rows in the output.

Figuer: VOTE -SELECT Vote2,COUNT(*) FROM VOTE GROUP BY Vote2 in SQL2,the Execution

Figuer:
VOTE -SELECT Vote2,COUNT(*) FROM VOTE
GROUP BY Vote2
in SQL2,the Execution