SQL Playground - SimpleDB

SQL Editor

Results

Execute a query to see results

📋 Setup & Sample Data

Click any command below to load it into the editor, then click Execute to run it step by step.

Step 1: Create Tables

Create Users Table

CREATE TABLE users (id INT PRIMARY KEY, name VARCHAR(100), email VARCHAR(100), status VARCHAR(50), created_at TIMESTAMP);

Create Tasks Table

CREATE TABLE tasks (id INT PRIMARY KEY, title VARCHAR(200), description TEXT, user_id INT, status VARCHAR(50), priority VARCHAR(50), created_at TIMESTAMP);

Step 2: Insert Users

Insert User 1

INSERT INTO users VALUES (1, 'John Doe', 'john@example.com', 'active', '2026-01-01');

Insert User 2

INSERT INTO users VALUES (2, 'Jane Smith', 'jane@example.com', 'active', '2026-01-02');

Insert User 3

INSERT INTO users VALUES (3, 'Bob Johnson', 'bob@example.com', 'inactive', '2026-01-03');

Step 3: Insert Tasks

Insert Task 1

INSERT INTO tasks VALUES (1, 'Complete Project', 'Finish database project', 1, 'In Progress', 'High', '2026-01-05');

Insert Task 2

INSERT INTO tasks VALUES (2, 'Write Tests', 'Add unit tests', 2, 'Open', 'High', '2026-01-06');

Insert Task 3

INSERT INTO tasks VALUES (3, 'Update Docs', 'Update README', 3, 'Completed', 'Medium', '2026-01-03');

Step 4: Query & Verify

Select All Users

SELECT * FROM users;

Select All Tasks

SELECT * FROM tasks;

Join Users & Tasks

SELECT u.name, t.title FROM users u JOIN tasks t ON u.id = t.user_id;

Group by Status

SELECT status, COUNT(*) FROM users GROUP BY status;

⚡ Quick Load All

Load Complete Setup

Create tables + Insert all users + Insert all tasks + Count records