Which SQL statement lists the job titles at JCC and displays the number of employees that have each title?
a. SELECT Title, COUNT(*) AS CountOfTitle
FROM Employees
GROUP BY Title;
b. SELECT Title, COUNT(*) AS CountOfTitle
FROM Employees;
c. SELECT Title, COUNT(*) AS CountOfTitle
FROM Employees
HAVING Title;
d. SELECT Title, COUNT(*) AS CountOfTitle
FROM Employees
ORDER BY Title;

Respuesta :

Otras preguntas