Top Revenue Days with Ties

easy
Unit 7 · Window Functions II0/3 to milestone

Return the dates in the top 3 revenue ranks (using DENSE_RANK, so tied days share a rank and more than three days may appear), with order_date, revenue and day_rank. Sort by day_rank, then order_date.

Schema

customers(id, name, country, signup_date)
orders(id, customer_id, order_date, total)
#window-functions#ranking1 visible + 1 hidden tests
query.sql · SQLite
Loading editor…
Run your code to see results. ⌘↵ to run · ⌘⇧↵ to submit
Top Revenue Days with Ties · TechGradify