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.
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.
· 94 Pro problems · Filter:
Company
Difficulty
Path
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
₹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.
Foundations Track
10. Difference between BETWEEN and IN operators
BETWEEN is used to select rows that match a range of values, whereas the IN operator checks for values in a specified list of values. For example, to find ca...
Foundations Track
9790 Number Of Processed Complaints
SELECT type, COUNT(complaint_id) FILTER(WHERE processed='TRUE') AS processed_complaints, COUNT(complaint_id) FILTER(WHERE processed='FALSE') AS non_processed...
Foundations Track
9789 Find The Total Number Of Approved Friendship Requests In January And February
SELECT COUNT(*) as n_approved FROM facebook_friendship_requests WHERE date_approved BETWEEN '2019-01-01' and '2019-02-28' -- NOTE: solved on first attempt
Foundations Track
Closed Account Ratio
Use this Facebook scorecard to work on closed account ratio. The account integrity team wants the share of accounts that were closed on 2020-01-10. Return on...
Foundations Track
34 Email Table Transformation
-- Each Facebook user can designate a personal email address, a business email address, and a recovery email address. -- Unfortunately, the table is currentl...
Foundations Track
01 Active User Retention
-- Assume you're given a table containing information on Facebook user actions. Write a query to obtain number of monthly active users (MAUs) in July 2022, i...
Interview Core Track
Facebook Pages and Likes Analysis
Assume you're given two tables containing data about Facebook Pages and their respective likes (as in "Like a Facebook Page"). Write a query to return the ID...
Interview Core Track
10088 Liked Posts
SELECT COUNT(DISTINCT p.post_id) as n_posts_with_a_like FROM facebook_posts p JOIN facebook_reactions r ON p.post_id = r.post_id and r.reaction = 'like'
Interview Core Track
Average Employee Popularity By Location
Facebook wants a scorecard for average employee popularity by location. The workplace insights team wants to compare employee survey popularity by office loc...
Interview Core Track
Posts With Heart Reactions
At Facebook, analysts are preparing a scorecard focused on posts with heart reactions. The engagement team wants the full post records for posts that receive...
Interview Core Track
2081 Recommendation System
-- Problem Statement: -- You are given the list of Facebook friends and the list of Facebook pages that users follow. Your task is to create a new recommenda...
Interview Core Track
9777 Successfully Sent Messages
WITH success_or_not as ( SELECT ms.message_id, CASE WHEN mr.message_id IS NOT NULL THEN 1 ELSE 0 END as receive_success FROM facebook_messages_sent ms LEFT J...
Interview Core Track
9793 Average Time Between Steps
WITH step_differences AS ( SELECT feature_id, user_id, step_reached, timestamp, LEAD(timestamp) OVER (PARTITION BY feature_id, user_id ORDER BY step_reached)...