Solved

What Will Be Returned When the Following SQL Statement Is

Question 28

Multiple Choice

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

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions