Please solve the following query by SSMS, script has to be opened. The organizer is requesting a

Please solve the following query by SSMS, script has to be opened.

Transcribed Image Text:

The organizer is requesting a list of all products with a price less than or equal to the average product MSRP. 1. Write a query that makes use of a WHERE subquery to list the product name and MSRP of every product that with an MSRP greater than the average MSRP. (2 marks for select, 1 mark for from, 2 marks for where) 2. Use an aggregate function in your subquery to calculate the average MSRP. (3 marks for subquery with aggregate function) RESULT SET (8 marks) (1 mark for generating result set, 1 mark for each of five rows, 1 mark for each of two headings) 1 2 Pr_Name Jersey - XL Jersey - XXL MSRP 125.00 150.00 The organizer is requesting a list of all products with a price less than or equal to the average product MSRP. 1. Write a query that makes use of a WHERE subquery to list the product name and MSRP of every product that with an MSRP greater than the average MSRP. (2 marks for select, 1 mark for from, 2 marks for where) 2. Use an aggregate function in your subquery to calculate the average MSRP. (3 marks for subquery with aggregate function) RESULT SET (8 marks) (1 mark for generating result set, 1 mark for each of five rows, 1 mark for each of two headings) 1 2 Pr_Name Jersey - XL Jersey - XXL MSRP 125.00 150.00