Practice Makes Perfect

You've learned SQL syntax, explored aggregate functions, mastered joins, and understood transactions. Now it's time to practice. Reading about SQL and writing SQL are two very different skills – the only way to become proficient is through hands-on experience.

This lesson provides an interactive SQL query emulator that runs entirely in your browser. It uses the same e-commerce schema you've seen throughout the SQL lessons: Users, Categories, Products, Orders, and OrderItems. The database is pre-populated with realistic test data.

You can write queries, execute them instantly, and see results – all without installing a database server or setting up any infrastructure. The emulator supports the core SQL features you've learned, and its logic has been thoroughly tested against the challenge queries below to ensure accuracy and reliability:

• SELECT with specific columns or *
• WHERE clauses with comparison operators (=, >, <, >=, <=, !=)
• AND, OR, NOT logical operators
• IN, BETWEEN, LIKE operators
• ORDER BY with ASC/DESC
• LIMIT for result pagination
• Aggregate functions: COUNT(), SUM(), AVG(), MIN(), MAX()
• GROUP BY with HAVING
• INNER JOIN and LEFT JOIN
• UNION and UNION ALL
• CASE expressions
• COALESCE and NULLIF
• EXISTS and NOT EXISTS

⚠️ Please note: while the emulator has been validated on these queries, more advanced or untested SQL patterns may not behave exactly as they would in a production database.

The challenges below start simple and gradually increase in complexity, helping you build confidence and proficiency.

Database Schema

Here's the e-commerce database structure you'll be working with. Understanding these relationships is crucial for writing effective queries, especially when using JOIN operations.

The Query Emulator

Below is the interactive SQL emulator. Type your queries in the text area and click "Run Query" to see results. The emulator shows you the resulting data table, the number of rows returned, and any error messages if your query has syntax issues.

Practice Challenges

Work through these challenges to build your SQL skills. Start with Level 1 and progress to more complex queries. Try solving each challenge before looking at the solution.

Level 1: Basic Queries

SELECT * FROM Users;

SELECT ProductId, Name, Price FROM Products;

SELECT * FROM Users WHERE IsActive = 1;

SELECT * FROM Products WHERE Price > 50;

SELECT * FROM Products ORDER BY Price DESC;

Level 2: Filtering and Sorting

SELECT * FROM Orders
WHERE Status = 'Completed' AND TotalAmount > 100;

SELECT * FROM Products
WHERE Price BETWEEN 20 AND 100;

SELECT * FROM Users
WHERE Email LIKE '%gmail.com%';

SELECT * FROM Products
ORDER BY Price DESC
LIMIT 5;

SELECT * FROM Orders
WHERE Status IN ('Pending', 'Processing');

Level 3: Aggregate Functions

SELECT COUNT(*) AS TotalUsers FROM Users;

SELECT AVG(Price) AS AveragePrice FROM Products;

SELECT SUM(TotalAmount) AS TotalRevenue
FROM Orders
WHERE Status = 'Completed';

SELECT MIN(Price) AS MinPrice, MAX(Price) AS MaxPrice
FROM Products;

Level 4: GROUP BY and Aggregation

SELECT UserId, COUNT(*) AS OrderCount
FROM Orders
GROUP BY UserId;

SELECT CategoryId,
       AVG(Price) AS AvgPrice,
       SUM(StockQuantity) AS TotalStock
FROM Products
GROUP BY CategoryId;

SELECT UserId, COUNT(*) AS OrderCount
FROM Orders
GROUP BY UserId
HAVING COUNT(*) > 2;

SELECT Status, COUNT(*) AS Count
FROM Orders
GROUP BY Status
ORDER BY Count DESC;

Level 5: JOINs

SELECT o.OrderId, o.OrderDate, o.TotalAmount,
       u.FirstName, u.LastName
FROM Orders o
INNER JOIN Users u ON o.UserId = u.UserId;

SELECT p.ProductId, p.Name, p.Price, c.CategoryName
FROM Products p
INNER JOIN Categories c ON p.CategoryId = c.CategoryId;

SELECT u.UserId, u.Email, COUNT(o.OrderId) AS OrderCount
FROM Users u
LEFT JOIN Orders o ON u.UserId = o.UserId
GROUP BY u.UserId, u.Email;

SELECT o.OrderId, oi.Quantity, p.Name, oi.UnitPrice
FROM Orders o
INNER JOIN OrderItems oi ON o.OrderId = oi.OrderId
INNER JOIN Products p ON oi.ProductId = p.ProductId;

Level 6: Advanced Queries

SELECT * FROM Products
WHERE Price > (SELECT AVG(Price) FROM Products);

SELECT Name, Price,
       CASE
           WHEN Price < 30 THEN 'Budget'
           WHEN Price BETWEEN 30 AND 100 THEN 'Mid-Range'
           ELSE 'Premium'
       END AS PriceCategory
FROM Products;

SELECT UserId, Email, 'Active' AS Status
FROM Users WHERE IsActive = 1
UNION ALL
SELECT UserId, Email, 'Inactive' AS Status
FROM Users WHERE IsActive = 0;

SELECT u.UserId, u.Email,
       COALESCE(SUM(o.TotalAmount), 0) AS TotalRevenue
FROM Users u
LEFT JOIN Orders o ON u.UserId = o.UserId AND o.Status = 'Completed'
GROUP BY u.UserId, u.Email
ORDER BY TotalRevenue DESC;

Keep experimenting with different query combinations. The more you practice, the more natural SQL will become!