(Sorting information extracted from multiple tables) Based on the plumbing supply store database from Chapter 7, write SQL queries to perform the following tasks: A 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. B Show the same information as in part (a), but only for items that have generated at least $1,000 of revenue. C Show the same information as part (a), but including only revenue from orders placed April 27, 2013, or later; products not ordered since that date need not appear in the output. D Show the same information as part (a), 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.
The post write SQL queries to perform the following tasks appeared first on Best Custom Essay Writing Services | EssayBureau.com.