Write a SQL query to find the name of the most popular product (i.e., the product sold in the highest quantity) for each gender within each category. Your result should include the product name, category, gender, and total quantity sold. Consider only the sales to customers who …

Question 225

Customer Behavior Analysis

Premium Access

Unlock this Microsoft interview question.

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

***** * *** ***** ** **** *** **** ** *** **** ******* ******* (*.*., *** ******* **** ** *** ******* ********) *** **** ****** ****** **** ********. **** ****** ****** ******* *** ******* ****, ********, ******, *** ***** ******** ****. ******** **** *** ***** ** ********* *** **** ****** ****** *** **** ****. ** ***** ** * *** ** *** ******** **** *** *** *** **** ** * ******** *** ******, **** *** **** ********. ****** **** ***** ******* ***** ***** ******** *** **** *** **** **** ** **********/******* *** *** **** *** *****.

Table 1: msft_customers

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

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

Table 2: msft_products

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

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

Table 3: msft_sales

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

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

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.

15: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
#224. Categories with High Average Product Price	Medium
#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