Figuer:
VOTE -SELECT SUM(VOTE1)AS S1,SUM(VOTE2)AS S2, SUM(VOTE1)-SUM(VOTE2)AS S3,SUM(VOTE1-VOTE2)AS S4
FROM VOTE
the

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 SUM(VOTE1) AS S1,SUM(VOTE2) AS S2, SUM(VOTE1) -SUM(VOTE2) AS S3,SUM(VOTE1-VOTE2) AS S4
FROM VOTE
The execution of this query produces the following result (shown in order of occurrence in the query) :

A) 75 40 35 35
B) 75 40 75 35
C) 75 40 35 5
D) 75 40 40 40