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 |
@array5804981380, welcome to the forum!
In order to order things in descending order, you would have to use the order by function in SQL. The keyword for descending in DESC and the key word for ascending is ASC.
For example:
from table1
group by column 1
order by column1 DESC;