SQL
Export PDF (0)
Flagged
Completed
Export PDF (0)
0%
Coding
Theory
Basic Aggregate Functions
Analyze Search Performance
Junior
Average Driver Rating per City
Junior
Average Employee Experience per Project
Junior
Average Items per Order
Junior
Average Power Consumption
Junior
Average Transaction Amount
Junior
Calculate Average Product Cost
Junior
Calculate Contest Participation Rates
Junior
Commute Time Analysis
Junior
Customer Placed the Largest Number of Orders
Junior
Daily Log Volume
Junior
Department-wise Employee Count
Junior
Final Account Balance
Junior
iCloud Storage Analysis Query
Junior
Immediate Food Delivery I
Junior
Inventory Multi-Column Grouping
Junior
Managers with at Least 5 Direct Reports
Junior
Merchant Performance Analysis
Junior
Monthly Revenue & Customer Aggregation
Junior
New Signups by Country
Junior
Protocol Traffic Analysis
Junior
QuickBooks vs. TurboTax Filing Count
Junior
Select Non-Boring Films
Junior
Users With Multiple Tags
Junior
Account Balance After Transfers
Mid
Active User Query
Mid
Aggregation over Dataset Metadata
Mid
Average Completion Time
Mid
Average Employee Leave
Mid
Average Product Ratings per Month
Mid
Average Stream Duration Per User by Topic
Mid
Average Ticket Resolve Time
Mid
Average Time of Process per Machine
Mid
Blocked IPs - Top 10 Source IPs
Mid
Bridge Checkpoint Analysis
Mid
Calculate Call Duration
Mid
Connection Statistics
Mid
Customer Order Analysis
Mid
Customer Order Filtering
Mid
Data Ingestion Trends
Mid
Driver Rating Analysis
Mid
Duplicate File Upload Detection
Mid
First and Last Activity
Mid
Frequent Transactors
Mid
Game Play Analysis III
Mid
Identify High Spenders
Mid
IoT Traffic Monitoring
Mid
Merge Request Activity Summary
Mid
Monthly Active Users
Mid
Monthly Average Sales Analysis
Mid
Monthly Issuance Difference
Mid
Monthly Revenue per Merchant
Mid
Monthly Traffic Usage Analysis per Customer
Mid
Monthly Transaction Analysis
Mid
Monthly Transaction Summary
Mid
Monthly Usage Summary
Mid
New Product Launches
Mid
Order Processing Efficiency
Mid
Peak Hour Earnings Query
Mid
Peak Sales Hour
Mid
Percentage of Same-Day First Orders
Mid
Player Consecutive Login Analysis
Mid
Power User Identification
Mid
Primary vs. Other Address
Mid
Recent Order Aggregation
Mid
Sending vs. Opening Snaps
Mid
Subreddit Activity Reporting
Mid
Task Completion Analytics
Mid
Team Scores in Football Tournament
Mid
Ticket Resolution Latency
Mid
Top Contributors by Write Actions
Mid
Top Engaged Users by Interaction
Mid
Top N Transactions
Mid
Top Storage Consuming Users
Mid
Top Subreddits by Activity
Mid
Trade Volume Aggregation
Mid
Unified System View
Mid
User Activity for the Past 30 Days I
Mid
User Engagement Metrics
Mid
User Spend Analysis
Mid
Vehicle Bridge-Crossing Tracker
Mid
Customer Transaction Analysis
Senior
Double-Entry Ledger
Senior
Email Click-Through-Rate (CTR)
Senior
Friend Requests II: Who Has the Most Friends
Senior
Immediate Food Delivery II
Senior
Ledger Reconciliation
Senior
Monthly Revenue Pivot Query
Senior
Basic Joins
Battery Efficiency
Junior
Calculate Average Processing Duration per Machine
Junior
Cartesian Product Analysis
Junior
Daily Temperature Increase
Junior
Employee Bonus
Junior
Employees Earning More Than Managers
Junior
Map Employee Codes to Unique Identifiers
Junior
Product and Supplier Join
Junior
Product Purchase Analysis
Junior
Report Employee Incentives
Junior
Rising Temperature
Junior
Track Student Exam Participation
Junior
Unreviewed Products
Junior
Visits Without Purchases
Junior
Active Customers with Order Count
Mid
Average Deal Size by Segment
Mid
Average Storage Usage per User
Mid
Client Session Duration Report
Mid
Combine Two Tables
Mid
Complex Joins for Incident Reporting
Mid
Department Highest Salary
Mid
Employee Department Join
Mid
File System Metadata Query
Mid
Identify Managers with Multiple Direct Reports
Mid
Multi-Table Join HR Report
Mid
Orders with Product Details
Mid
Promotional Campaign Analysis
Mid
Real-Time Dasher Tracking & GPS History
Mid
Ride-Sharing Trip Summary
Mid
Total Sales Per Region by Product Category
Mid
Trip and Payment Schema Linking
Mid
User Confirmation Success Rate
Mid
Vehicle Service Center Management
Mid
Whale User Identification
Mid
Basic Select
Big Countries
Junior
Distinct Payment Methods Query
Junior
Find Orders with High Totals
Junior
First and Last Records
Junior
GeoStats
Junior
High Protein and Low Carb Foods
Junior
Incident Status Filter
Junior
Invalid Posts
Junior
Low Quality Problems
Junior
Member Referral
Junior
Names Starting With Letter and Minimum Length
Junior
Overdue Rentals
Junior
Post Views
Junior
Swap Salary
Junior
Threat Detection Log Filter
Junior
Unfinished Parts
Junior
Count Active Projects
Mid
Distinct Flight Routes
Mid
Reformat Department Table
Mid
Swap Genders Query
Mid
Sorting & Grouping
Classes With Minimum Enrollment
Junior
Count Unique Courses Taught by Each Instructor
Junior
Count User Followers
Junior
Daily User Engagement Over 30 Days
Junior
Find Largest Unique Value
Junior
Group Transactions by Item
Junior
Artist Popularity Rank
Mid
Average Login Interval
Mid
Average Transaction Rank
Mid
Capital Gain/Loss
Mid
Daily Final Transaction
Mid
Find Customers Who Purchased All Items
Mid
First Touch Attribution
Mid
Identify Power Users
Mid
Merchant Revenue Analysis
Mid
Monthly Growth Report
Mid
Nth Transaction of Every User
Mid
Oscar Nominee Leaderboard
Mid
Product First Sale Analysis
Mid
Rank Scores
Mid
Remove Duplicates without DISTINCT
Mid
Running Total of Cyber Threats per Client
Mid
Running Total of Sales
Mid
Sales Leaderboard
Mid
Sales Volume Growth
Mid
Top 3 Categories by Total Revenue
Mid
Top K Customers by Spend
Mid
Top Merchants by Spend
Mid
Top N Categories
Mid
Top Rated Products
Mid
Top Repository Contributors
Mid
User Session Activity
Mid
Whale Customers
Mid
Subqueries
Customers Who Never Order
Junior
Employees with Departed Managers
Junior
Find Missing Product IDs
Junior
Calculate Total Policy Values for 2025
Mid
Cohort Retention
Mid
Find Duplicate Records
Mid
Find Users with the Most Connections
Mid
First 50% of Records
Mid
Identify Most Purchased Products
Mid
Job Posting Analytics
Mid
Latest Transaction per User
Mid
Latest Version by Timestamp
Mid
Movie Review Analysis
Mid
Photoshop Revenue Analysis
Mid
Restaurant Growth
Mid
Restaurant Revenue Analysis
Mid
Slow Shipping Duration Identification
Mid
Soft Delete Query on Insert-Only Table
Mid
Stock Price Extremes
Mid
Swap Student Positions
Mid
Complete Album Listeners
Senior
Data Inconsistency and Missing Values Backfill
Senior
Department Top Earners
Senior
Department Top Three Salaries
Senior
Advanced Select & Joins
Determine Primary Department for Employees
Junior
Determine Valid Triangles
Junior
Manager Reporting Structure
Junior
Count Income Categories
Mid
Course and Student Management System
Mid
Deduplicate Activity Logs
Mid
Delete Duplicate Emails
Mid
Duplicate Detection
Mid
Employee Management Chain
Mid
Employee-Manager Hierarchy
Mid
Find Consecutive Values
Mid
Find Discrepancies (Reconciliation)
Mid
Find Overlapping Bookings
Mid
Finding Distinct Communicators
Mid
First Share & Closest Collaborator
Mid
Historical Address Tracking
Mid
Inventory Deductions
Mid
Last Passenger to Board the Shuttle
Mid
Least Efficient Driver
Mid
Local Stock Maxima
Mid
Managers Earning Less Than Subordinates
Mid
Many-to-Many Labeling System
Mid
Moving Average of Daily Active Users
Mid
Moving Average of Transaction Volumes
Mid
Optimistic Locking Implementation
Mid
Overlapping Subscriptions
Mid
Parking Garage System
Mid
Permission System Access Report
Mid
Premium Users Exceeding Usage Limit
Mid
Product Price History
Mid
Product Review System
Mid
Project Budget Analysis
Mid
Project-Specific Numbering (ID vs. IID)
Mid
Real-Time Chat Message Retrieval
Mid
Repeated Payment Detection
Mid
Restaurant Growth
Mid
Revoked Postings
Mid
SQL Join with Duplicate Values
Mid
Stock Volume Variation Trend
Mid
Subscription Service Pro-Rated Billing
Mid
Threaded Replies
Mid
Top Friends
Mid
Transaction Reconciliation
Mid
Unique Transfer Relationships
Mid
Consecutive Numbers
Senior
Consecutive Trading Days
Senior
Dating App Mutual Matches
Senior
Delivery Latency Query
Senior
Design Product Catalog
Senior
E-Commerce Database Schema Design
Senior
End-to-End Dasher Payouts
Senior
Find Cumulative Salary of an Employee
Senior
Find Gaps in Sequential IDs
Senior
Friend Recommendation Query
Senior
Game Play Analysis V
Senior
Identify High-Velocity Cards
Senior
Median Employee Salary
Senior
Merchant Settlement Balance
Senior
NFT Minter with Metadata Schema
Senior
Notification Delivery Summary
Senior
Optimize a Slow Search Query
Senior
Overlapping and Disjoint Meetings
Senior
Overlapping Time Slots
Senior
Pessimistic Locking - Account Transfer
Senior
Real-Time Satellite Image Metadata Store
Senior
Report Contiguous Dates
Senior
Retention Cohorts
Senior
Running Sales Since Restock
Senior
Slow Merchant Transactions Query
Senior
Splitwise Expense Tracker
Senior
Temporary Email Service with TTL
Senior
Time-Series Ledger - Latest Crypto Price
Senior
Top Categories and Active Users
Senior
Transaction Management System
Senior
Trips and Users
Senior
User Activity Report
Senior
User Concurrent Sessions
Senior
User Engagement Query
Senior
User Session Analysis
Senior
Advanced String Functions (Regex / Clause)
Find Second Highest Employee Wage
Junior
Identify Patients with Type I Diabetes
Junior
Standardize User Names
Junior
JSON Data Extraction
Mid
Skill Filtering
Mid
Top 337 SQL Interview Questions And Answers 2025 | TechPrep