Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll

- 2x 2x
- 1.75x 1.75x
- 1.5x 1.5x
- 1.25x 1.25x
- 1.1x 1.1x
- 1x 1x
- 0.75x 0.75x
- 0.5x 0.5x
It’s often handy to group rows together to count them. For example you could answer the question "How many books are in each genre?"
To count aggregated rows with common values use the GROUP BY
keywords:
SELECT COUNT(<column>) FROM <table> GROUP BY <column with common value>;
Cheat Sheets
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up-
XXX xxx
Full Stack JavaScript Techdegree Student 1,449 Points1 Answer
-
Kristian Woods
23,414 Points4 Answers
View all discussions for this video
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
You need to sign up for Treehouse in order to download course files.
Sign upYou need to sign up for Treehouse in order to set up Workspace
Sign up