When writing a query, how do you know the order of it?
Ex: If you need to write a query on the number of applications at each price that have been downloaded over 20,000 times, the exercise showed the query as Select price, count (*) from fake_apps where downloads > 20,000;
Why would the word price come before count in the query?
But in another example where the query had to be written on naming the most downloaded applications in each category, the query was Select name, category, MAX (downloads) from fake_apps, group by category;
Why would the word name come before category in this case?