threads/company-dashboard/

Create a complete HR analytics dashboard for Acme Corp

[COMPANY_DB] · modules 1-3

threads/ecommerce-intelligence/

Build a weekly sales analytics report for an online store

[STORE_DB] · modules 4-6

threads/school-analytics/

Analyze student and teacher performance for a school district

[SCHOOL_DB] · modules 7-9

Write queries to analyze employee salaries, department payroll, and who earns above average in their own department. Uses subqueries and window functions.

Analyze customer orders, revenue by month, top spenders, and products that never sold. Covers JOINs, aggregation, date functions, and LEFT JOIN patterns.

Query a school database to look at enrollment, GPA by teacher, and courses where no one got an A. Good practice for multi-table JOINs.