Code Playground

Write and run real code right in your browser, no setup required.

Language:

A practice database (employees, departments, customers, products, orders) is loaded fresh before every run, great for practicing SELECT, but any INSERT/UPDATE/DELETE you make resets on the next run.

SQL Statement:

-- A ready-to-query practice database is loaded automatically before every run —
-- no CREATE TABLE needed. Available tables:
--   departments  (id, name, location)
--   employees    (id, first_name, last_name, email, department_id, job_title, salary, hire_date, manager_id)
--   customers    (id, customer_name, city, country, signup_date)
--   products     (id, product_name, category, price, stock_quantity)
--   orders       (id, customer_id, employee_id, order_date, status)
--   order_items  (id, order_id, product_id, quantity, unit_price)

SELECT * FROM employees WHERE department_id = 1;

Result:

Edit the code above, and click "Run »" to see the result.

Want a step-by-step course instead?

Every lesson comes with worked examples you can run right here, start from the basics and work up to advanced topics.