Example queries against this table

1. Select all departments and their locations

   SQLCopy

   SELECT dept_name, location, budget
   FROM departments
   ORDER BY dept_name ASC;

2. INNER JOIN: employees with their department names

   SQLCopy

   SELECT
     e.emp_id,
     e.first_name,
     e.last_name,
     d.dept_name,
     d.location
   FROM employees e
   INNER JOIN departments d ON e.dept_id = d.dept_id;

3. LEFT JOIN: all employees even if no department

   SQLCopy

   SELECT
     e.first_name,
     e.last_name,
     COALESCE(d.dept_name, 'Unassigned') AS department
   FROM employees e
   LEFT JOIN departments d ON e.dept_id = d.dept_id;

4. RIGHT JOIN: show all departments even without employees

   SQLCopy

   SELECT
     d.dept_name,
     d.location,
     COUNT(e.emp_id) AS employee_count
   FROM employees e
   RIGHT JOIN departments d ON e.dept_id = d.dept_id
   GROUP BY d.dept_id, d.dept_name, d.location
   ORDER BY employee_count;