Introduction
Quick Refresher
PARTITION BY ORDER BY with Ranking
10. Practice Time!
PARTITION BY ORDER BY with Window Frames
Using PARTITION BY ORDER BY with Analytical Functions
Summary and Review

Instruction

Very well done! Let's do a few more exercises.

Exercise

Let's analyze sales data between August 1 and August 3, 2016. For each row, show the StoreId, Day, Transactions and the ranking of the store (based on the daily number of transactions). The store with the greatest number of transactions should get Rank = 1. Use individual row ranks even when two rows share the same value.

Stuck? Here's a hint!

Use ROW_NUMBER() instead of RANK().