Write a SQL query to list all customers who have not made any purchases in the last year.Hint: Focus on the transaction date in the transaction table.

Question 219

Inactive Customers in the New Year of 2024

Premium Access

Unlock this Microsoft interview question.

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

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

Table 1: msft_customers

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

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

Table 2: 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.

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
#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
#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