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 * FROM VOTE WHERE Vote110 AND VOTE2 10
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 * FROM VOTE WHERE Vote1>10 AND VOTE2 >10
The execution of this query produces the following number of rows:
A) 1
B) 2
C) 3
D) 4

Quizplus · Accepted Answer

The query selects rows where both Vote1 and Vote2 are greater than 10. Only Mary's row satisfies this condition with Vote1 = 10 and Vote2 = 25.

Figuer: VOTE -SELECT * FROM VOTE WHERE Vote1>10 AND VOTE2 >10 the

Figuer:
VOTE -SELECT * FROM VOTE WHERE Vote1>10 AND VOTE2 >10
the