What will be returned when the following SQL query is executed? Select driver_no, count(*) as num_deliveries
From deliveries
Group by driver_no
Having count(*) 2;
A) A listing of all drivers who made more than 2 deliveries as well as a count of the number of deliveries
B) A listing of all drivers
C) A listing of the number of deliveries greater than 2
D) A listing of all drivers who made more than 2 deliveries

Question

What will be returned when the following SQL query is executed? Select driver_no, count(*) as num_deliveries
From deliveries
Group by driver_no
Having count(*) > 2;
A) A listing of all drivers who made more than 2 deliveries as well as a count of the number of deliveries
B) A listing of all drivers
C) A listing of the number of deliveries greater than 2
D) A listing of all drivers who made more than 2 deliveries

Quizplus · Accepted Answer

The query groups the deliveries by driver_no and filters the groups to include only those with more than 2 deliveries, returning both the driver_no and the count of deliveries.

What Will Be Returned When the Following SQL Query Is