Question: Write a CTE that obtains the CompanyName ( from the suppliers table ) ) , count of products, minimum UnitPrice, and maximum UnitPrice ( from

Write a CTE that obtains the CompanyName (from the suppliers table)), count of products, minimum
UnitPrice, and maximum UnitPrice (from the products table). Then write a query that uses the CTE that
lists the CompanyName, count, minimum price, and maximum price for all products that have a count
greater than 3 and a maximum price greater than 50.00. Use appropriate column names. Round the prices
to two decimal places. (Hint: The CTE requires two tables.)

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 Programming Questions!