Free studio

Write code. Run it. See the answer.

Everything runs in your browser. Nothing to install and no account needed. Practise on 91 ready-made tables, or create your own in the editor.

91
ready-made tables
4
languages

Pick a language

SQL, Pandas and PySpark share the same tables, so you can try one question in all three.

Create your own tables

Type the data straight into the editor. Pick the way that suits you. Tables you create live only in your session.

  1. 1Write CREATE TABLE with the columns you want.
  2. 2Add rows with INSERT INTO. Run each statement one after the other.
  3. 3Query it with SELECT, the same as any other table.
SQLExample
CREATE TABLE my_students (id INTEGER, name VARCHAR, marks INTEGER);
INSERT INTO my_students VALUES (1, 'Asha', 78), (2, 'Ravi', 91), (3, 'Meera', 85);
SELECT name, marks FROM my_students WHERE marks > 80;

The 91 ready-made tables

Orders, employees, events, payments and more. Open a table to see its columns, then use the same name in the editor.

Showing 91 of 91 tables