SQL sandbox

Type any SQL and press Run (or Ctrl+Enter). Show how it runs draws each step. Changes you make (new tables, updates) last until you reset or leave the page.

SELECT * FROM orders LIMIT 10
Tables (tap one to look inside)
  • 4 rows · region_id, region_name
  • 12 rows · store_id, store_name, city, province, region_id, opened_on, size_sqft
  • 10 rows · category_id, category_name, department
  • 61 rows · product_id, product_name, category_id, brand, unit_price, unit_cost, launched_on
  • 603 rows · customer_id, first_name, last_name, email, city, province, joined_on, loyalty_tier
  • 38 rows · employee_id, name, store_id, role, manager_id, hired_on, salary
  • 7 rows · promo_id, promo_name, start_date, end_date, discount
  • 4,064 rows · order_id, customer_id, store_id, order_date, channel, status, promo_id
  • 7,310 rows · order_id, product_id, quantity, unit_price, discount
  • 204 rows · return_id, order_id, product_id, return_date, reason
  • 5 rows · id, name, city
  • 6 rows · order_id, customer_id, item, amount

What each table holds

This is SQLite, running on your device. For your own CSV or Excel files, use the SQL playground.