Construct a query to calculate the average, minimum, and maximum sale amount per customer. Include only customers who have made more than 3 (>3) transactions .Hint: Combine aggregation with a HAVING clause.

Question 227

Aggregate Sale Amounts per Customer

Premium Access

Unlock this Microsoft interview question.

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

********* * ***** ** ********* *** *******, *******, *** ******* **** ****** *** ********. ******* **** ********* *** **** **** **** **** 3 (>3) ************ .
****: ******* *********** **** * ****** ******.

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
#225. Customer Behavior Analysis	Hard
#226. Customer Lifetime Value (CLV) and Segmentation	Hard
#228. Analyzing Sequential Purchase Behavior	Hard
#229. Time Between Repeat Purchases	Hard
#230. Customer Purchase Trend Analysis	Easy