Order Volume, Customer by Customer :Calculate Total Orders Per Customer with Individual Order Details Intermediate
Count total orders per customer and display them alongside each order.
Xorthax is reviewing his intergalactic sales data. Help him count the total number of orders placed by each customer at his trading post. Display each order's details along with the total number of orders for that customer.
Write Your Query
This reflects tracking how many purchases each customer has made, useful for loyalty analysis and engagement metrics.
You will practice counting grouped values and displaying both aggregated and detailed records together.
This problem is labeled as Intermediate. It assumes you’ve written a few window function queries before, but you don’t need to be an expert. Use the hints and explanations if you get stuck — they’re there to help you think through the logic.
Yes. Every problem comes with optional hints you can reveal one at a time, plus a fully worked step-by-step solution. You decide how much help you want while practicing.
All problems on PracticeWindowFunctions.com are completely free and can be solved without creating an account. Right now there are over 80 practice problems, with new ones added regularly.
SQL Cookbook (O’Reilly)
Practical SQL recipes for real-world querying—great complement to hands-on practice.
(Affiliate link – as an Amazon Associate I earn from qualifying purchases.)