View Practers SQL interview question bank
Preview SQL interview questions on joins, GROUP BY, filtering, window functions, subqueries, aggregations, reporting queries, and databases.
radio_button_unchecked
1.
Market Basket Analysis - Most Frequently Co-Purchased Products
Med
radio_button_unchecked
2.
Top 3 Products by Revenue per Category (with RANK)
Med
radio_button_unchecked
3.
Monthly Customer Retention Rate
Med
radio_button_unchecked
4.
Order Gaps - Products with Inactivity Exceeding 7 Days
Med
radio_button_unchecked
5.
First Purchase per Customer with Days-to-Convert
Med
radio_button_unchecked
6.
Month-over-Month Revenue Growth
Med
radio_button_unchecked
7.
Second Highest Salary per Department (DENSE_RANK)
Med
radio_button_unchecked
8.
Running Total Revenue per Customer
Med
radio_button_unchecked
9.
Longest Consecutive Login Streak per User
Med
radio_button_unchecked
10.
Monthly Cohort Retention Analysis
Med
radio_button_unchecked
11.
Recursive Bill of Materials - Full Component Explosion
Med
radio_button_unchecked
12.
Find Missing IDs in a Sequence (Recursive CTE)
Med
radio_button_unchecked
13.
Rolling 3-Month Average Revenue
Med
radio_button_unchecked
14.
Identify User Sessions from Page View Events
Med
radio_button_unchecked
15.
Generate Fibonacci Sequence (Recursive CTE)
Med
radio_button_unchecked
16.
Employee Hierarchy Depth (Recursive CTE)
Med
radio_button_unchecked
17.
Nth Highest Distinct Salary
Med
radio_button_unchecked
18.
Longest Consecutive Order Streak Per Customer
Med
radio_button_unchecked
19.
Median Salary Per Department
Med
radio_button_unchecked
20.
Friend Request Acceptance Rate
Med
radio_button_unchecked
21.
Date Series Gap-Fill with Event Counts
Med
radio_button_unchecked
22.
Market Basket Item-Chain Frequency
Med
radio_button_unchecked
23.
Inventory Stockout Period Detection
Med
radio_button_unchecked
24.
Multi-Period Cohort Retention Analysis
Med
radio_button_unchecked
25.
Longest Weighted Path in a DAG
Med
radio_button_unchecked
26.
User Session Reconstruction from Event Stream
Med
radio_button_unchecked
27.
FIFO Stock Cost Basis for Sales
Med
radio_button_unchecked
28.
Influence Score via 3-Iteration PageRank
Med
radio_button_unchecked
29.
Salary Quartile Distribution Per Department
Med
radio_button_unchecked
30.
Top-2 Highest-Paid Employees Under Each VP
Med
radio_button_unchecked
31.
Monthly Sales with Running Total
Med
radio_button_unchecked
32.
Task Dependency - Parallel Execution Levels
Med
radio_button_unchecked
33.
Full Ancestor Chain Per Employee
Med
radio_button_unchecked
34.
Recursive Running Balance Per Account
Med
radio_button_unchecked
35.
Category Tree - Full Ancestor Path
Med
radio_button_unchecked
36.
Fibonacci Sequence via Recursive CTE
Med
radio_button_unchecked
37.
Bill of Materials - Recursive Cost Explosion
Med
radio_button_unchecked
38.
Longest Consecutive Login Streak
Med
radio_button_unchecked
39.
Employee Hierarchy Depth & Subordinate Salary
Med
radio_button_unchecked
40.
Campaign Funnel Analysis (View → Cart → Purchase)
Med
radio_button_unchecked
41.
Customers Who Have Never Placed an Order
Med
radio_button_unchecked
42.
Monthly Transactions I
Med
radio_button_unchecked
43.
Customers Who Bought All Products
Med
radio_button_unchecked
44.
Employee Bonus
Med
radio_button_unchecked
45.
Employee Whose Manager Left the Company
Med
radio_button_unchecked
46.
Find Customer Referee
Med
radio_button_unchecked
47.
Find Followers Count
Med
radio_button_unchecked
48.
Game Play Analysis IV
Med
radio_button_unchecked
49.
Immediate Food Delivery II
Med
radio_button_unchecked
50.
Invalid Tweets
Med
radio_button_unchecked
51.
Manager With at Least 5 Direct Reports
Med
radio_button_unchecked
52.
Replace Employee ID with Unique Identifier
Med
radio_button_unchecked
53.
Not Boring Movies
Med
radio_button_unchecked
54.
Number of Unique Subjects Taught by Each Teacher
Med
radio_button_unchecked
55.
Percentage of Users Attended a Contest
Med
radio_button_unchecked
56.
Product Sales Analysis I
Med
radio_button_unchecked
57.
Second Highest Salary Per Department
Med
radio_button_unchecked
58.
Product Sales Summary by Category
Med
radio_button_unchecked
59.
Users With 3 or More Consecutive Login Days
Med
radio_button_unchecked
60.
Highest Paid Employee Per Department
Med
radio_button_unchecked
61.
Delivery Performance - On-Time vs Late per City per Month
Med
radio_button_unchecked
62.
Support Ticket Resolution Stats
Med
radio_button_unchecked
63.
Product Sales Summary per Category per Year
Med
radio_button_unchecked
64.
Employee Salary Stats per Department
Med
radio_button_unchecked
65.
Recyclable and Low Fat Products
Med
radio_button_unchecked
66.
Queries Quality and Percentage
Med
radio_button_unchecked
67.
Project Employees I
Med
radio_button_unchecked
68.
Product Sales Analysis III
Med
radio_button_unchecked
69.
User Login Activity Summary
Med
radio_button_unchecked
70.
Article Views - Authors Who Viewed Their Own Articles
Med
radio_button_unchecked
71.
Average Selling Price
Med
radio_button_unchecked
72.
Average Time of Process per Machine
Med
radio_button_unchecked
73.
Big Countries
Med
radio_button_unchecked
74.
Find the Largest Single Number
Med
radio_button_unchecked
75.
Classes With at Least 5 Students
Med
radio_button_unchecked
76.
Confirmation Rate
Med
radio_button_unchecked
77.
Consecutive Numbers
Med
radio_button_unchecked
78.
Count Salary Categories
Med
radio_button_unchecked
79.
Customers Who Never Order... Wait - Customers With No Transactions on Visits
Med
radio_button_unchecked
80.
Primary Department for Each Employee
Med
SQL interview practice for queries, joins, and reporting logic
This SQL interview question bank helps you practice database query problems around joins, GROUP BY, HAVING, filtering, subqueries, window functions, aggregations, ranking, retention, and reporting metrics. You can preview the business-style prompt first, then open the same problem in the Practers workspace when you are ready to write and test a query. It is built for analyst, data, backend, and software interview preparation.
Back to all interview question banks