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

---

Definitions:

Life Span

The length of time for which a living organism, including humans, exists, from birth to death.

Capital Stock

The total amount of physical, durable goods that a company possesses at any given time, which are used in producing goods and services.

Intangible Assets

Non-physical assets owned by a business that have value, such as intellectual property, goodwill, and brand recognition.

Inventories

Quantities of goods that are held by a company for the purpose of sale in the future or as materials to be used in the production process.