Page 1 of 1
his Using window aggregate functions, display all of the AdventureWorks clothing items. Display the product name, color,
Posted: Tue Jul 12, 2022 8:21 am
by answerhappygod
- His Using Window Aggregate Functions Display All Of The Adventureworks Clothing Items Display The Product Name Color 1 (70.31 KiB) Viewed 27 times
his Using window aggregate functions, display all of the AdventureWorks clothing items. Display the product name, color, standard cost and list price. Also show the average list price per clothing subcategory, and the average list price for the clothing category. Your output should look like the table below. Hint: Use the FORMAT function to display two decimal points. Category Subcategory Name Clothing Bib-Shorts Men's Bib-Shorts, S Clothing Bib-Shorts Men's Bib-Shorts, M Clothing Bb-Shorts Men's Bib-Shorts, L Clothing Caps AWC Logo Cap Clothing Gloves Half-Finger Gloves, S Clothing Gloves Clothing Gloves Half-Finger Gloves, M Half-Finger Gloves, L Upload Choose a File
Question 3 Avg Price per Subcategory Color StandardCost ListPrice 89.99 89.99 Multi 37.12 Multi 37.12 89.99 89.99 Multi 37.12 89.99 89.99 Multi 6.92 8.99 8.99 Black 9.16 24.49 31.24 Black 9.16 24.49 31.24 Black 9.16 24.49 31.24 Avg Price per Category 50.99 50.99 50.99 50.99 50.99 50.99 50.99 10 pts Write an SQL that will return all of the jerseys (subcategory name = 'Jerseys') whose list price is greater than the average AdventureWorks jersey. Display the product name, the color, and the list price.