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

Question

Quizplus · Accepted Answer

The SQL statement selects the driver number and counts the number of deliveries made by each driver from the deliveries table. The Group by clause groups the results by driver number, so the query will return a listing of each driver as well as the number of deliveries that he or she has made.

What Will Be Returned When the Following SQL Statement Is