🙏 We need your help! SQLtest.online has no ads and lives only on donations. Even a small amount helps. Donate now →
SQL code copied to buffer
Task 13:

Find Employees by Department

Firebird
Retrieve a list of employees working in the Marketing and Finance departments
Output the EMP_NO, FIRST_NAME, LAST_NAME, DEPT_NO, JOB_CODE columns, sorted by the first field.
Expected result Columns: 5 · Rows: 4
EMP_NO FIRST_NAME LAST_NAME DEPT_NO JOB_CODE

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

Tutorial

By checking a query, you agree that it is stored without your account details and may be included in anonymized datasets, including for AI training. Learn more

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