City + + + + Hammer + + + + 5. Based on the plumbing supply store database with four tables, write SQL SELECT queries that display the following tasks: B CUSTOMER CustomeriD - First Name - Last Name - Address . - State - Zip Code - Phone Number - + C0001 Benjamin Masterson 102 West Bell Avenue Livingston NJ 07039 (973) 234-0130 C0002 Mary Milgrom 14 Elm Lane Dover NJ 07806 (201) 923-0021 C0003 Robert Goodman 432 Lake Drive Ewing NJ 08618 (609) 843-8299 C0004 Margerita Colon 442 W. 73rd Street New York NY 10021 (212) 324-0901 C0005 Irving Wachtel 4020 Main Street Hammonton NJ 08037 (609) 238-8814 C0006 Geoffrey 41 Michele Drive DA Exton PA 19341 (610) 439-8932 C0007 Ashley Flannery 401 Jefferson Road Willow Grove PA 19090 (215) 329-2917 C0008 Joseph Brower 38 Southern Way Princeton NJ 08540 (609) 921-1572 C0009 Xiaoming Wang 82 Magellan Court Franklin Park NJ 08823 (732) 331-1876 + C0010 Derek Escher 89 Dandelion Lane Hamilton NU 08609 (609) 243-3211 C0011 Laura Ng 502 Ocean Avenue Ocean Grove NJ 07756 (732) 324-9893 C0012 Robert Sloan 430 Steinert Street Hamilton NJ 08609 (609) 586-7724 C0013 Nikil Patel 3010 Astor Court Bridgeport CT 06607 (203) 348-8811 C0014 Merrick Hubler 239 Madison Street Hamilton NY 13346 (315) 234-8988 ORDERDETAIL ORDERS Order ID Product II - Quantity OrderD - Customer 1 - Order Date 00001 P0013 1 1 00001 C0004 00001 P0014 4. 00002 C0003 4/18/2013 00001 PO027 1 1 00003 C0006 4/18/2013 00002 P0001 1 PRODUCT 00004 C0007 4/18/2013 00002 P0006 1 Product Name 00005 C0001 ProductID - 4/20/2013 - Units in Stc - Units On Or - UnitPrice 00002 PO020 1 P0001 Ivory Clawfoot Tub 00006 $1,899.00 C0001 4/21/2013 00002 P0022 1 PO002 Black Soaking Tub Built In 3 51,999.00 00007 C0002 4/21/2013 00003 P0003 Massage Jet Tub $2,099.00 P0005 1 00008 C0002 4/22/2013 PO004 Deluxe Massage Jet Tub 1 52.299.00 00003 P0020 00009 C0001 4/22/2013 4 PO005 Infinity Master Tub $2,599.00 00003 PO022 00010 C0002 PO006 Nickel Deluxe Kitchen Faucet 4/22/2013 $499.00 00004 P0003 1 1 PO007 Omnidirectional Shower 0 $899.00 00011 C0001 4/24/2013 00004 1 P0010 POOD Outdoor Soaking Tub 10 5 $1,599.00 C0007 4/24/2013 PO009 Antique Style Brass Bath Faucet 00012 0 00004 P0022 2 2 $399.00 00013 C0004 PO010 Deluxe Kitchen Faucet Set Black 4/24/2013 5 10 P0003 00005 5799.00 Nice 2 + P0011 Deluxe Filtration System 10 4/25/2013 00005 $1,245.00 00014 P0012 C0006 2 P0012 Spacesaver Toilet 0 + $249.00 00005 00015 P0016 2 2 C0009 4/25/2013 P0013 Massage Shower System 50 15 5449.95 00006 P0007 1 00016 C0006 1 4/26/2013 P0014 Replacement Valve Units Type A 500 200 $9.99 00006 P0014 10 00017 C0011 4/26/2013 PO015 Replacement Valve Units Type B 100 $14.79 00007 P0016 Budget Bath Sink Set 3 PO028 00018 15 1 C0011 1 4/26/2013 $179.95 P0017 Utility Sink set 150 50 $69.95 00007 P0030 3 00019 00012 4/27/2013 P0018 Unclogger Tool Set r 55 0 $59.95 00008 P0001 1 00020 C0012 4/28/2013 P0019 Nickel Finish Shower Head 30 15 $39.95 00008 P0004 3 3 00021 C0010 4/29/2013 P0020 Chrome Modern Kitchen Faucet 25 10 $189.95 00008 P0008 4 00022 C0010 4/29/2013 POO21 Frost-Free Outdoor Faucet Set 0 $65.95 PO022 Complete Bathroom Kit 5 00008 PO011 2 00023 C0008 5 4/30/2013 $1,395.00 P0023 Victorian Kitchen Faucet with Sp 10 5 $249.95 00009 P0012 1 00024 C0006 5/1/2013 PO024 Deluxe Spraymaster System 5 0 5569.95 4/15/2013 3 4 0 3 0 11 2 3 1 2 1 + 1 0 10 3 4 0 - 0 + 10 + 50 . + 4 20 15 (1) Show the name of each product. (2) Show all days on which orders have been placed, with no duplicate entries in the case of more than one order placed on the same day. (3) Show the entire PRODUCT table. (4) Show the products. For each product, the product ID, product name, and the ratio of the number of units on order to the number of units in stock. (5) Show the name of each product and the total amount of revenue it has generated (labeled Revenue). The output should be sorted by revenue, with the highest-revenue products first; products that have never been ordered need not appear in the output. (6) Show the same information as in part (5), but only for items that have generated at least $1,000 of revenue. (7) Show the same information as part (5), but including only revenue from orders placed April 27, 2013, or later; products not ordered since that date need not appear in the output. (8) Show the same information as part (5), but only for items for which at least four total units have been ordered, and also showing the total number of units ordered for each product (labeled UnitsOrdered). Sort the output from the largest to the smallest total number of units ordered; within products with the same total number of units ordered, sort from the largest to smallest total revenue