Question: Write a SQL statement to display the most expensive and the cheapest product (list price). Display product ID, product name, and the list price. Product


Write a SQL statement to display the most expensive and the cheapest product (list price). Display product ID, product name, and the list price. Product ID Product Name Price 50 Intel SSDPECME0401401 $8,867.99 2 94 Western Digital WD2500AVVS $15.55 Write a SQL query to display the number of customers with total order amount over the average amount of all orders, the number of customers with total order amount under the average amount of all orders, number of customers with no orders, and the total number of customers. See the format of the following result. Customer Report 1 Number of customers with total purchase amount over average: 42 2 Number of customers with total purchase amount below average: 5 3 Number of customers with no orders: 272 4 Total number of customers: 319 4
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
