contestada

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

Respuesta :

temmydbrain

Answer:

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

Explanation:

SQL which stands for Structured Query Language. and an SQL statements are used in performing tasks such as to update data on a database, or retrieve data from a database. Some of the popular relational database management systems that use SQL are: Sybase, Oracle, Microsoft SQL Server, Ingres, Access, etc.

kendrich

Answer:

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

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

Otras preguntas