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 thecheapest product (list price). Display product ID, product name, and the list

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!