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