← All problemsExample 1
Problem
Select Every Sales Employee
Easy- sql
Return every column for the employees who work in the Sales department.
Expected columns: all four columns of Employees (id, name, dept, salary), in that order. Row order does not matter.
- Input
Employees(id, name, dept, salary) 1 | Alice | Sales | 50000 2 | Bob | Sales | 60000 3 | Carol | IT | 70000 4 | Dave | IT | NULL 5 | Eve | HR | 55000- Output
id | name | dept | salary 1 | Alice | Sales | 50000 2 | Bob | Sales | 60000- Explanation
Alice and Bob are the only rows whose
deptisSales.
Sample database
Your query runs in the browser against these tables. Column names are exact.
Departments
- dept_id
- dept
Employees
- id
- name
- dept
- salary
Customers
- customer_id
- name
- city
- signup_date
Products
- product_id
- name
- category
- price
Orders
- order_id
- customer_id
- order_date
- status
OrderItems
- order_id
- product_id
- quantity
Logins
- customer_id
- login_date
Staff
- staff_id
- name
- title
- manager_id
No automatic grading here
Run your query and check the rows against what the question asks for. Then open the model answer to compare.
SQL
Tab indents. Press Esc, then Tab to leave the editor.
Ctrl or ⌘ + Enter runs the query.
Loading the SQL engine…