Group by and count function
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?
1 answers ( 0 marked as helpful)
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://learn.365datascience.com/courses/sql/group-by 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.