10.10 (Simple aggregation without grouping) Based on the plumbing supply store database from Chapter 7, write SQL queries to perform the fol- lowing tasks: A Show the total number of units of held in stock (summed across all products). B Show the total value of inventory held, with each unit of inventory valued at its unit price. C Show the total value of inventory held in products whose price is below $50. D Show the total value of inventory held in products whose price is between $100 and $750 (inclusive). E Show the number of products whose unit price is under $200. plumbing Table name: customer WITHOUT ROWID Name Data type Primary Foreign Key Key Unique Check Not NULL Collate Ge 1 CustomerID INTEGER 2 First Name VARCHAR 3 LastName VARCHAR 4 Address VARCHAR 5 City VARCHAR 6 State VARCHAR 7 ZipCode VARCHAR 8 Phone Number VARCHAR plumbing Table name: orders WITHOUT Name Data type Primary Foreign Key Key Unique Check Not NULL 1 OrderID INTEGER 2 CustomerlD INTEGER 3 3 Order Date DATE plumbing Ô Table name: ordertail Name Data type Primary Foreign Key Key Unique Check 1 OrderID INTEGER 2 ProductID INTEGER 3 Quantity INTEGER . plumbing Table name: product Name Data type Unique Primary Foreign Key Key 9 1 ProductID INTEGER 2 Product Name VARCHAR 3 UnitsInStock INTEGER 4 UnitsOnOrder INTEGER 5 Unit Price DOUBLE