What Will Be Returned When the Following SQL Query Is

question 50

Multiple Choice

What will be returned when the following SQL query is executed?
SELECT driver_no, COUNT(*) as num_deliveries
FROM deliveries
GROUP BY driver_no
HAVING COUNT(^*) > 2;

• A) A listing of all drivers who made more than 2 deliveries as well as a count of the number of deliveries
• B) A listing of all drivers
• C) A listing of the number of deliveries greater than 2
• D) A listing of all drivers who made more than 2 deliveries

---

Definitions:

Total Expenditures

The sum total of all spending or expenses incurred by an individual, business, or government.

Demand Curve

A graphical representation that shows the relationship between the price of a good and the quantity demanded by consumers, typically downward sloping.

Price Elasticity

The measure of how much the quantity demanded of a good responds to a change in the price of that good.

Demand Curve

A diagram that illustrates the connection between a product's cost and the amount of it consumers want to buy at various prices.