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:

Verified
Correct Answer:
Verified
Q23: The _ is the structure that contains
Q24: Multiple values returned from an SQL query
Q25: When a GROUP BY clause is included
Q26: The WHERE clause is always processed before
Q27: Discuss the pros and cons of using
Q29: The following INSERT command would work fine:<br>INSERT
Q30: DDL is typically used during which phase
Q31: What are some of the advantages and
Q32: A database is maintained and queried using
Q33: The command for creating a database is:<br>A)