Question

What will be returned when the following SQL statement is executed?

SELECT driver_no, count(*) as num_deliveries
FROM deliveries
GROUP BY driver_no;
Group of answer choices:
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

Answer 1

b) A listing of each driver as well as the number of deliveries that he or she has made

Step-by-step explanation:

The structured query language will produce an output as follow;

A listing of each driver as well as the number of deliveries that he or she has made.

This output generates by the query duely satisfies the SQL command given.

SQL is used in most cases in order to arrive at a detailed answer making use of a structured querry