SELECT e.name, d.dept_name FROM employees e INNER JOIN departments d ON e.dept_id = d.dept_id;

What type of join is this?

SELECT e.name, d.dept_name, l.city FROM employees e JOIN departments d ON e.dept_id = d.dept_id JOIN locations l ON d.location_id = l.location_id;

How many tables are being joined?

What do 'e' and 'd' represent in the join?

SELECT e.name, d.dept_name FROM employees e JOIN departments d ON e.dept_id = d.dept_id WHERE e.salary > 50000;

What does WHERE clause do here?

What's the difference between INNER JOIN and OUTER JOIN?