5.9

Given a relation nyse(year,month,day,shares_traded,dollar_volume) with trading data from the New York Stock Exchange, list each trading day in order of number of shares traded, and show each day’s rank.

---

SELECT year,month,day,shares_traded,
    RANK() OVER (ORDER BY (shares_traded) DESC) AS mostshares
FROM nyse