The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

Group by and count function

Group by and count function

0
Votes
1
Answer

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 Answer

365 Team
0
Votes

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://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.
Best,
Martin

×
LAST CHANCE
Ready to Learn Data Science?
50% OFF