Sql-missing important stuff

the course miss important stuff- like

  1. about count function- with group by , its not important on which column you do it, and in the course they wrote- 'we use * because we want to count all the result, instead explain how it work
    2, the order sql actually work( like where happening befor ect…) and why we write in this order