A Complete Customer × Month Grid (CROSS JOIN)

medium
Unit 22 · Joins0/2 to milestone

Build a grid with every customer and every month that has any orders, showing that customer's revenue in the month, or 0 if they bought nothing. Return name, month (YYYY-MM) and revenue, sorted by name, then month.

Pro problem

Unlock this and every premium problem across all tracks — plus hidden-test grading, advanced AI engineering modules and new content every week.

Start 7-day free trial
query.sql · SQLite
Run your code to see results. ⌘↵ to run · ⌘⇧↵ to submit
A Complete Customer × Month Grid (CROSS JOIN) · TechGradify