What result will the following SQL statement produce?

SELECT AVG(salary) AS averageSalary

FROM Employees;

A) The average of all employees in the table employees

B) The average salary of all employees

C) The salary of all employees

D) The mode of all salary

_____2) The following query the average salary in state= 'NC' for each employee.

SELECT employeeID, AVG(salary)

FROM Employees

GROUP BY employeeID

HAVING state = 'NC';

A) True.

B) False

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

SELECT driverNo, count(*) numDeliveries

FROM Deliveries

WHERE city = 'Greensboro'

GROUP BY driverName;

A) A listing of all drivers who made deliveries to city = 'Greensboro', sorted by driver name

B) A listing of each driver who made deliveries to city = 'Greensboro' as well as the number of deliveries that each driver has made to that city

C) A count of all the deliveries made to city = 'Greensboro' by all drivers

D) An error message will be generated