Search ⌘K
Practice Workspace

Practice with the full bank, then narrow into a path.

Your active path is foundations track, but the catalog stays broad by default so you can spot harder reps, switch contexts quickly, and still return to the path that best matches your current goal. Starter includes 160 free problems and marks 94 Pro-only problems before you open a gate.

254 problems
160 free
94 Pro
393 company scenarios
34 hard reps visible
160 runnable on starter
0 solved so far
Start broad, then focus when you want structure.

Company labels help frame practice in a familiar business context. They are directional study aids, not official interview guidance from the companies listed. We keep all paths visible first so hard questions do not disappear.

77 visible
Hard 10
Medium 25
Easy 42
160 free problems

· 94 Pro problems · Filter:

Company
Difficulty
Path
Suggested path: Foundations Track
Pro feature
Free questions stay open
Browse first, then sign in when you want to run SQL.

Free problems open for practice. Pro unlocks the full bank, study plan, and mock interviews.

IshaSQL Pro — 30-day pass
₹999

30 days of Pro access. Renew or extend anytime; extra time stacks from your current end date.

IshaSQL Pro — annual pass
Best value
₹7,999

365 days of Pro access. Renew or extend anytime; extra time stacks from your current end date.

8+ months free vs buying 30-day passes.

I
IshaSQL

Foundations Track

Easy
15 min
DNA Pattern Recognition

Table: Samples +----------------+---------+ | Column Name | Type | +----------------+---------+ | sample_id | int | | dna_sequence | varchar | | species | va...

Foundations Track
filtering
I
IshaSQL

Foundations Track

Easy
15 min
Odd and Even Transactions

Table: transactions +------------------+------+ | Column Name | Type | +------------------+------+ | transaction_id | int | | amount | int | | transaction_da...

Foundations Track
aggregation
filtering
I
IshaSQL

Foundations Track

Easy
15 min
Employees Whose Manager Left the Company

Table: Employees +-------------+----------+ | Column Name | Type | +-------------+----------+ | employee_id | int | | name | varchar | | manager_id | int | |...

Foundations Track
filtering
I
IshaSQL

Foundations Track

Easy
15 min
Employees With Missing Information

Table: Employees +-------------+---------+ | Column Name | Type | +-------------+---------+ | employee_id | int | | name | varchar | +-------------+---------...

Foundations Track
filtering
I
IshaSQL

Foundations Track

Easy
15 min
Count Salary Categories

Table: Accounts +-------------+------+ | Column Name | Type | +-------------+------+ | account_id | int | | income | int | +-------------+------+ account_id ...

Foundations Track
aggregation
filtering
I
IshaSQL

Foundations Track

Easy
15 min
The Latest Login in 2020

Table: Logins +----------------+----------+ | Column Name | Type | +----------------+----------+ | user_id | int | | time_stamp | datetime | +---------------...

Foundations Track
aggregation
filtering
I
IshaSQL

Foundations Track

Easy
15 min
Rearrange Products Table

Table: Products +-------------+---------+ | Column Name | Type | +-------------+---------+ | product_id | int | | store1 | int | | store2 | int | | store3 | ...

Foundations Track
filtering
I
IshaSQL

Foundations Track

Easy
15 min
Primary Department for Each Employee

Table: Employee +---------------+---------+ | Column Name | Type | +---------------+---------+ | employee_id | int | | department_id | int | | primary_flag |...

Foundations Track
filtering
I
IshaSQL

Foundations Track

Easy
15 min
Recyclable and Low Fat Products

Table: Products +-------------+---------+ | Column Name | Type | +-------------+---------+ | product_id | int | | low_fats | enum | | recyclable | enum | +--...

Foundations Track
filtering
I
IshaSQL

Foundations Track

Easy
15 min
Find Total Time Spent by Each Employee

Table: Employees +-------------+------+ | Column Name | Type | +-------------+------+ | emp_id | int | | event_day | date | | in_time | int | | out_time | in...

Foundations Track
aggregation
I
IshaSQL

Foundations Track

Easy
15 min
The Number of Employees Which Report to Each Employee

Table: Employees +-------------+----------+ | Column Name | Type | +-------------+----------+ | employee_id | int | | name | varchar | | reports_to | int | |...

Foundations Track
aggregation
I
IshaSQL

Foundations Track

Easy
15 min
Find Followers Count

