M12 - SQL Query

To find the average salary for each department, you would use the following SQL query:

SELECT Department, AVG(Salary)
FROM Employees
GROUP BY _____;

To get students who have a GPA greater than 3.5 and are majoring in 'Engineering', you would use the following SQL query:

SELECT *

FROM Students

WHERE GPA > 3.5 ___ Major = 'Engineering';

To find the maximum order amount for each customer, you would use the following SQL query:
SELECT CustomerID, MAX(OrderAmount)

FROM Orders

GROUP BY _____;

Retrieve employee names and their corresponding department names from the employees and departments tables:

SELECT employees.name, departments.department_name

FROM employees

_____ departments

ON employees.department_id = departments.id;

Find the total number of hours worked by each employee from the timesheets table:

SELECT employee_id, _____(hours) AS total_hours_worked

FROM timesheets

GROUP BY employee_id;

Retrieve the name and highest score of students from the scores table:

SELECT name, _____(score) FROM scores;

List all employees and their respective managers' names from the employees table (assuming the table has a manager_id field):

SELECT e1.name AS employee_name, e2.name AS manager_name

FROM employees e1 _____ employees e2 ON e1.manager_id = e2.id;

Find the total quantity of each product in stock from the inventory table:

SELECT product_id, _____(quantity) AS total_quantity_in_stock

FROM inventory

GROUP BY product_id;

List all unique department names from the employees table:

SELECT _____ department_name FROM employees;

Retrieve employee names and hire dates from the employees table, ordered by hire date in ascending order:

SELECT name, hire_date

FROM employees

_____ __ ___ ___;