>_
query
scratch
Learn
Practice
Playground
Mock
Dashboard
Search
⌘K
SQLite
All products
Revenue by category
Top customers
Employees & managers
Running revenue (window)
Run
⌘↵
1
2
3
4
5
6
7
8
9
10
11
-- Welcome to the SQL Playground. -- A sample e-commerce database is already loaded — run any SQL you like. -- Press ⌘/Ctrl + Enter to run. SELECT c.name AS category, COUNT(*) AS products, ROUND(AVG(p.price), 2) AS avg_price FROM products p JOIN categories c ON p.category_id = c.category_id GROUP BY c.name ORDER BY avg_price DESC;
Run a query to see results
Results will appear here.