Table: Followers +-------------+------+ | Column Name | Type | +-------------+------+ | user_id | int | | follower_id | int | +-------------+------+ (user_id...

Foundations Track
aggregation
I
IshaSQL

Foundations Track

Easy
15 min
Daily Leads and Partners

Table: DailySales +-------------+---------+ | Column Name | Type | +-------------+---------+ | date_id | date | | make_name | varchar | | lead_id | int | | p...

Foundations Track
aggregation
I
IshaSQL

Foundations Track

Easy
15 min
Invalid Tweets

Table: Tweets +----------------+---------+ | Column Name | Type | +----------------+---------+ | tweet_id | int | | content | varchar | +----------------+---...

Foundations Track
filtering
I
IshaSQL

Foundations Track

Easy
15 min
Fix Names in a Table

Table: Users +----------------+---------+ | Column Name | Type | +----------------+---------+ | user_id | int | | name | varchar | +----------------+--------...

Foundations Track
filtering
I
IshaSQL

Foundations Track

Easy
15 min
Average Time of Process per Machine

Table: Activity +----------------+---------+ | Column Name | Type | +----------------+---------+ | machine_id | int | | process_id | int | | activity_type | ...

Foundations Track
aggregation
I
IshaSQL

Foundations Track

Easy
15 min
Patients With a Condition

Table: Patients +--------------+---------+ | Column Name | Type | +--------------+---------+ | patient_id | int | | patient_name | varchar | | conditions | v...

Foundations Track
filtering
I
IshaSQL

Foundations Track

Easy
15 min
Capital Gain/Loss

Table: Stocks +---------------+---------+ | Column Name | Type | +---------------+---------+ | stock_name | varchar | | operation | enum | | operation_day | ...

Foundations Track
aggregation
I
IshaSQL

Foundations Track

Easy
15 min
Queries Quality and Percentage

Table: Queries +-------------+---------+ | Column Name | Type | +-------------+---------+ | query_name | varchar | | result | varchar | | position | int | | ...

Foundations Track
aggregation
filtering
I
IshaSQL

Foundations Track

Easy
15 min
Article Views I

Table: Views +---------------+---------+ | Column Name | Type | +---------------+---------+ | article_id | int | | author_id | int | | viewer_id | int | | vi...

Foundations Track
filtering
I
IshaSQL

Foundations Track

Easy
15 min
First Login Date

Table: Activity +--------------+---------+ | Column Name | Type | +--------------+---------+ | player_id | int | | device_id | int | | event_date | date | | ...

Foundations Track
aggregation
I
IshaSQL

Foundations Track

Easy
15 min
Actors and Directors Who Cooperated At Least Three Times

Table: ActorDirector +-------------+---------+ | Column Name | Type | +-------------+---------+ | actor_id | int | | director_id | int | | timestamp | int | ...

Foundations Track
aggregation
filtering
I
IshaSQL

Foundations Track

Easy
15 min
Not Boring Movies

Table: Cinema +----------------+----------+ | Column Name | Type | +----------------+----------+ | id | int | | movie | varchar | | description | varchar | |...

Foundations Track
filtering
I
IshaSQL

Foundations Track

Easy
15 min
Classes With at Least 5 Students

Table: Courses +-------------+---------+ | Column Name | Type | +-------------+---------+ | student | varchar | | class | varchar | +-------------+---------+...

Foundations Track
aggregation
filtering
I
IshaSQL

Foundations Track

Easy
15 min
Big Countries

Table: World +-------------+---------+ | Column Name | Type | +-------------+---------+ | name | varchar | | continent | varchar | | area | int | | populatio...

Foundations Track
filtering
I
IshaSQL

Foundations Track

Easy
15 min
Customer Placing the Largest Number of Orders

Table: Orders +-----------------+----------+ | Column Name | Type | +-----------------+----------+ | order_number | int | | customer_number | int | +--------...

Foundations Track
aggregation
I
IshaSQL

Foundations Track

Easy
15 min
Find Customer Referee

Table: Customer +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | name | varchar | | referee_id | int | +------------...

Foundations Track
filtering
I
IshaSQL

Foundations Track

Easy
15 min
Rising Temperature

Table: Weather +---------------+---------+ | Column Name | Type | +---------------+---------+ | id | int | | recordDate | date | | temperature | int | +-----...

Foundations Track
date functions
filtering
I
IshaSQL

Foundations Track

Easy
15 min
Duplicate Emails

Table: Person +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | email | varchar | +-------------+---------+ id is the...

Foundations Track
aggregation
filtering
I
IshaSQL

Foundations Track

Easy
15 min
Employees Earning More Than Their Managers

Table: Employee +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | name | varchar | | salary | int | | managerId | int...

Foundations Track
filtering
I
IshaSQL

Foundations Track

Easy
15 min
Calculate Special Bonus

Table: Employees +-------------+---------+ | Column Name | Type | +-------------+---------+ | employee_id | int | | name | varchar | | salary | int | +------...

Foundations Track
filtering
I
IshaSQL

Foundations Track

Easy
15 min
Percentage of Users Attended a Contest

Table: Users +-------------+---------+ | Column Name | Type | +-------------+---------+ | user_id | int | | user_name | varchar | +-------------+---------+ u...

Foundations Track
aggregation
I
IshaSQL

Foundations Track

Easy
15 min
Game Play Analysis I

IshaSQL is reviewing game play analysis i through a scorecard. Table: Activity +--------------+---------+ | Column Name | Type | +--------------+---------+ |...

Foundations Track
aggregation
I
IshaSQL

Foundations Track

Medium
25 min
Find Users with High Token Usage

Table: prompts +-------------+---------+ | Column Name | Type | +-------------+---------+ | user_id | int | | prompt | varchar | | tokens | int | +----------...

Foundations Track
Pro
aggregation
filtering
I
IshaSQL

Foundations Track

Medium
25 min
Find Loyal Customers

Table: customer_transactions +------------------+---------+ | Column Name | Type | +------------------+---------+ | transaction_id | int | | customer_id | in...

Foundations Track
Pro
aggregation
filtering
I
IshaSQL

Foundations Track

Medium
25 min
Last Person to Fit in the Bus

Table: Queue +-------------+---------+ | Column Name | Type | +-------------+---------+ | person_id | int | | person_name | varchar | | weight | int | | turn...

Foundations Track
Pro
filtering
I
IshaSQL

Foundations Track

Medium
25 min
Reformat Department Table

Table: Department +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | revenue | int | | month | varchar | +------------...

Foundations Track
Pro
aggregation
I
IshaSQL

Foundations Track

Medium
25 min
Immediate Food Delivery II

Table: Delivery +-----------------------------+---------+ | Column Name | Type | +-----------------------------+---------+ | delivery_id | int | | customer_i...

Foundations Track
Pro
aggregation
filtering
I
IshaSQL

Foundations Track

Medium
25 min
Customers Who Bought All Products

Table: Customer +-------------+---------+ | Column Name | Type | +-------------+---------+ | customer_id | int | | product_key | int | +-------------+-------...

Foundations Track
Pro
aggregation
filtering
I
IshaSQL

Foundations Track

Medium
25 min
Swap Consecutive Students

Table: Seat +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | student | varchar | +-------------+---------+ id is the...

Foundations Track
Pro
filtering
I
IshaSQL

Foundations Track

Medium
25 min
Tree Node

Table: Tree +-------------+------+ | Column Name | Type | +-------------+------+ | id | int | | p_id | int | +-------------+------+ id is the column with uni...

Foundations Track
Pro
aggregation
filtering
I
IshaSQL

Foundations Track

Medium
25 min
Investments in 2016

Table: Insurance +-------------+-------+ | Column Name | Type | +-------------+-------+ | pid | int | | tiv_2015 | float | | tiv_2016 | float | | lat | float...

Foundations Track
Pro
filtering
aggregation
I
IshaSQL

Foundations Track

Medium
25 min
Rank Scores

Table: Scores +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | score | decimal | +-------------+---------+ id is the...

Foundations Track
Pro
aggregation
filtering
I
IshaSQL

Foundations Track

Medium
25 min
Exchange Seats

Use this IshaSQL scorecard to work on exchange seats. Table: Seat +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | s...

Foundations Track
Pro
filtering
I
IshaSQL

Foundations Track

Medium
25 min
Friend Requests II: Who Has The Most Friends

IshaSQL wants a scorecard for friend requests ii: who has the most friends. Table: RequestAccepted +----------------+---------+ | Column Name | Type | +-----...

Foundations Track
Pro
aggregation
I
IshaSQL

Interview Core Track

Easy
15 min
Bank Account Summary II

Table: Users +--------------+---------+ | Column Name | Type | +--------------+---------+ | account | int | | name | varchar | +--------------+---------+ acc...

Interview Core Track
joins
aggregation
I
IshaSQL

Interview Core Track

Easy
15 min
Customer Who Visited but Did Not Make Any Transactions

Table: Visits +-------------+---------+ | Column Name | Type | +-------------+---------+ | visit_id | int | | customer_id | int | +-------------+---------+ v...

Interview Core Track
joins
filtering
I
IshaSQL

Interview Core Track

Easy
15 min
Top Travellers

Table: Users +---------------+---------+ | Column Name | Type | +---------------+---------+ | id | int | | name | varchar | +---------------+---------+ id is...

Interview Core Track
joins
aggregation
I
IshaSQL

Interview Core Track

Easy
15 min
Replace Employee ID With The Unique Identifier

Table: Employees +---------------+---------+ | Column Name | Type | +---------------+---------+ | id | int | | name | varchar | +---------------+---------+ i...

Interview Core Track
joins
I
IshaSQL

Interview Core Track

Easy
15 min
List the Products Ordered in a Period

Table: Products +------------------+---------+ | Column Name | Type | +------------------+---------+ | product_id | int | | product_name | varchar | | produc...

Interview Core Track
joins
aggregation
I
IshaSQL

Interview Core Track

Easy
15 min
Project Employees I

Table: Project +-------------+---------+ | Column Name | Type | +-------------+---------+ | project_id | int | | employee_id | int | +-------------+---------...

Interview Core Track
joins
aggregation
I
IshaSQL

Interview Core Track

Easy
15 min
Sales Person

Table: SalesPerson +-----------------+---------+ | Column Name | Type | +-----------------+---------+ | sales_id | int | | name | varchar | | salary | int | ...

Interview Core Track
joins
filtering
I
IshaSQL

Interview Core Track

Easy
15 min
Customers Who Never Order

Table: Customers +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | name | varchar | +-------------+---------+ id is t...

Interview Core Track
joins
filtering
I
IshaSQL

Interview Core Track

Easy
15 min
Sales Analysis III

Table: Product +--------------+---------+ | Column Name | Type | +--------------+---------+ | product_id | int | | product_name | varchar | | unit_price | in...

Interview Core Track
joins
aggregation
I
IshaSQL

Interview Core Track

Medium
25 min
Find COVID Recovery Patients

Table: patients +-------------+---------+ | Column Name | Type | +-------------+---------+ | patient_id | int | | patient_name| varchar | | age | int | +----...

Interview Core Track
Pro
joins
date functions
I
IshaSQL

Interview Core Track

Medium
25 min
Find Product Recommendation Pairs

Table: ProductPurchases +-------------+------+ | Column Name | Type | +-------------+------+ | user_id | int | | product_id | int | | quantity | int | +-----...

Interview Core Track
Pro
joins
aggregation
I
IshaSQL

Interview Core Track

Medium
25 min
Analyze Subscription Conversion

Table: UserActivity +------------------+---------+ | Column Name | Type | +------------------+---------+ | user_id | int | | activity_date | date | | activit...

Interview Core Track
Pro
joins
aggregation
I
IshaSQL

Interview Core Track

Medium
25 min
Confirmation Rate

Table: Signups +----------------+----------+ | Column Name | Type | +----------------+----------+ | user_id | int | | time_stamp | datetime | +--------------...

Interview Core Track
Pro
joins
aggregation
I
IshaSQL

Interview Core Track

Medium
25 min
Movie Rating

Table: Movies +---------------+---------+ | Column Name | Type | +---------------+---------+ | movie_id | int | | title | varchar | +---------------+--------...

Interview Core Track
Pro
aggregation
joins
I
IshaSQL

Interview Core Track

Medium
25 min
Students and Examinations

Table: Students +---------------+---------+ | Column Name | Type | +---------------+---------+ | student_id | int | | student_name | varchar | +-------------...

Interview Core Track
Pro
joins
aggregation
I
IshaSQL

Interview Core Track

Medium
25 min
Average Selling Price

Table: Prices +---------------+---------+ | Column Name | Type | +---------------+---------+ | product_id | int | | start_date | date | | end_date | date | |...

Interview Core Track
Pro
joins
aggregation
I
IshaSQL

Interview Core Track

Medium
25 min
2019 Buyer Orders

Table: Users +----------------+---------+ | Column Name | Type | +----------------+---------+ | user_id | int | | join_date | date | | favorite_brand | varch...

Interview Core Track
Pro
joins
aggregation
I
IshaSQL

Interview Core Track

Medium
25 min
Next Day Login Fraction

Table: Activity +--------------+---------+ | Column Name | Type | +--------------+---------+ | player_id | int | | device_id | int | | event_date | date | | ...

Interview Core Track
Pro
aggregation
joins
I
IshaSQL

Interview Core Track

Medium
25 min
Product Sales Analysis III

Table: Sales +-------------+-------+ | Column Name | Type | +-------------+-------+ | sale_id | int | | product_id | int | | year | int | | quantity | int | ...

Interview Core Track
Pro
joins
aggregation
I
IshaSQL

Interview Core Track

Medium
25 min
Department Highest Salary

Table: Employee +--------------+---------+ | Column Name | Type | +--------------+---------+ | id | int | | name | varchar | | salary | int | | departmentId ...

Interview Core Track
Pro
joins
filtering
I
IshaSQL

Interview Core Track

Medium
25 min
Market Analysis I

IshaSQL wants a scorecard for market analysis i. Table: Users +----------------+---------+ | Column Name | Type | +----------------+---------+ | user_id | in...

Interview Core Track
Pro
joins
aggregation
I
IshaSQL

Interview Core Track

Medium
25 min
Game Play Analysis IV

At IshaSQL, analysts are preparing a scorecard focused on game play analysis iv. Table: Activity +--------------+---------+ | Column Name | Type | +---------...

Interview Core Track
Pro
aggregation
joins
I
IshaSQL

Interview Core Track

Hard
35 min
Find Emotionally Consistent Users

Table: reactions +--------------+---------+ | Column Name | Type | +--------------+---------+ | user_id | int | | content_id | int | | reaction | varchar | +...

Interview Core Track
aggregation
filtering
I
IshaSQL

Interview Core Track

Hard
35 min
Most Common Course Pairs

Table: course_completions +-------------------+---------+ | Column Name | Type | +-------------------+---------+ | user_id | int | | course_id | int | | cour...

Interview Core Track
Pro
filtering
aggregation
I
IshaSQL

Interview Core Track

Hard
35 min
Find Books with Polarized Opinions

Table: books +-------------+---------+ | Column Name | Type | +-------------+---------+ | book_id | int | | title | varchar | | author | varchar | | genre | ...

Interview Core Track
Pro
joins
aggregation
I
IshaSQL

Interview Core Track

Hard
35 min
Find Consistently Improving Employees

Table: employees +-------------+---------+ | Column Name | Type | +-------------+---------+ | employee_id | int | | name | varchar | +-------------+---------...

Interview Core Track
Pro
filtering
I
IshaSQL

Interview Core Track

Hard
35 min
Seasonal Sales Analysis

Table: sales +---------------+---------+ | Column Name | Type | +---------------+---------+ | sale_id | int | | product_id | int | | sale_date | date | | qua...

Interview Core Track
Pro
joins
aggregation
I
IshaSQL

Interview Core Track

Hard
35 min
Restaurant Growth

Table: Customer +---------------+---------+ | Column Name | Type | +---------------+---------+ | customer_id | int | | name | varchar | | visited_on | date |...

Interview Core Track
Pro
aggregation
I
IshaSQL

Interview Core Track

Hard
35 min
Human Traffic of Stadium

Table: Stadium +---------------+---------+ | Column Name | Type | +---------------+---------+ | id | int | | visit_date | date | | people | int | +----------...

Interview Core Track
Pro
filtering
I
IshaSQL

Interview Core Track

Hard
35 min
Trips and Users

Table: Trips +-------------+----------+ | Column Name | Type | +-------------+----------+ | id | int | | client_id | int | | driver_id | int | | city_id | in...

Interview Core Track
Pro
joins
aggregation
I
IshaSQL

Interview Core Track

Hard
35 min
Department Top Three Salaries

Table: Employee +--------------+---------+ | Column Name | Type | +--------------+---------+ | id | int | | name | varchar | | salary | int | | departmentId ...

Interview Core Track
Pro
joins
filtering
I
IshaSQL

Interview Core Track

Hard
35 min
Find Stores with Inventory Imbalance

Table: stores +-------------+---------+ | Column Name | Type | +-------------+---------+ | store_id | int | | store_name | varchar | | location | varchar | +...

Interview Core Track
Pro
aggregation
filtering