Consider the query:

SELECT dept_id, COUNT(*) AS emp_count
FROM employees
WHERE emp_count > 5
GROUP BY dept_id;

What will happen when this query is executed?

Consider the query:

SELECT e.name, d.dept_name
FROM employees e
LEFT JOIN departments d
ON e.dept_id = d.dept_id
WHERE d.location = 'NY';

Which statement best describes the result?

Assume departments.id contains values (1,2,3,NULL).
What will the following query return?

SELECT * 
FROM employees
WHERE dept_id NOT IN (SELECT id FROM departments);

What will the following query return?

SELECT name,
       dept_id,
       AVG(salary) OVER (PARTITION BY dept_id) AS dept_avg
FROM employees;

Suppose:

• Table orders has 100 rows
• Table order_items has 5 rows per order

You run:

SELECT *
FROM orders o
JOIN order_items i
ON o.order_id = i.order_id;

How many rows will the result most likely contain?