I thought it would be easiest to enter the rounding and avg valuation first (especially since I’m having trouble with rounding and average code formatting), so I entered
select round(avg(valuation),2), category from startups group by 3 order by 2 desc;
No result when I enter the above, but when I run the below, I get my answer. My question is why must it be in the below order for the function to run?
select category, round(avg(valuation),2) from startups group by 1 order by 2 desc;