TASK 10 Queries with aggregates (Pt. 1)

Question 1

Find the longest time that an employee has been at the studio

Answer 1

SELECT MAX(years_employed) as Max_years_employed
FROM employees;

Question 2

For each role, find the average number of years employed by employees in that role

Answer 2

SELECT role, AVG(years_employed) as Average_years_employed
FROM employees
GROUP BY role;

Question 3

Find the total number of employee years worked in each building

Answer 3

SELECT building, SUM(years_employed) as Total_years_employed
FROM employees
GROUP BY building;

Question 4

Example

Answer 4

SELECT AGG_FUNC(column_or_expression) AS aggregate_description, …
FROM mytable
WHERE constraint_expression;