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

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.

View Practers SQL interview question bank

Support Ticket Resolution Stats

Influence Score via 3-Iteration PageRank

Monthly Customer Retention Rate

Top-2 Highest-Paid Employees Under Each VP

Running Total Revenue per Customer

Delivery Performance - On-Time vs Late per City per Month

Bill of Materials - Recursive Cost Explosion

Longest Consecutive Login Streak

Identify User Sessions from Page View Events

Market Basket Item-Chain Frequency

Multi-Period Cohort Retention Analysis

Customers Who Have Never Placed an Order

Longest Weighted Path in a DAG

Date Series Gap-Fill with Event Counts

Full Ancestor Chain Per Employee

Salary Quartile Distribution Per Department

Fibonacci Sequence via Recursive CTE

Monthly Cohort Retention Analysis

Longest Consecutive Order Streak Per Customer

Highest Paid Employee Per Department

Top 3 Products by Revenue per Category (with RANK)

Employee Hierarchy Depth & Subordinate Salary

Generate Fibonacci Sequence (Recursive CTE)

Employee Hierarchy Depth (Recursive CTE)

User Login Activity Summary

User Session Reconstruction from Event Stream

Category Tree - Full Ancestor Path

Market Basket Analysis - Most Frequently Co-Purchased Products

Employee Salary Stats per Department

Inventory Stockout Period Detection

Recursive Bill of Materials - Full Component Explosion

Longest Consecutive Login Streak per User

FIFO Stock Cost Basis for Sales

Month-over-Month Revenue Growth

Second Highest Salary per Department (DENSE_RANK)

Product Sales Summary per Category per Year

Recursive Running Balance Per Account

Campaign Funnel Analysis (View → Cart → Purchase)

Order Gaps - Products with Inactivity Exceeding 7 Days

Second Highest Salary Per Department

Rolling 3-Month Average Revenue

Monthly Transactions I

Customers Who Bought All Products

Employee Bonus

Employee Whose Manager Left the Company

Find Customer Referee

Game Play Analysis IV

Manager With at Least 5 Direct Reports

Find Followers Count

Immediate Food Delivery II

Replace Employee ID with Unique Identifier

Invalid Tweets

Not Boring Movies

Number of Unique Subjects Taught by Each Teacher

Percentage of Users Attended a Contest

Product Sales Analysis I

Median Salary Per Department

Friend Request Acceptance Rate

Monthly Sales with Running Total

Nth Highest Distinct Salary

Users With 3 or More Consecutive Login Days

Task Dependency - Parallel Execution Levels

Find Missing IDs in a Sequence (Recursive CTE)

Product Sales Summary by Category

Queries Quality and Percentage

Recyclable and Low Fat Products

Project Employees I

Product Sales Analysis III

First Purchase per Customer with Days-to-Convert

Article Views - Authors Who Viewed Their Own Articles

Average Selling Price

Average Time of Process per Machine

Big Countries

Find the Largest Single Number

Classes With at Least 5 Students

Confirmation Rate

Consecutive Numbers

Count Salary Categories

Customers Who Never Order... Wait - Customers With No Transactions on Visits