← Curriculum
Lab 2A
SQL Dashboard Builder
Intermediate
Mark Complete ✓
📋 Schema
📁 employees
id
INT
name
TEXT
dept
TEXT
salary
REAL
hire_date
TEXT
📁 sales
product
TEXT
region
TEXT
amount
REAL
date
TEXT
📁 products
id
INT
name
TEXT
category
TEXT
price
REAL
📑 Templates
SELECT * FROM employees LIMIT 10
AVG salary by dept
WHERE salary > 70000
Sales by region
JOIN products + sales
SQL Editor
SELECT dept, ROUND(AVG(salary), 0) AS avg_salary, COUNT(*) AS headcount FROM employees GROUP BY dept ORDER BY avg_salary DESC;
▶ Run Query
↺ Reset DB
Results
Run a query to see results here.
🎯 Challenge
"Write a query that shows average salary by department. Which department is overpaid relative to the company median?"
AVG by dept query works
Identified high-salary dept
Used a WHERE filter
Tried a JOIN query
📤 Export Chart
📊 Auto Chart
Run a query →
📊
Run a query to generate a chart
Loading SQL engine...