Each Order's Slice of the Galactic Treasury :Calculate Each Order's Percent of Total Revenue Intermediate
Show how much every order contributes to total trading post revenue.
Xorthax wants to understand how much each order contributes to total revenue across his entire trading post on Zlacksys 19. For each order, show the order amount and calculate that order's percent of total revenue. Round the answer to 2 decimal places and order by percent_of_total_revenue descending, orderid.
Write Your Query
This mirrors revenue contribution analysis, where a business measures how much each order contributes to total sales.
You’ll practice comparing individual rows to an overall total, calculating percentage contributions, and keeping row-level detail while adding dataset-wide context.
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.