As per the lecture when we use Group By on certain column it displays in ascending order and avoiding duplicates but is this applicable to all MySql workbench versions as I’m unable to achieve the same output while using Version 8.0
Also COUNT() aggregate function is not being displayed in blue color it is in blackish/grey is this also due to version change?
Thanks for reaching out.
Regarding the use of GROUP BY particularly in newer versions of MySQL, please refer to the following lecture from the course: https://365datascience.teachable.com/admin/courses/360102/curriculum/lectures/11680913
Regarding the color in which the COUNT() function is displayed – this just depends on the version you are using. If you write a query correctly, it’ll still run.
Hope this helps but please get back to us should you need further assistance. Thank you.