What will be returned when the following SQL statement is executed? Select driver_no, count(*) as num_deliveries
From deliveries
Where state = 'MA'
Group by driver_no;
A) A listing of all drivers who made deliveries to state = 'MA', sorted by driver number
B) A listing of each driver who made deliveries to state = 'MA' as well as the number of deliveries that each driver has made to that state
C) A count of all of the deliveries made to state = 'MA' by all drivers
D) An error message will be generated

Question

Quizplus · Accepted Answer

The SQL statement selects the driver number and counts the number of deliveries that each driver made to the state of 'MA'. It also groups the results by the driver number, so it will return a listing of each driver who made deliveries to the state of 'MA', as well as the number of deliveries that each driver made to that state.

What Will Be Returned When the Following SQL Statement Is