Treehouse | Community | Grouping, Joining and Cleaning Up

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

🌟 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

Daniel Sokol
14,888 Points
Not quite getting "Group By".........

Posted September 10, 2016 2:42pm by Daniel Sokol

Daniel Sokol
14,888 Points
2 Answers
James Miller
7,661 Points
New Version of MYSQL prevents me from following video.

Posted September 8, 2016 8:36am by James Miller

James Miller
7,661 Points
0 Answers
Manav Misra
11,778 Points
Why does average rating of Alien show differently on later queries?

Posted August 4, 2016 1:10am by Manav Misra

Manav Misra
11,778 Points
1 Answer
Javid Abbasov
9,243 Points
Please, HEEELP!!!!

Posted April 3, 2016 6:43pm by Javid Abbasov

Javid Abbasov
9,243 Points
3 Answers
Telmo Teixeira
16,378 Points
Error Code: 1055 "...sql_mode=only_full_group_by"

Posted March 2, 2016 11:57am by Telmo Teixeira

Telmo Teixeira
16,378 Points
4 Answers
Sean Flanagan
33,235 Points
Teacher's Notes

Posted January 12, 2016 11:23pm by Sean Flanagan

Sean Flanagan
33,235 Points
1 Answer
Sean Flanagan
33,235 Points
IFNULL

Posted January 12, 2016 2:55pm by Sean Flanagan

Sean Flanagan
33,235 Points
2 Answers
Elena Paraschiv
9,938 Points
LEFT OUTERJOIN AND LEFT JOIN

Posted November 15, 2015 11:38pm by Elena Paraschiv

Elena Paraschiv
9,938 Points
1 Answer
michaelmugo
3,971 Points
I don't understand the combination of JOIN and GROUP BY

Posted October 16, 2015 2:23pm by michaelmugo

michaelmugo
3,971 Points
1 Answer
Adam Zuckerberg
22,248 Points
HAVING can use an alias?

Posted August 20, 2015 7:27pm by Adam Zuckerberg

Adam Zuckerberg
22,248 Points
1 Answer
Leigh Maher
21,830 Points
Where does the word 'average' come from?

Posted June 29, 2015 9:26am by Leigh Maher

Leigh Maher
21,830 Points
0 Answers
William J. Terrell
17,403 Points
So, how might I put the final SQL statement into plain English?

Posted June 17, 2015 9:04pm by William J. Terrell

William J. Terrell
17,403 Points
0 Answers
joleneoropilla
17,214 Points
What is the difference in syntax in Task 3 of 3 in the Grouping, Joining and Cleaning Up?

Posted May 21, 2015 6:04pm by joleneoropilla

joleneoropilla
17,214 Points
0 Answers
ahmed saleh
2,754 Points
group by doesn't work

Posted May 5, 2015 3:45am by ahmed saleh

ahmed saleh
2,754 Points
0 Answers
John Martens
8,689 Points
Cant get the last code challenge

Posted April 22, 2015 10:31am by John Martens

John Martens
8,689 Points
2 Answers
Mikael paavola
1,786 Points
HAVING on an ALIAS

Posted April 3, 2015 7:04pm by Mikael paavola

Mikael paavola
1,786 Points
1 Answer
PLUS

Shahriar Ayoubi
Courses Plus Student 9,090 Points
The first challenge question on the Grouping, Joining and Cleaning up

Posted March 5, 2015 9:05am by Shahriar Ayoubi

Shahriar Ayoubi
Courses Plus Student 9,090 Points
2 Answers
Jonathan Weinstein
9,063 Points
Trouble creating OUTER JOIN

Posted February 20, 2015 1:11am by Jonathan Weinstein

Jonathan Weinstein
9,063 Points
2 Answers
PLUS

Robert Ott
Courses Plus Student 4,614 Points
Code Challenge #1 - numeric formatting

Posted February 4, 2015 7:51pm by Robert Ott

Robert Ott
Courses Plus Student 4,614 Points
2 Answers
Roy Huang
4,367 Points
Code Challenge 3

Posted January 26, 2015 5:36am by Roy Huang

Roy Huang
4,367 Points
2 Answers
Phil Ward
4,204 Points
stuck on MYSQL the 3rd task of the challenge prior to this video

Posted January 17, 2015 12:36pm by Phil Ward

Phil Ward
4,204 Points
1 Answer
Jim Withington
12,025 Points
Why are you picking on Starman?

Posted November 21, 2014 8:56pm by Jim Withington

Jim Withington
12,025 Points
3 Answers
Christian Damm
26,486 Points
Who is buggy? Me or Code Chellenge

Posted November 7, 2014 4:49pm by Christian Damm

Christian Damm
26,486 Points
2 Answers
PLUS

Brad Clarke
Courses Plus Student 3,602 Points
I think your second code challenge question is broken, the avg's I see are all below 0.

Posted October 24, 2014 5:37am by Brad Clarke

Brad Clarke
Courses Plus Student 3,602 Points
1 Answer
Alon Sacks
656 Points
The first question is asking me to group all reviews and make an average score under the alias "average". help plz!

Posted October 14, 2014 1:54pm by Alon Sacks

Alon Sacks
656 Points
2 Answers
Tomas Smalakys
5,501 Points
What is wrong with my query ?

Posted August 29, 2014 7:52pm by Tomas Smalakys

Tomas Smalakys
5,501 Points
2 Answers
PLUS

Joe Hilton
Courses Plus Student 4,893 Points
Can anyone point out where I'm going wrong on my MySQL command because I cannot see it anywhere

Posted July 31, 2014 1:59pm by Joe Hilton

Joe Hilton
Courses Plus Student 4,893 Points
6 Answers
Samuel Altarac
4,961 Points
help with grouping in MySQL

Posted June 9, 2014 8:54pm by Samuel Altarac

Samuel Altarac
4,961 Points
4 Answers
Jacinda Zhong
3,695 Points
MySQL join code issues

Posted March 31, 2014 2:08pm by Jacinda Zhong

Jacinda Zhong
3,695 Points
1 Answer
Ian Corritore
4,740 Points
Group, Joining, and Filter in SQL.

Posted March 26, 2014 9:16pm by Ian Corritore

Ian Corritore
4,740 Points
1 Answer

Prev Page 1 of 2 Next

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