Skip to content
Varnook
All courses
SQLIntermediate

SQL Project: Shop Reporting

Build a shop report from real relational data: select relevant orders, calculate line revenue and retain customers who have not ordered.

Recommended first: SQL for Data Analysis. This course builds on it.

Start courseView syllabus

Free to browse. You sign in at the first lesson so your progress is saved.

What you will be able to do

  • Turn a short project brief into working code
  • Check edge cases instead of relying on one example
  • Produce a useful summary from a realistic dataset

Syllabus

1 module and 3 lessons. Each lesson is a short read followed by an exercise with tests.

Module 1

Build and check

Build a shop report from real relational data: select relevant orders, calculate line revenue and retain customers who have not ordered.3 lessons, about 1 hour
  1. 1Select delivered ordersScope a report to fulfilled business activity.20 min
  2. 2Calculate delivered revenueJoin order lines to products without double-counting order-level data.20 min
  3. 3Include customers with no ordersBuild a complete customer report with a left join.20 min