Filter by a number — practice · DataDesk

SELECT & WHERE(3 / 20)

Basic

Filter by a number

List emp_id, first_name and salary of employees earning more than 1,00,000.

Tables

departments

dept_idinteger
dept_namevarchar
locationvarchar

emp_projects

emp_idinteger
project_idinteger
rolevarchar
hours_per_weekinteger

employees

emp_idinteger
first_namevarchar
last_namevarchar
emailvarchar
dept_idinteger
manager_idinteger
job_titlevarchar
salaryinteger
hire_datedate
cityvarchar
gendervarchar

projects

project_idinteger
project_namevarchar
dept_idinteger
budgetinteger
start_datedate
end_datedate

Expected output

8 rows with columns emp_id, first_name, salary — first 3 shown:

#
1	1	Anita	250000
2	2	Rahul	180000
3	3	Priya	140000

Hints(0/2)

Solution

Unlocks after you solve it or after 3 submissions

SQL (DuckDB)

Ctrl + Enter to runLog in to save progress and earn XP

Run your code to see the output here.