Last answered:

16 Apr 2020

Posted on:

12 Apr 2020

0

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)
Instructor
Posted on:

16 Apr 2020

0

Hi Sai!
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.
Best,
Martin

Submit an answer