What SQL questions are asked in Microsoft interviews?

Technical interviews at Microsoft cover 20 curated SQL and relational database queries, including joins, window functions, aggregations, and subqueries.

Are SQL questions common for software engineers and data analysts at Microsoft?

Yes, data engineers, backend engineers, business intelligence analysts, and data scientists at Microsoft are routinely tested on real-world database query problems.

Microsoft SQL

Verified

61 SQL queries·38 Easy·20 Medium·3 Hard

Curated SQL and relational database interview problems asked by Microsoft, ranked by frequency with direct problem links.

DSA (1362)

⌘K

#1757Recyclable and Low Fat Products

Easy·Freq 63%·Acc 88.6%

#175Combine Two Tables

Easy·Freq 52%·Acc 79.7%

#197Rising Temperature

Easy·Freq 50%·Acc 51.6%

#1148Article Views I

Easy·Freq 42%·Acc 76.7%

#181Employees Earning More Than Their Managers

Easy·Freq 41%·Acc 73.5%

#584Find Customer Referee

Easy·Freq 39%·Acc 73.1%

#1661Average Time of Process per Machine

Easy·Freq 39%·Acc 66.8%

#1251Average Selling Price

Easy·Freq 38%·Acc 37.5%

#570Managers with at Least 5 Direct Reports

Medium·Freq 38%·Acc 49.2%

#176Second Highest Salary

Medium·Freq 38%·Acc 47.5%

#595Big Countries

Easy·Freq 38%·Acc 68.6%

#1378Replace Employee ID With The Unique Identifier

Easy·Freq 38%·Acc 83.6%

#1581Customer Who Visited but Did Not Make Any Transactions

Easy·Freq 38%·Acc 67.9%

#577Employee Bonus

Easy·Freq 38%·Acc 77.7%

#1068Product Sales Analysis I

Easy·Freq 38%·Acc 85.9%

#1193Monthly Transactions I

Medium·Freq 38%·Acc 59.4%

#1280Students and Examinations

Easy·Freq 38%·Acc 61.5%

#1285Find the Start and End Number of Continuous Ranges

Medium·Freq 38%·Acc 82.0%

#178Rank Scores

Medium·Freq 33%·Acc 68.2%

#180Consecutive Numbers

Medium·Freq 29%·Acc 48.8%

#602Friend Requests II: Who Has the Most Friends

Medium·Freq 29%·Acc 63.0%

#182Duplicate Emails

Easy·Freq 29%·Acc 74.0%

#183Customers Who Never Order

Easy·Freq 29%·Acc 72.0%

#1369Get the Second Most Recent Activity

Hard·Freq 27%·Acc 67.3%

#1789Primary Department for Each Employee

Easy·Freq 27%·Acc 74.8%

#2339All the Matches of the League

Easy·Freq 27%·Acc 88.5%

#1934Confirmation Rate

Medium·Freq 27%·Acc 62.2%

#177Nth Highest Salary

Medium·Freq 27%·Acc 39.5%

#1731The Number of Employees Which Report to Each Employee

Easy·Freq 27%·Acc 53.5%

#550Game Play Analysis IV

Medium·Freq 27%·Acc 41.7%

#196Delete Duplicate Emails

Easy·Freq 27%·Acc 66.3%

#185Department Top Three Salaries

Hard·Freq 25%·Acc 61.0%

#596Classes With at Least 5 Students

Easy·Freq 25%·Acc 64.3%

#626Exchange Seats

Medium·Freq 25%·Acc 74.4%

#1683Invalid Tweets

Easy·Freq 25%·Acc 85.2%

#511Game Play Analysis I

Easy·Freq 25%·Acc 76.5%

#1174Immediate Food Delivery II

Medium·Freq 25%·Acc 56.4%

#1164Product Price at a Given Date

Medium·Freq 25%·Acc 58.1%

#1141User Activity for the Past 30 Days I

Easy·Freq 25%·Acc 51.1%

#586Customer Placing the Largest Number of Orders

Easy·Freq 25%·Acc 64.5%

#184Department Highest Salary

Medium·Freq 25%·Acc 58.6%

#1633Percentage of Users Attended a Contest

Easy·Freq 25%·Acc 60.6%

#620Not Boring Movies

Easy·Freq 25%·Acc 75.1%

#585Investments in 2016

Medium·Freq 25%·Acc 51.4%

#1211Queries Quality and Percentage

Easy·Freq 25%·Acc 53.8%

#1204Last Person to Fit in the Bus

Medium·Freq 25%·Acc 69.5%

#1667Fix Names in a Table

Easy·Freq 16%·Acc 60.6%

#1075Project Employees I

Easy·Freq 16%·Acc 67.0%

#610Triangle Judgement

Easy·Freq 16%·Acc 74.9%

#1050Actors and Directors Who Cooperated At Least Three Times

Easy·Freq 16%·Acc 71.2%

#1341Movie Rating

Medium·Freq 16%·Acc 43.8%

#1327List the Products Ordered in a Period

Easy·Freq 13%·Acc 71.8%

#627Swap Sex of Employees

Easy·Freq 13%·Acc 84.8%

#262Trips and Users

Hard·Freq 13%·Acc 38.6%

#1070Product Sales Analysis III

Medium·Freq 13%·Acc 46.2%

#1179Reformat Department Table

