⚡ Online PostgreSQL / SQL Compiler

🐘

🐘 Learn PostgreSQL / SQLMaster PostgreSQL Modeling, Indexing & Query Optimization

SQLmain.sql

14px

-- Relational SQL Playground (PostgreSQL / SQLite Engine)
-- 1. Create Tables
CREATE TABLE customers (
    id INTEGER PRIMARY KEY,
    name TEXT NOT NULL,
    email TEXT UNIQUE NOT NULL,
    country TEXT NOT NULL
);

CREATE TABLE orders (
    id INTEGER PRIMARY KEY,
    customer_id INTEGER REFERENCES customers(id),
    product_name TEXT NOT NULL,
    amount NUMERIC(10, 2) NOT NULL,
    status TEXT NOT NULL
);

-- 2. Insert Sample Data
INSERT INTO customers VALUES (1, 'Alice Johnson', 'alice@example.com', 'USA');
INSERT INTO customers VALUES (2, 'Bob Smith', 'bob@example.com', 'Canada');
INSERT INTO customers VALUES (3, 'Charlie Lee', 'charlie@example.com', 'UK');
INSERT INTO customers VALUES (4, 'Deepa Patel', 'deepa@example.com', 'India');

INSERT INTO orders VALUES (101, 1, 'Full-Stack All Access', 199.00, 'COMPLETED');
INSERT INTO orders VALUES (102, 1, 'Java Enterprise Track', 99.00, 'COMPLETED');
INSERT INTO orders VALUES (103, 2, 'Python AI Bootcamp', 149.00, 'COMPLETED');
INSERT INTO orders VALUES (104, 3, 'DevOps & Kubernetes', 129.00, 'PENDING');
INSERT INTO orders VALUES (105, 4, 'Full-Stack All Access', 199.00, 'COMPLETED');

-- 3. Query: Top Customers with Orders & Spending
SELECT 
    c.name AS customer_name,
    c.country,
    COUNT(o.id) AS total_orders,
    SUM(o.amount) AS total_spent
FROM customers c
JOIN orders o ON c.id = o.customer_id
WHERE o.status = 'COMPLETED'
GROUP BY c.id, c.name, c.country
ORDER BY total_spent DESC;

Press ▶ Run Code or hit Ctrl + Enter to execute.

Supports standard output, errors, input prompts, and syntax errors.

Explore All Compiler Sandboxes:

☕Java 🐍Python 🟨JavaScript 🔷TypeScript 🐘PostgreSQL / SQL●⚛️React.js 🅰️Angular 🌐HTML / CSS / JS ⚙️C++🧠Algorithms & DSA

🐘SQL Engine & Visual Table Grid

Online SQL & PostgreSQL Table Query Playground

Experiment with relational schemas, joins, window functions, and analytics queries with instant visual spreadsheet-style grid outputs.

⚡

Instant Zero-Setup Execution

Run code immediately in your browser with zero downloads, installation, or environment setup.

⌨️

Interactive Standard Input (stdin)

Full support for interactive scanners, terminal arguments, and multi-line user inputs.

🤖

AI Error Diagnosis & 1-Click Fixes

Get instant What • Why • How error explanations and auto-apply fixes directly into your editor.

🔗

1-Click Code Sharing

Generate instant shareable URLs to collaborate with teammates, classmates, or instructors.

📖PostgreSQL / SQL Quick Syntax Reference

SELECT with Aggregation & JOIN

SELECT 
  c.name AS category,
  COUNT(p.id) AS total_products,
  ROUND(AVG(p.price), 2) AS avg_price
FROM products p
JOIN categories c ON p.category_id = c.id
GROUP BY c.name
ORDER BY total_products DESC;

💡 Run multi-table joins and aggregation queries to visualize the output directly in the Table Grid tab.

❓Frequently Asked Questions about Online PostgreSQL / SQL Compiler

Can I see my SQL results in a visual table format?▲

Yes! Click the '📊 Table' tab in the output pane to view results rendered in clean, sortable columns.

Loading Lesson & Content…

Fetching tutorial explanations & code examples

Online SQL & PostgreSQL Table Query Playground

Experiment with relational schemas, joins, window functions, and analytics queries with instant visual spreadsheet-style grid outputs.

⚡

Instant Zero-Setup Execution

Run code immediately in your browser with zero downloads, installation, or environment setup.

⌨️

Interactive Standard Input (stdin)

Full support for interactive scanners, terminal arguments, and multi-line user inputs.

🤖

AI Error Diagnosis & 1-Click Fixes

Get instant What • Why • How error explanations and auto-apply fixes directly into your editor.

🔗

1-Click Code Sharing

Generate instant shareable URLs to collaborate with teammates, classmates, or instructors.

SELECT c.name AS category, COUNT(p.id) AS total_products, ROUND(AVG(p.price), 2) AS avg_price FROM products p JOIN categories c ON p.category_id = c.id GROUP BY c.name ORDER BY total_products DESC;

⚡ Online PostgreSQL / SQL Compiler

Online SQL & PostgreSQL Table Query Playground

Ready to Master PostgreSQL / SQL? Learn with Structured Lessons

PostgreSQL Database Architecture

📖PostgreSQL / SQL Quick Syntax Reference

❓Frequently Asked Questions about Online PostgreSQL / SQL Compiler

⚡ Online PostgreSQL / SQL Compiler

Online SQL & PostgreSQL Table Query Playground

Ready to Master PostgreSQL / SQL? Learn with Structured Lessons

PostgreSQL Database Architecture

📖PostgreSQL / SQL Quick Syntax Reference

❓Frequently Asked Questions about Online PostgreSQL / SQL Compiler