List All Employees and Their Department Names
Easy
joins
Google
Meta
LinkedIn
Join the employees table with the departments table to display each employee's name alongside their department name.
Expected Output
| emp_name | dept_name |
|---|---|
| Alice | Engineering |
| Bob | Marketing |
| Carol | Engineering |
Tables
Hints (2 available)
SQL Editor
Output
Click "Run" to see results...