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:

Field Research

The collection of raw data outside a laboratory, in its natural environment, often involving direct observation and participation.

Longitudinal Research

An approach in research involving repeated observations of the same variables (e.g., people) over short or long periods of time, from months to decades.

Pilot Research

An initial study conducted to test the feasibility of a project or experiment before a larger scale study is launched.

Third Variable

A factor that is not directly involved in the hypothesis being tested but may influence the relationship between the independent and dependent variables.