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.
Amazon
Foundations Track
Departments Above Average Pay
Use this Amazon scorecard to work on departments above average pay. Return each department_id whose average salary exceeds the company average salary for Mar...
Amazon
Foundations Track
2024 App Click Volume
Amazon wants a portfolio scan for 2024 app click volume. Return each app_id and the total number of click events recorded in 2024. Sort by app_id.
Amazon
Foundations Track
Frequent Support Callers
At Amazon, analysts are preparing a readout focused on frequent support callers. Return the distinct policy_holder_id values for members who made at least 3 ...
Amazon
Foundations Track
Late Shipment Rate By Carrier
At Amazon, analysts are preparing a readout focused on late shipment rate by carrier. Return the percentage of shipments that arrived late by carrier_name. O...
Amazon
Foundations Track
Second-highest Salary
At Amazon, analysts are preparing a performance snapshot focused on second-highest salary. Return the second-highest salary amount in the table as second_hig...
Amazon
Foundations Track
Creators With Multiple 2024 Posts
Use this Amazon analysis pass to work on creators with multiple 2024 posts. Return each creator_id that posted at least two items in 2024. Sort by creator_id.
Amazon
Foundations Track
Top Sellers By Gross Sales
Use this Amazon planning note to work on top sellers by gross sales. Return the top 3 sellers by total_gross_sales. Output seller_id and total_gross_sales so...
Amazon
Foundations Track
Number Of Unique Subjects Taught By Each Teacher
Amazon is reviewing number of unique subjects taught by each teacher through a diagnostic pass. Return each app_id and the total number of click events recor...
Amazon
Foundations Track
Odd And Even Transactions
Amazon wants a operations review for odd and even transactions. Return separate totals for odd-numbered and even-numbered measurement days. Return two column...
Amazon
Foundations Track
Loss-Making Drug Totals
Amazon is reviewing loss-making drug totals through a scorecard. Return each manufacturer with the number of loss-making drugs and the total absolute loss. S...
Amazon
Foundations Track
04 Easy Amazon Purchasing Activity By Product Type
-- purchasing activity by product type -- SELECT t1.order_date, t1.product_type, ( SELECT SUM(quantity) FROM total_trans AS t2 WHERE t2.order_date <= t1.orde...
Amazon
Foundations Track
09. Average Review Ratings [Amazon Interview]
/* Given the reviews table, write a query to get the average stars for each product every month. The output should include the month in numerical value, prod...
Amazon
Foundations Track
Average Product Review Ratings
Amazon is reviewing average product review ratings through a scorecard. The product quality team wants monthly review score reporting. For each product and m...
Amazon
Foundations Track
Category Revenue Leaders
During June 2024, each category had multiple products generating revenue. Return the highest-grossing product_id in each category along with category and tot...
Amazon
Foundations Track
05 Medium Amazon Highest Grossing Items
-- highest grossing items -- WITH top_sales AS ( SELECT category, product, SUM(spend) AS total_spend FROM product_spend WHERE DATE_PART('year', transaction_d...
Amazon
Interview Core Track
2128 Book Sales
SELECT b.book_id, COALESCE(SUM(b.unit_price*od.quantity), 0) as total_sales FROM amazon_books b LEFT JOIN amazon_books_order_details od ON b.book_id=od.book_...
Amazon
Interview Core Track
Store Refund Share
Retail finance wants to compare refund pressure by store for April 2024 orders. Return store_id, total_sales, refunded_amount, and refund_pct rounded to two ...