Practice intermediate SQL question: Number Each Customer's Invoices Chronologically (ROW_NUMBER)

Solve this interactive intermediate question online in our browser coding environment.

Number Each Customer's Invoices Chronologically (ROW_NUMBER)

intermediate~6 min25 pts

Problem

For every invoice, assign a sequential number within its customer, ordered by InvoiceDate -- so each customer's first invoice is 1, their second is 2, and so on.

Return CustomerId, InvoiceId, InvoiceDate, and InvoiceNumber, ordered by CustomerId then InvoiceNumber.

Schema: Invoice

Column	Type
InvoiceId	INTEGER (Primary Key)
CustomerId	INTEGER (Foreign Key)
InvoiceDate	TIMESTAMP

Window Functions ROW_NUMBER PARTITION BY

📊

📊 View Question Telemetry & Insights

Failure rate, silent bug autopsy & optimal query construction

Inspect →

Master SQL & Data Analytics

Ready to take your skills to the next level? Enroll in our comprehensive Data Analyst Career Track to master SQL, Python, Excel, and Power BI.

Explore the 12-Week Data Analyst Career Track

Number Each Customer's Invoices Chronologically (ROW_NUMBER)

intermediate~6 min25 pts

📊 View Insights

Problem

For every invoice, assign a sequential number within its customer, ordered by InvoiceDate -- so each customer's first invoice is 1, their second is 2, and so on.

Return CustomerId, InvoiceId, InvoiceDate, and InvoiceNumber, ordered by CustomerId then InvoiceNumber.