Since October 7, 2023, Israel has murdered 57,200 Palestinians, out of whom, 18,188 were children. Please consider donating to Palestine Children's Relief Fund.
SQLite3 IconSQLite3
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 NameData Type
employee_idINT PRIMARY KEY
first_nameVARCHAR
last_nameVARCHAR
date_of_birthTEXT
departmentVARCHAR
employment_typeVARCHAR
Login to Start Coding
-- rewrite this query
SELECT * FROM Employees;