SQL -vs- PYTHON
So, SQL IS NOT LIKE PYTHON
READING THE CODE ONE BY ONE (ROW BY ROW) ---> Python
CUZ WE USED
ORDER BY BEFORE ADDING THE VALUES IN THE
Thanks for reaching out.
Yes, there is a difference between both languages.
The actual execution of MySQL statements is a bit tricky. However, the standard does specify the order of interpretation of elements in the query. The order is the following:
GROUP BY clause
ORDER BY clause
This is important for understanding how queries are parsed. You cannot use a column alias defined in a SELECT in the WHERE clause, for instance, because the WHERE is parsed before the SELECT. On the other hand, such an alias can be in the ORDER BY clause.
Hope this helps.