These are queries that use the full Red Cat Database as shown in Figure 3.1. Do not use the SimplifiedSales database. You must use the full Red Cat tables of Customer, Sale, SaleItem, Product, Manufacturer, and Employee tables.

For each information request below, formulate a single SQL query to produce the required information. In each case, you should display only the columns requested.

1. For black sneakers, how does the current list price compare to price it has sold? Show manufacturer name, list price, sale price, and column called "discount" (which is the list price - sale price) Show the records in descending order by manfacturer name.

2. What is the total count of manufactures from Oklahoma (State='OK')? Your query should display at least one column called: "Oklahoma_count"

Sale Saleltem Customer CustomerID FirstName LastName StreetAddress City State Saleld SaleDate Customeri Tax Shipping SaleID ProductID Item Size Quantity Sale Price Manufacturer ManufacturerID OF Manufacturer Name Address 1 O Product ProductID ProductName Manufacturer Composition ListPrice Gender Category Address2 City State Postal Code Phone Postal Code Country Phone Color Fax Employee Employeeld FirstName LastName Address City State Description Contact SalaryEmployee Employeeld Salary URL ZIP Phone Manageri SSN WageEmployee Employeeld Wage MaxHours EmailAddress HireDate