(Queries of a single table with filtering conditions) Based on the plumbing supply store database from Chapter 7, write SQL queries that perform the following tasks: A Show the name and unit price of all products priced below $50 (note: SQL treats currency amounts like any other number, so you should not use a $ sign or quotes in your query.) B Show the product name, units on order, and units in stock for all products for which the number of units on order is at least 40% of the number of units in stock. C Show the same information as in part (b), but with the additional restriction that the number of units on order is no more than 10. D Show the first name, last name, city, and state of all customers outside New Jersey (state code “NJ”). E Show the first name, last name, city, and state of all customers who are outside New Jersey or have the first name “Robert” (or both).
#Sales Offer!| Get upto 25% Off: