[Solved]Question 1 Expensive Sale Item Saleprice Quantity Ever Made Made First Last Name Name Col Q37023209

Question 1: What is the most expensive saleitem (SalePrice * Quantity) ever made and to whom was it made(first and last name). Name the column LargestItemSale. Use asubquery in the WHERE clause.  

Question 2:List the names of manufactureres ofblack sneakers that cost over $70. Use a subquery in the WHEREclause. Note: Categories are lower case in the database; Colors arecapitalized. Use the keyword “distinct”.

Question 3:Which products have the highest listprice, and what is that price? Use a subquery in the WHERE clause.Only show product name and the price.

Question 4: Give a list of products and their list prices forsneakers whose list price is less than average for flats. Only showproduct names and prices. (Use a subquery in the WHERE clause)

Slo Subqueries in WHERE and HAVING1 These are queries that use the full Red Cat Database as shown in Figure 3.1. To do these queries you cannot use the SimpliiedSales database. You must use the full Red Cat tables of Customer, Sale, Saleltem, Product, Manufacturer, and Employee tables. For each infomation request below, focmulate a single SOL query to produce the required infomati. In each case, you should display only the colums requested. Ee sure that your queries do nut produce duplicate records unless otherwise directed. ProductiD Sa eDane dtess2 isIPr ce City Shppng Country EmployecD Galary WageEmployee Show transcribed image text Slo Subqueries in WHERE and HAVING1 These are queries that use the full Red Cat Database as shown in Figure 3.1. To do these queries you cannot use the SimpliiedSales database. You must use the full Red Cat tables of Customer, Sale, Saleltem, Product, Manufacturer, and Employee tables. For each infomation request below, focmulate a single SOL query to produce the required infomati. In each case, you should display only the colums requested. Ee sure that your queries do nut produce duplicate records unless otherwise directed. ProductiD Sa eDane dtess2 isIPr ce City Shppng Country EmployecD Galary WageEmployee

Expert Answer

---

Answer to Question 1: What is the most expensive sale item (SalePrice * Quantity) ever made and to whom was it made (first and las… . . .