Easy·Freq 13%·Acc 76.3%

#1729Find Followers Count

Easy·Freq 13%·Acc 69.6%

#1321Restaurant Growth

Medium·Freq 13%·Acc 59.2%

#1907Count Salary Categories

Medium·Freq 13%·Acc 64.8%

#1978Employees Whose Manager Left the Company

Easy·Freq 13%·Acc 48.8%

#619Biggest Single Number

Easy·Freq 7%·Acc 0.7%

#	SQL Problem	Difficulty	Frequency↓	Acceptance
#1757	Recyclable and Low Fat Products3 sources	Easy	63%	88.6%
#175	Combine Two Tables3 sources	Easy	52%	79.7%
#197	Rising Temperature3 sources	Easy	50%	51.6%
#1148	Article Views I3 sources	Easy	42%	76.7%
#181	Employees Earning More Than Their Managers3 sources	Easy	41%	73.5%
#584	Find Customer Referee3 sources	Easy	39%	73.1%
#1661	Average Time of Process per Machine3 sources	Easy	39%	66.8%
#1251	Average Selling Price3 sources	Easy	38%	37.5%
#570	Managers with at Least 5 Direct Reports3 sources	Medium	38%	49.2%
#176	Second Highest Salary3 sources	Medium	38%	47.5%
#595	Big Countries3 sources	Easy	38%	68.6%
#1378	Replace Employee ID With The Unique Identifier3 sources	Easy	38%	83.6%
#1581	Customer Who Visited but Did Not Make Any Transactions3 sources	Easy	38%	67.9%
#577	Employee Bonus3 sources	Easy	38%	77.7%
#1068	Product Sales Analysis I3 sources	Easy	38%	85.9%
#1193	Monthly Transactions I3 sources	Medium	38%	59.4%
#1280	Students and Examinations3 sources	Easy	38%	61.5%
#1285	Find the Start and End Number of Continuous Ranges3 sources	Medium	38%	82.0%
#178	Rank Scores3 sources	Medium	33%	68.2%
#180	Consecutive Numbers3 sources	Medium	29%	48.8%
#602	Friend Requests II: Who Has the Most Friends3 sources	Medium	29%	63.0%
#182	Duplicate Emails3 sources	Easy	29%	74.0%
#183	Customers Who Never Order3 sources	Easy	29%	72.0%
#1369	Get the Second Most Recent Activity3 sources	Hard	27%	67.3%
#1789	Primary Department for Each Employee3 sources	Easy	27%	74.8%
#2339	All the Matches of the League3 sources	Easy	27%	88.5%
#1934	Confirmation Rate3 sources	Medium	27%	62.2%
#177	Nth Highest Salary3 sources	Medium	27%	39.5%
#1731	The Number of Employees Which Report to Each Employee3 sources	Easy	27%	53.5%
#550	Game Play Analysis IV3 sources	Medium	27%	41.7%
#196	Delete Duplicate Emails3 sources	Easy	27%	66.3%
#185	Department Top Three Salaries3 sources	Hard	25%	61.0%
#596	Classes With at Least 5 Students3 sources	Easy	25%	64.3%
#626	Exchange Seats3 sources	Medium	25%	74.4%
#1683	Invalid Tweets3 sources	Easy	25%	85.2%
#511	Game Play Analysis I3 sources	Easy	25%	76.5%
#1174	Immediate Food Delivery II3 sources	Medium	25%	56.4%
#1164	Product Price at a Given Date3 sources	Medium	25%	58.1%
#1141	User Activity for the Past 30 Days I3 sources	Easy	25%	51.1%
#586	Customer Placing the Largest Number of Orders3 sources	Easy	25%	64.5%
#184	Department Highest Salary3 sources	Medium	25%	58.6%
#1633	Percentage of Users Attended a Contest3 sources	Easy	25%	60.6%
#620	Not Boring Movies3 sources	Easy	25%	75.1%
#585	Investments in 20163 sources	Medium	25%	51.4%
#1211	Queries Quality and Percentage3 sources	Easy	25%	53.8%
#1204	Last Person to Fit in the Bus3 sources	Medium	25%	69.5%
#1667	Fix Names in a Table3 sources	Easy	16%	60.6%
#1075	Project Employees I3 sources	Easy	16%	67.0%
#610	Triangle Judgement3 sources	Easy	16%	74.9%
#1050	Actors and Directors Who Cooperated At Least Three Times3 sources	Easy	16%	71.2%
#1341	Movie Rating3 sources	Medium	16%	43.8%
#1327	List the Products Ordered in a Period3 sources	Easy	13%	71.8%
#627	Swap Sex of Employees3 sources	Easy	13%	84.8%
#262	Trips and Users3 sources	Hard	13%	38.6%
#1070	Product Sales Analysis III3 sources	Medium	13%	46.2%
#1179	Reformat Department Table3 sources	Easy	13%	76.3%
#1729	Find Followers Count3 sources	Easy	13%	69.6%
#1321	Restaurant Growth3 sources	Medium	13%	59.2%
#1907	Count Salary Categories3 sources	Medium	13%	64.8%
#1978	Employees Whose Manager Left the Company3 sources	Easy	13%	48.8%
#619	Biggest Single Number2 sources	Easy	7%	0.7%

Showing 61 of 61 SQL questions in All TimeCompany Total: 61 SQL questions