Practise SQL online. On real PostgreSQL.
40 interview questions, Easy to Hard, on one Indian shop’s data. Write a query, run it, check it. Free, in your browser, no sign-up.
Question 1 of 40
Easy SolvedFind delivered UPI orders from October 2026, newest first
List the delivered orders paid by UPI in October 2026: order_id, customer_id, order_date and amount, newest first.
Filter with WHERE and a date range, on or after 1 October and before 1 November. Then ORDER BY order_date DESC.
Write your query here, then press RunYour result shows here.
Run your query to see its rows, then check it against the answer.
How the lab works
Real PostgreSQL
PostgreSQL 18, compiled to run inside your browser. Your queries behave as they would on a server, errors included.
Checked on fresh data
Check my answer runs your query and ours on a fresh copy of the shop and compares the rows. Any query that gets the right rows counts, not only ours.
Stays in your browser
Your queries never leave your device, and your progress is kept on it. Free, with no sign-up and no limit.
Practising for a MySQL round? Most of the SQL here runs the same in both. Where MySQL differs, the answer shows its form too, and the guide explains each difference: SQL interview questions, with answers.