Structured Query Language (SQL) is used to manage and retrieve data from databases. It is particularly suited to relational data where the data has well-defined relationships.

More SQL Please is designed to be a simple, readable introduction to the SQL language and related database concepts. Every SQL statement is run fully in your browser using the SQLite database engine and sql.js!

You can edit, re-run and reset every example on this site. Each topic utilizes a particular set of database tables, known as a schema, which can be shown or hidden at the top of the page anytime.

The topics below are loosely ordered from top to bottom by increasing complexity. Each topic attempts to cover a single keyword or concept but may draw upon previously covered concepts. This is because each is a building block that when combined together show how powerful SQL can be as a data querying and manipulation language.