Create a query to identify categories that have an average product price greater than a specified amount. Use GROUP BY and HAVING.Hint: Aggregate functions are key here.

Question 224

Categories with High Average Product Price

Premium Access

Unlock this Microsoft interview question.

230+ interview questions
Official solutions
SQL, Python, and R tracks

****** * ***** ** ******** ********** **** **** ** ******* ******* ***** ******* **** * ********* ******. *** ***** ** *** ******.
****: ********* ********* *** *** ****.

Table: msft_products

***** *********** ** ********, **** ** ******* **, ****, *****, *** ********.

*******_**: ***, *******_****: *******, *****: *******, ********: *******

Last Submission

postgres

No submission yet for this engine. Run and submit your query to save it here.

Expected results

Submit a query to compare against expected output.

Engine

Interview timer

Recommended interview pacing

Easy: 5 min for direct warm-up style questions.

Medium: 10 min for multi-step interview queries.

Hard: 15 min for layered questions with tighter time pressure.

A common bar is solving about 2 medium-or-harder questions in a 30 minute interview.

10:00

Timer

Your results

Run your query to preview results here.

More Microsoft Questions

Browse Company Set

Question	Level	FTPR
#218. Total Amount Spent by Each Customer	Medium
#219. Inactive Customers in the New Year of 2024	Medium
#220. Most Expensive Product in Each Category	Hard
#221. Customers With More Than 5 Products in a Single Transaction	Hard
#222. Product Sales Ranking Within Categories	Hard
#223. Cumulative Total Sales by Day	Hard
#225. Customer Behavior Analysis	Hard
#226. Customer Lifetime Value (CLV) and Segmentation	Hard
#227. Aggregate Sale Amounts per Customer	Hard
#228. Analyzing Sequential Purchase Behavior	Hard
#229. Time Between Repeat Purchases	Hard
#230. Customer Purchase Trend Analysis	Easy