
0
0
Beginner
Sales Employees
Regional Manager of Dunder Mifflin Scranton branch, Michael Scott, is tasked with obtaining a potential client, Lackawanna County, for Dunder Mifflin. Acquiring the Lackawanna County as a client is exactly the kind of accomplishment that can help Michael impress his corporate higher-up's (or rather, Jan Levinson). But to negotiate with a client so influential, Michael will need the combined expertise of a dream sales team.
Exercise
Help Michael gather his employees for his dream team by filtering the Employees
table with employees from the Sales department only. Display only the first_name
and last_name
columns.
Tables
Employees
Column Name | Data Type |
---|---|
employee_id | INT PRIMARY KEY |
first_name | VARCHAR |
last_name | VARCHAR |
date_of_birth | TEXT |
department | VARCHAR |
employment_type | VARCHAR |
Login to Start Coding
-- rewrite this query
SELECT * FROM Employees;