Permanent Sales Employees

As Michael rounds up his dream sales team for a sales call to secure Lackawanna County as a client, he notices that Ryan Howard, the temporary employee from the temp agency, is included in his team. While Ryan is a bright young up-and-coming salesman, Michael feels he might not be ready for a sales call at this level yet. Besides, Ryan did start a fire in the office a month ago, so it's safe to say he has a few life lessons to learn from Michael.

Exercise

Help Michael gather his employees for his dream team by filtering the Employees table with permanent 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`

-- rewrite this query

SELECT * FROM Employees;