Treehouse | Community | Counting Groups

Notice: Workspaces are undergoing maintenance and are temporarily unavailable.

🚀 In our NEW AI Bootcamp you'll build a working app in 28 days, no experience required. Free to all subscription levels.

✨ Earn college credits in Cybersecurity, JS, HTML, CSS and Python

Join the Treehouse affiliate program and earn 25% recurring commission! 🤑

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Cristian Luca
4,102 Points
What's wrong with my code? Thanks a lot!

Posted October 17, 2022 6:34pm by Cristian Luca

Cristian Luca
4,102 Points
3 Answers
Jason Kirkpatrick
2,117 Points
Can't seem to get this, though I think I'm counting the numbers of books in each genre instead of each genre. How?

Posted February 18, 2022 6:04pm by Jason Kirkpatrick

Jason Kirkpatrick
2,117 Points
1 Answer
xczurymqdj
2,289 Points
In need of some help again, My code is not working right. please help me.

Posted November 16, 2021 8:21pm by xczurymqdj

xczurymqdj
2,289 Points
6 Answers
Jenn Giulietti
4,888 Points
GROUP OF ROWS SQL

Posted November 1, 2020 8:18pm by Jenn Giulietti

Jenn Giulietti
4,888 Points
1 Answer
John Richter
2,351 Points
My returned COUNT(genre) is incorrect, and i can not figure out why. Please let me know what i'm doing wrong.

Posted October 12, 2020 4:34pm by John Richter

John Richter
2,351 Points
1 Answer
theteamtreehouse
3,472 Points
Why wouldn't this also work?

Posted August 20, 2020 10:55pm by theteamtreehouse

theteamtreehouse
3,472 Points
1 Answer
Derek Morse
1,776 Points
stuck

Posted May 27, 2020 3:04pm by Derek Morse

Derek Morse
1,776 Points
1 Answer
Derek Morse
1,776 Points
NOT understanding

Posted May 26, 2020 6:39pm by Derek Morse

Derek Morse
1,776 Points
2 Answers
Derek Morse
1,776 Points
STUCK AGAIN

Posted May 26, 2020 2:25pm by Derek Morse

Derek Morse
1,776 Points
1 Answer
Derek Morse
1,776 Points
Data line does not match, what distinct am i missing?

Posted May 18, 2020 3:45pm by Derek Morse

Derek Morse
1,776 Points
2 Answers
rajpal Saini
2,331 Points
cant find the solution for challenge task 2 of 2

Posted April 28, 2020 11:59am by rajpal Saini

rajpal Saini
2,331 Points
1 Answer
lucas morrow
2,243 Points
query didn't match

Posted April 21, 2020 2:58am by lucas morrow

lucas morrow
2,243 Points
1 Answer
Kawaljeet Singh
3,820 Points
GROUP BY

Posted April 17, 2020 9:29am by Kawaljeet Singh

Kawaljeet Singh
3,820 Points
1 Answer
Caleb Newell
12,562 Points
Write a query to count all the unique genres in the books table. Alias it as total_genres.

Posted April 9, 2020 1:26pm by Caleb Newell

Caleb Newell
12,562 Points
1 Answer
Tafari Carnegie
2,679 Points
select genre,count(distinct genre) as total_genres from books group by genre

Posted March 25, 2020 10:15pm by Tafari Carnegie

Tafari Carnegie
2,679 Points
1 Answer
Riley Egan
2,452 Points
I'm at a loss as far as what to do. I've re-watched the video several times and cannot get past this point.

Posted November 20, 2019 7:47pm by Riley Egan

Riley Egan
2,452 Points
2 Answers
newtocoding
4,940 Points
How to answer this challenge?

Posted September 25, 2019 12:17pm by newtocoding

newtocoding
4,940 Points
2 Answers
Zach Johnston
2,500 Points
I'm not sure how this isn't pulling the correct count. SELECT COUNT(genre) AS genre_count FROM books GROUP BY genre

Posted September 16, 2019 10:43pm by Zach Johnston

Zach Johnston
2,500 Points
1 Answer
Richard Külling
9,465 Points
I don't see what's wrong with my query, it seems that it returns what is asked for, doesn't it?

Posted January 19, 2019 6:35pm by Richard Külling

Richard Külling
9,465 Points
1 Answer
Thomas Dam
5,237 Points
Having trouble with Task 2 of Challenge

Posted January 9, 2019 2:31pm by Thomas Dam

Thomas Dam
5,237 Points
1 Answer
Tetiana lukerievas
5,641 Points
Is the test outcome correct?

Posted December 21, 2018 8:52pm by Tetiana lukerievas

Tetiana lukerievas
5,641 Points
1 Answer
Jose Lopez
2,278 Points
I'm trying to count unique genres in books and I can't figure it out.

Posted November 2, 2018 3:20pm by Jose Lopez

Jose Lopez
2,278 Points
1 Answer
MIkhail Vinogradov
2,669 Points
what am i doing wrong here please?

Posted October 24, 2018 5:51pm by MIkhail Vinogradov

MIkhail Vinogradov
2,669 Points
1 Answer
Kevin May
1,435 Points
When asked "Write a query to count all the unique genres in the books table. Alias it as total_genres." get wrong count?

Posted September 19, 2018 2:04pm by Kevin May

Kevin May
1,435 Points
2 Answers
Kevin Matter
2,507 Points
Question Bug

Posted September 16, 2018 3:26pm by Kevin Matter

Kevin Matter
2,507 Points
2 Answers
kelvinvockins
6,906 Points
Reporting with sql, 2nd code challenge COUNT BY GROUP incorrect code

Posted August 16, 2018 6:48pm by kelvinvockins

kelvinvockins
6,906 Points
2 Answers
Naoya Yuda
6,185 Points
Count Function

Posted July 31, 2018 7:36am by Naoya Yuda

Naoya Yuda
6,185 Points
2 Answers
PLUS

Joe Marcallini
Courses Plus Student 14,835 Points
SELECT genre, COUNT(genre) AS genre_count FROM books GROUP BY genre; Can you please tell me what is wrong with this

Posted June 11, 2018 8:29pm by Joe Marcallini

Joe Marcallini
Courses Plus Student 14,835 Points
2 Answers
Gleb Sklyr
17,492 Points
Why is the a NULL genre value complicating this challenge and howto solve it elegantly?

Posted January 31, 2017 12:30am by Gleb Sklyr

Gleb Sklyr
17,492 Points
1 Answer

Posting to the forum is only allowed for members with active accounts.
Please sign in or sign up to post.