SQL Playground

The Structured Query Language (SQL) is a language used to manage data held in relational databases.

This tool allows you to create a relational database and query it using SQL.

The database does not persist data between sessions.

SQL query

DROP TABLE IF EXISTS books;

CREATE TABLE books(id INT, name TEXT, author TEXT, year INT);

INSERT INTO books VALUES (1,'The Lord of the Rings','J.R.R. Tolkien',1954);
INSERT INTO books VALUES (2,'The Hobbit','J.R.R. Tolkien',1937);
INSERT INTO books VALUES (3,'Harry Potter and the Philosopher''s Stone','J.K. Rowling',1997);
INSERT INTO books VALUES (4,'Harry Potter and the Chamber of Secrets','J.K. Rowling',1998);

SELECT * FROM books ORDER BY year;

SELECT * FROM books WHERE author = 'J.R.R. Tolkien';1
DROP TABLE IF EXISTS books;
2

3
CREATE TABLE books(id INT, name TEXT, author TEXT, year INT);
4

5
INSERT INTO books VALUES (1,'The Lord of the Rings','J.R.R. Tolkien',1954);
6
INSERT INTO books VALUES (2,'The Hobbit','J.R.R. Tolkien',1937);
7
INSERT INTO books VALUES (3,'Harry Potter and the Philosopher''s Stone','J.K. Rowling',1997);
8
INSERT INTO books VALUES (4,'Harry Potter and the Chamber of Secrets','J.K. Rowling',1998);
9

10
SELECT * FROM books ORDER BY year;
11

12
SELECT * FROM books WHERE author = 'J.R.R. Tolkien';

The SQL query to execute.

Output

Click Execute to run SQL.