SQL Practice

Pick a challenge or write free-form SQL. Runs entirely in your browser.

🎓students(8 rows)

📖courses(9 rows)

📋enrollments(16 rows)

👤customers(5 rows)

📦products(6 rows)

🛒orders(10 rows)

🏦merchants(6 rows)

💳payments(12 rows)

⚠️disputes(5 rows)

📢campaigns(6 rows)

🎯ad_groups(8 rows)

👁️impressions(15 rows)

🏪shops(5 rows)

🏷️listings(10 rows)

💰sales(12 rows)

Sample queries

SQL

Available tables

students

id, name, major, gpa, year, email

courses

id, title, department, credits, instructor

enrollments

id, student_id, course_id, semester, grade

customers

id, name, email, city, joined

products

id, name, category, price, stock

orders

id, customer_id, product_id, quantity, order_date, total

merchants

id, name, category, country, created_date, status

payments

id, merchant_id, amount, currency, status, payment_method, created_date

disputes

id, payment_id, merchant_id, reason, amount, status, created_date

campaigns

id, name, advertiser, budget, objective, status, start_date

ad_groups

id, campaign_id, name, targeting, daily_budget

impressions

id, ad_group_id, campaign_id, platform, clicks, views, cost, date

shops

id, name, owner, plan, country, created_date

listings

id, shop_id, title, category, price, inventory, status

sales

id, listing_id, shop_id, buyer_name, quantity, total, date, status