Practice Questions

SELECT, WHERE, AND, OR, ORDER BY, LIMIT SQL Interview Questions

Master SQL interview patterns with structured question sets, company filters, and run-ready challenges.

All Questions
affirm afterpay airbnb amazon apple doordash dropbox ebay facebook google linkedin lyft microsoft netflix robinhood roblox snap spotify tiktok twitter uber visa walmart

Questions Showing

25

Companies

23

Access Tier

Free

Single Table: SELECT, WHERE, AND, OR, ORDER BY, LIMIT Clear filters
ID Title Level FTPR Lecture
1 Top store for movie sales Easy

24%

 2.1
2 Top 3 movie categories by sales Easy

42%

 2.1
3 Top 5 shortest movies Easy

49%

 2.1
4 Staff without a profile image Easy

66%

 2.1
16 Staff who live in Woodridge Easy

65%

 2.1
17 GROUCHO WILLIAMS’ actor_id Easy

57%

 2.1
92 Acceptance rate first week of 2021 spotify Easy

14%

 2.1
111 Second most popular product amazon Medium

16%

 2.1
126 Top 3 restaurants uber Hard

10%

 2.1
152 Salary analysis dropbox Easy

20%

 2.1
175 Employees' email account amazon Easy

14%

 2.1
200 Last week's absent students snap Medium

67%

 2.1
210 Issuer and merchant report visa Easy

100%

 2.1
217 Most engaged customers roblox Hard

10%

 2.1
218 Total Amount Spent by Each Customer microsoft Medium - 2.1
219 Inactive Customers in the New Year of 2024 microsoft Medium - 2.1
220 Most Expensive Product in Each Category microsoft Hard - 2.1
221 Customers With More Than 5 Products in a Single Transaction microsoft Hard - 2.1
222 Product Sales Ranking Within Categories microsoft Hard - 2.1
223 Cumulative Total Sales by Day microsoft Hard - 2.1
224 Categories with High Average Product Price microsoft Medium - 2.1
225 Customer Behavior Analysis microsoft Hard - 2.1
226 Customer Lifetime Value (CLV) and Segmentation microsoft Hard - 2.1
227 Aggregate Sale Amounts per Customer microsoft Hard - 2.1
228 Analyzing Sequential Purchase Behavior microsoft Hard - 2.1

Disclaimer: SQLPad collects interview questions and sample data from public sources. We are not affiliated with the companies mentioned in these exercises. Please review our terms and conditions.