How do we request the results of our query be presented in descending order:
select category, price, avg(downloads)
from fake_apps
group by 1, 2;
Result:
category | price | avg(downloads) |
---|---|---|
Books | 0.0 | 11926.5 |
Books | 0.99 | 27709.5 |
Books | 1.99 | 21770.3333333333 |
Books | 2.99 | 16281.0 |