🗃️ The Dataset We'll Use Throughout


Let's set up two tables and keep them consistent across every example. This way, when something changes between queries, you know exactly why.



CREATE TABLE employees (
emp_id INT PRIMARY KEY,
full_name VARCHAR(100),
dept_id INT,
salary DECIMAL(10,2),
hire_date ...