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.
SQL
Query the tables below with SELECT, JOIN and window functions.
91 ready-made tables
Open editor
Pandas
The same tables as DataFrames, named df_orders, df_employees and so on.
91 ready-made tables
Open editor
PySpark
Read any table with spark.table("orders") and build the transformations.
91 ready-made tables
Open editor
Python
A blank editor for loops, functions and small programs.
No tables. Use lists and dictionaries
Open editor
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.
- 1Write CREATE TABLE with the columns you want.
- 2Add rows with INSERT INTO. Run each statement one after the other.
- 3Query it with SELECT, the same as any other table.
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