Keep SQLtest alive: Help cover this month's $100 server costs to keep all lessons and the SQL playground online. Support the project →
SQL code copied to buffer
Task 194:

Staff Information

SQLite
Combine the staff and department tables to generate a list of employees that includes their first and last names, the full department name, and the department's building name.
Expected result Columns: 4 · Rows: 10
personal family name building

Sample rows open after wrong checks: 0 of 2

Write your query below and click "Check it!". Tables are described in the right pane.

Tutorial
The query result will appear here. Ctrl+Enter - Run query