These are queries that use the full Red Cat Database as shown in Figure 3.1. To do these queries you cannot use the SimplifiedSales database. You must use the full Red Cat tables of Customer, Sale, Saleltem, Product, Manufactures, and Employee tables. Eor each information request below, formulate a single SQL query to produce the required information. In each case, you should display only the columns requested. Be sure that your queries do not produce duplicate records unless otherwise directed. Your Submission: Started on Aug 01 at 21:19 1 Which cities have manufacturers who make boots? Prev Next Tho are the customers (first and last names) that bought "casual shoes" from the manufacturer named Timberland? (Note category ampe are lnwer rase manufacturer names are ranitalized in the datahase) What are the names and list nrirec of nrodurte that sold nn Valentines Dav in14? What are the names of products, their list prices, and their manufacturer name that have a list price under $50 and are made by manufacturers in Phoenix? What are the names of customers who have bought products with a current list price of over $60 made by manufacturers in New Jersey? Give a list of employees (as Emp_FirstName, Emp_LastName) and their hire dates (as Emp_HireDate) and their Managers (as Mgr_FirstName, Mgr_LastName). Also include the managers hiredates (as Mgr_HireDate) Name the columns as indicated. Only show names and hire dates. List Hourly (wage) Employees (first and last names), their hire dates and then the full name (first and last) of their manager. (Rename manager name columns as MgrFirstN, MgrLastN.) Who are the customers from Illinois who have bought products with a list price of over $100 or who have bought flats? Show first and last