When I use avg(downloads) instead of max or min, why does the name of the app change? How does the query decide which name to use in the row to describe the average downloads within the category?
The code would be same as above, but instead of max or min, you would type "avg". I am just curious because I am interested in the logic of SQL as someone who is serious about learning more and improving my SQL coding abilities. Max and min are easy to understand, but what logic is used to decide the name for avg?
Thank you in advance for your answer and time.