1. Write a query that returns the Product Name, Supplier Name, Suplier ID, and Cattegory ID for all products in Category 1. 2. a) Management would like you to pull a list of employees and the orders they filled. Write an SQL query to return the employee ID, employee last name, and Order date for each employee. Include all employees even if they haven't filled any orders. If there are any employees who have not filled orders, state the last name of that employee. b) Demonstrate a way to get this same result with a different join