Exercise $2.$ Develop a query to retrieve employee id$,$ first name, last name, hire date, and salary of all the

employee whose last name is Gates.

Exercise $3.$ Develop a query to retrieve employee id$,$ first name, last name, hire date, and salary of all the

employees who were hired in $2007.$ You will need to use the EXTRACT function. Look it up$!$

Exercise $4.$ Develop a query to retrieve employee id$,$ first name, last name, hire date, and salary finds employees

whose salaries are greater than or equal $9,000.$ Sort the results by salary.

Exercise $5.$ Use the AND operator to find all employees whose salaries are greater than $5,000$ and less than $7,000.$

Exercise $6.$ The IS NULL operator compares a value with a null value and returns true if the compared value is

null; otherwise, it returns false. Use IS NULL to find the first name, last name, and phone number of of all

employees who do not have a phone number.

Exercise $7.$ The IN operator compares a value to a list of specified values. The IN operator returns true if the

compared value matches at least one value in the list; otherwise, it returns false. Use the IN operator to find all

employees who work in the department id $10,20,$ or $30.$