Skip to content
KDV Tutors
Sign in

Practise on the real thing.

Real tools in your browser, with data to work on and nothing to install. One account opens every playground.

Sign in to startSee the playgrounds

2 rowsResult 1

What the query returns
topictotal
joins65
window functions30
A query in My database, the PostgreSQL in your browser: CREATE TABLE practice (topic text, minutes int); INSERT INTO practice VALUES ('joins', 25), ('joins', 40), ('window functions', 30); SELECT topic, sum(minutes) AS total FROM practice GROUP BY topic ORDER BY total DESC;

SQL PlaygroundPostgreSQL 18a query in My database

Have Think in SQL?

It prints a code inside: 180 days free.

Sign up with your code

Learning on your own?

Buy a code for 3 months of access.

See pricing

Teaching a class?

One group code for a college or adult class.

Group pricing

The real thing, in your browser

A real engine
Not a simulator: the SQL Playground runs PostgreSQL 18. Your work meets the real engine, error messages and all.
Nothing to install
Everything runs in your browser, on any computer. Your query tabs are saved to your account, so they follow you.
A private database of your own
Next to the shared practice tables, My database runs in your browser: create tables and change rows, and nobody else sees them.

Line 1Failed

[42803]column "practice.topic" must appear in the GROUP BY clause or be used in an aggregate function

At line 1, column 8

The SQL Playground refusing a query that selects topic without grouping by it. PostgreSQL's error: column "practice.topic" must appear in the GROUP BY clause or be used in an aggregate function, at line 1, column 8.

PostgreSQL's own words, for a query it won't run.

Playgrounds

Each one runs real software with data to work on. One account and one code open every playground.

All playgrounds

  • SQL Playground

    PostgreSQL 18, in your browser

    Write real queries on a real PostgreSQL database, from your first SELECT to window functions, CTEs and JSON. Shared practice tables to query, and a private database of your own.

    • Shared practice tables
    • Your own private database
    • A real editor
    • Schema explorer
    • Run history
    • Download results
    Sign in to startWhat's inside
The cover of Think in SQL

Think in SQL

Learn SQL from Zero to Hero with Datasets and an Enterprise-Level Practice Website, by Kapil Dev V.

Every listing the book prints runs in the SQL Playground, numbered as in the book. The code printed inside gives 180 days of access, free.

About the bookBuy on Amazon.in

More books by Kapil Dev V

All books

One price per seat

A code costs for 3 months, 18% GST included. A group code for a class takes off every seat.

See pricing

Have a code? Start now.

Create your account with the code from Think in SQL, or one you buy. Your time starts the day you sign up.

Create an accountSign in

Need help?

Email help@kdvtutors.org or send us a message. We acknowledge every message within 48 hours.

Contact us