Question: From the Employee table below, which command would list the count of employees working under each job title? EmployeeID jobTitle Salary Commission E10 Sales 120000

From the Employee table below, which command would list the count of employees working under each job title?

EmployeeID

jobTitle

Salary

Commission

E10

Sales

120000

10000

E11

Marketing

90000

8000

E12

Sales

130000

15000

E13

PR

85000

5000

Question 3 options:

a)

SELECT jobTitle, COUNT (*)
FROM Employees
GROUP BY jobTitle;

b)

SELECT jobTitle, COUNT all
FROM Employees
GROUP BY jobTitle;

c)

SELECT jobTitle, COUNT all
FROM Employees
GROUP BY COUNT all;

d)

SELECT jobTitle, COUNT (*)
FROM Employees
GROUP BY COUNT(*);

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!