Task 11 Queries with aggregates (Pt. 2)

Question 1

Find the number of Artists in the studio (without a HAVING clause)

Answer 1

SELECT role, COUNT(*) as Number_of_artists
FROM employees
WHERE role = “Artist”;

Question 2

Find the number of Employees of each role in the studio

Answer 2

SELECT role, COUNT(*)
FROM employees
GROUP BY role;

Question 3

Find the total number of years employed by all Engineers

Answer 3

SELECT role, SUM(years_employed)
FROM employees
GROUP BY role
HAVING role = “Engineer”;