Treehouse | Community | Counting Groups

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

Join our Live Career-Building Workshop: Launch Your Tech-Adjacent Career! ⭐ Register here!

🌟 Dreaming of a bright future? 🎓 Ask about the Treehouse Scholarship program! 🚀

Curious which AI tools Treehouse developers love? ⚙️ Check them out!

🫡 Treehouse for Military offers discounts to Veterans, service members and their families!

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

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
Leslie Perez
993 Points
Don't understand why I get an error

Posted December 30, 2018 1:46am by Leslie Perez

Leslie Perez
993 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
David Corrales
4,698 Points
Need a little help! What am I missing here?

Posted December 16, 2018 10:46pm by David Corrales

David Corrales
4,698 Points
2 Answers
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
Shain Jones
1,315 Points
COUNT() HELP

Posted October 24, 2018 6:34pm by Shain Jones

Shain Jones
1,315 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
Rhea Khanna
2,838 Points
Count function

Posted October 19, 2018 1:11pm by Rhea Khanna

Rhea Khanna
2,838 Points
1 Answer
tonderayi masiyandima
5,673 Points
Challenge Task 1 of 1 We're in a movie database.

Posted September 29, 2018 1:21pm by tonderayi masiyandima

tonderayi masiyandima
5,673 Points
2 Answers
Damian Toczek
4,471 Points
How should i count it then?

Posted September 29, 2018 12:38am by Damian Toczek

Damian Toczek
4,471 Points
1 Answer
Sonia Cabon
1,173 Points
bummer: you're missing the where cause

Posted September 24, 2018 9:47am by Sonia Cabon

Sonia Cabon
1,173 Points
3 Answers
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
PLUS

Takyi Akwah
Courses Plus Student 1,049 Points
AVG Help

Posted August 30, 2018 8:08pm by Takyi Akwah

Takyi Akwah
Courses Plus Student 1,049 Points
1 Answer
Gurdeep singh
1,522 Points
SELECT COUNT(*) AS "jk_book_count" FROM books WHERE author = "J.K.Rowling" ; I don't know what wrong with this script

Posted August 24, 2018 10:51pm by Gurdeep singh

Gurdeep singh
1,522 Points
1 Answer
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
Amy Hsieh
6,023 Points
To generate a count of certain column. I can't see what's wrong with my SQL code

Posted August 14, 2018 11:30am by Amy Hsieh

Amy Hsieh
6,023 Points
1 Answer
Robbie Thomas
31,093 Points
SQL Min & Max

Posted August 6, 2018 3:47pm by Robbie Thomas

Robbie Thomas
31,093 Points
2 Answers
PLUS

Richard gt
Courses Plus Student 749 Points
Summing Values

Posted August 1, 2018 5:34pm by Richard gt

Richard gt
Courses Plus Student 749 Points
1 Answer
Naoya Yuda
6,185 Points
Count Function

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

Naoya Yuda
6,185 Points
2 Answers
Jonathan Hartmayer
5,626 Points
Average cost of order

Posted July 20, 2018 7:21am by Jonathan Hartmayer

Jonathan Hartmayer
5,626 Points
1 Answer
PLUS

Amari Hanes
Courses Plus Student 2,025 Points
select movie_id, sum(reviews) as starman_total_ratings from reviews where movie_id = 6;

Posted July 18, 2018 1:10pm by Amari Hanes

Amari Hanes
Courses Plus Student 2,025 Points
1 Answer
Felix Bynum
1,129 Points
I think my issue is more about showing the difference in exchange rate rather than the set up of the query.

Posted July 5, 2018 10:23pm by Felix Bynum

Felix Bynum
1,129 Points
1 Answer
Christopher Parke
21,978 Points
Movie Ratings Question Confusing

Posted June 21, 2018 4:15pm by Christopher Parke

Christopher Parke
21,978 Points
2 Answers
Deborah Watson
2,614 Points
Count function

Posted June 18, 2018 9:14pm by Deborah Watson

Deborah Watson
2,614 Points
1 Answer
barak ben ishay
1,951 Points
COUNTING RESULATS

Posted June 15, 2018 11:04am by barak ben ishay

barak ben ishay
1,951 Points
4 Answers
PLUS

Joe Marcallini
Courses Plus Student 13,986 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 13,986 Points
2 Answers
Robert Keene
5,332 Points
Exchange rate incorrect calculation

Posted June 1, 2018 2:53pm by Robert Keene

Robert Keene
5,332 Points
1 Answer
Robert Keene
5,332 Points
movie database

Posted May 30, 2018 3:12pm by Robert Keene

Robert Keene
5,332 Points
1 Answer
doesitmatter
12,885 Points
SELECT COUNT(platform) FROM games

Posted May 28, 2018 9:07am by doesitmatter

doesitmatter
12,885 Points
1 Answer

Prev Page 3 of 4 Next

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