What SQL questions are asked in Microsoft interviews?
Technical interviews at Microsoft cover curated SQL and relational database queries, including joins, window functions, aggregations, and subqueries.
Microsoft SQL
Verified63 SQL queries·40 Easy·20 Medium·3 Hard
Curated SQL and relational database interview problems asked by Microsoft, ranked by frequency with direct problem links.
⌘K
Easy·Freq 63%·Acc 88.6%
Easy·Freq 55%·Acc 79.7%
Easy·Freq 50%·Acc 51.6%
Medium·Freq 42%·Acc 47.5%
#1148Article Views I
Easy·Freq 42%·Acc 76.7%
Easy·Freq 41%·Acc 73.5%
Easy·Freq 41%·Acc 66.8%
Easy·Freq 39%·Acc 73.1%
Easy·Freq 39%·Acc 37.5%
Medium·Freq 38%·Acc 49.2%
#595Big Countries
Easy·Freq 38%·Acc 68.6%
Easy·Freq 38%·Acc 67.9%
#577Employee Bonus
Easy·Freq 38%·Acc 77.7%
Medium·Freq 38%·Acc 59.4%
Easy·Freq 38%·Acc 83.6%
Easy·Freq 38%·Acc 85.9%
Easy·Freq 38%·Acc 61.5%
Medium·Freq 38%·Acc 82.0%
Medium·Freq 35%·Acc 48.8%
#178Rank Scores
Medium·Freq 33%·Acc 68.2%
Medium·Freq 32%·Acc 41.7%
#182Duplicate Emails
Easy·Freq 32%·Acc 74.0%
Easy·Freq 32%·Acc 72.0%
Easy·Freq 30%·Acc 66.3%
Medium·Freq 29%·Acc 63.0%
Hard·Freq 28%·Acc 61.0%
#626Exchange Seats
Medium·Freq 28%·Acc 74.4%
Hard·Freq 28%·Acc 67.3%
Easy·Freq 28%·Acc 74.8%
Easy·Freq 28%·Acc 88.5%
#1934Confirmation Rate
Medium·Freq 28%·Acc 62.2%
Medium·Freq 27%·Acc 39.5%
Easy·Freq 27%·Acc 53.5%
Easy·Freq 25%·Acc 64.3%
Easy·Freq 25%·Acc 76.5%
Easy·Freq 25%·Acc 51.1%
Medium·Freq 25%·Acc 56.4%
Easy·Freq 25%·Acc 64.5%
Easy·Freq 25%·Acc 53.8%
Medium·Freq 25%·Acc 58.6%
Medium·Freq 25%·Acc 69.5%
Medium·Freq 25%·Acc 58.1%
#1683Invalid Tweets
Easy·Freq 25%·Acc 85.2%
Medium·Freq 25%·Acc 51.4%
Easy·Freq 25%·Acc 75.1%
Easy·Freq 25%·Acc 60.6%
Easy·Freq 20%·Acc 74.9%
#1341Movie Rating
Medium·Freq 20%·Acc 43.8%
#1075Project Employees I
Easy·Freq 16%·Acc 67.0%
Easy·Freq 16%·Acc 71.2%
# | SQL Problem | Difficulty | Frequency↓ | Acceptance | |
|---|---|---|---|---|---|
| #1757 | Recyclable and Low Fat Products3 sources | Easy | 63% | 88.6% | |
| #175 | Combine Two Tables3 sources | Easy | 55% | 79.7% | |
| #197 | Rising Temperature3 sources | Easy | 50% | 51.6% | |
| #176 | Second Highest Salary3 sources | Medium | 42% | 47.5% | |
| #1148 | Article Views I3 sources | Easy | 42% | 76.7% | |
| #181 | Easy | 41% | 73.5% | ||
| #1661 | Average Time of Process per Machine3 sources | Easy | 41% | 66.8% | |
| #584 | Find Customer Referee3 sources | Easy | 39% | 73.1% | |
| #1251 | Average Selling Price3 sources | Easy | 39% | 37.5% | |
| #570 | Medium | 38% | 49.2% | ||
| #595 | Big Countries3 sources | Easy | 38% | 68.6% | |
| #1581 | Easy | 38% | 67.9% | ||
| #577 | Employee Bonus3 sources | Easy | 38% | 77.7% | |
| #1193 | Monthly Transactions I3 sources | Medium | 38% | 59.4% | |
| #1378 | Easy | 38% | 83.6% | ||
| #1068 | Product Sales Analysis I3 sources | Easy | 38% | 85.9% | |
| #1280 | Students and Examinations3 sources | Easy | 38% | 61.5% | |
| #1285 | Medium | 38% | 82.0% | ||
| #180 | Consecutive Numbers3 sources | Medium | 35% | 48.8% | |
| #178 | Rank Scores3 sources | Medium | 33% | 68.2% | |
| #550 | Game Play Analysis IV3 sources | Medium | 32% | 41.7% | |
| #182 | Duplicate Emails3 sources | Easy | 32% | 74.0% | |
| #183 | Customers Who Never Order3 sources | Easy | 32% | 72.0% | |
| #196 | Delete Duplicate Emails3 sources | Easy | 30% | 66.3% | |
| #602 | Medium | 29% | 63.0% | ||
| #185 | Department Top Three Salaries3 sources | Hard | 28% | 61.0% | |
| #626 | Exchange Seats3 sources | Medium | 28% | 74.4% | |
| #1369 | Get the Second Most Recent Activity3 sources | Hard | 28% | 67.3% | |
| #1789 | Primary Department for Each Employee3 sources | Easy | 28% | 74.8% | |
| #2339 | All the Matches of the League3 sources | Easy | 28% | 88.5% | |
| #1934 | Confirmation Rate3 sources | Medium | 28% | 62.2% | |
| #177 | Nth Highest Salary3 sources | Medium | 27% | 39.5% | |
| #1731 | Easy | 27% | 53.5% | ||
| #596 | Classes With at Least 5 Students3 sources | Easy | 25% | 64.3% | |
| #511 | Game Play Analysis I3 sources | Easy | 25% | 76.5% | |
| #1141 | User Activity for the Past 30 Days I3 sources | Easy | 25% | 51.1% | |
| #1174 | Immediate Food Delivery II3 sources | Medium | 25% | 56.4% | |
| #586 | Easy | 25% | 64.5% | ||
| #1211 | Queries Quality and Percentage3 sources | Easy | 25% | 53.8% | |
| #184 | Department Highest Salary3 sources | Medium | 25% | 58.6% | |
| #1204 | Last Person to Fit in the Bus3 sources | Medium | 25% | 69.5% | |
| #1164 | Product Price at a Given Date3 sources | Medium | 25% | 58.1% | |
| #1683 | Invalid Tweets3 sources | Easy | 25% | 85.2% | |
| #585 | Investments in 20163 sources | Medium | 25% | 51.4% | |
| #620 | Not Boring Movies3 sources | Easy | 25% | 75.1% | |
| #1633 | Easy | 25% | 60.6% | ||
| #610 | Triangle Judgement3 sources | Easy | 20% | 74.9% | |
| #1341 | Movie Rating3 sources | Medium | 20% | 43.8% | |
| #1075 | Project Employees I3 sources | Easy | 16% | 67.0% | |
| #1050 | Easy | 16% | 71.2% |
Showing 50 of 63 SQL questions
50 displayed (of 63 matching)Company Total: 63 SQL questions
Practice Microsoft Data Structures & Algorithms
Explore 1400 verified DSA interview questions asked by Microsoft across 5 recency windows.
Explore Other Company SQL Questions
Direct links to database interview question sets across 75 top tech companies.
Amazon SQL(110)Google SQL(90)Meta SQL(83)Bloomberg SQL(67)Microsoft SQL(63)tcs SQL(19)Cognizant SQL(14)Accenture SQL(10)Infosys SQL(8)X SQL(6)Deloitte SQL(6)Uber SQL(5)IBM SQL(5)Point72 SQL(5)GSN Games SQL(5)LinkedIn SQL(4)Walmart Labs SQL(4)Oracle SQL(3)Meesho SQL(3)Capgemini SQL(3)Wayfair SQL(3)ZS Associates SQL(3)TikTok SQL(2)Cisco SQL(2)DoorDash SQL(2)Roblox SQL(2)EPAM Systems SQL(2)Tesla SQL(2)HashedIn SQL(2)HCL SQL(2)Spotify SQL(2)Dell SQL(2)Ozon SQL(2)Wish SQL(2)Poshmark SQL(2)Zoom SQL(2)Analytics quotient SQL(2)Apple SQL(1)Adobe SQL(1)Yandex SQL(1)DE Shaw SQL(1)PhonePe SQL(1)PayPal SQL(1)Intuit SQL(1)Atlassian SQL(1)Wix SQL(1)Pinterest SQL(1)SAP SQL(1)Swiggy SQL(1)Zomato SQL(1)Yelp SQL(1)Barclays SQL(1)Booking.com SQL(1)Mitsogo SQL(1)Robinhood SQL(1)Pornhub SQL(1)LTIMindtree SQL(1)Revolut SQL(1)Coursera SQL(1)Warnermedia SQL(1)Audible SQL(1)Optum SQL(1)Twitch SQL(1)MAQ Software SQL(1)Aon SQL(1)athenahealth SQL(1)Delhivery SQL(1)MindTree SQL(1)Acko SQL(1)Fortinet SQL(1)ciena SQL(1)Clari SQL(1)Machine Zone SQL(1)Netsuite SQL(1)redbus SQL(1)
Microsoft SQL interview questions FAQ
Are SQL questions common for software engineers and data analysts at Microsoft?
Data engineers, backend engineers, business intelligence analysts, and data scientists at Microsoft may be tested on practical database query problems relevant to the role.