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

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

John Magee
Courses Plus Student 9,058 Points
Improper MySQL Syntax used in this Video - String Functions - Database

Posted March 12, 2015 10:28pm by John Magee

John Magee
Courses Plus Student 9,058 Points
0 Answers
Viktoria S
6,773 Points
How does sql know what is username? did we specified it earlier what is username consist of?

Posted March 7, 2015 4:46pm by Viktoria S

Viktoria S
6,773 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
Sarah A. Morrigan
14,329 Points
Something amiss on reviews table?

Posted February 11, 2015 2:46am by Sarah A. Morrigan

Sarah A. Morrigan
14,329 Points
0 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
Sebastian Velandia
24,676 Points
How to select star (*) but add a string function to one of the columns?

Posted November 25, 2014 5:16pm by Sebastian Velandia

Sebastian Velandia
24,676 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
David Lopez
3,211 Points
in the numeric and aggregate functions video of the db foundations series in development tools a new db is introduced

Posted November 8, 2014 3:56am by David Lopez

David Lopez
3,211 Points
0 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
Bradley Johnson
11,539 Points
SQL script stalls out when run in Workbench. Wat do?

Posted August 15, 2014 12:32am by Bradley Johnson

Bradley Johnson
11,539 Points
2 Answers
PLUS

Joe Hilton
Courses Plus Student 4,893 Points
Slightly confused with the SUBSTRING clause in my MySQL command.

Posted July 31, 2014 5:39pm by Joe Hilton

Joe Hilton
Courses Plus Student 4,893 Points
2 Answers
PLUS

Joe Hilton
Courses Plus Student 4,893 Points
Can anyone point me in the right direction as to what's wrong with my MySQL code please

Posted July 31, 2014 4:32pm by Joe Hilton

Joe Hilton
Courses Plus Student 4,893 Points
4 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
ROBERT ROBINSON
7,723 Points
Im having an issue with importing the db. When I do the import in MySQL, it says the file is blank. Thoughts. Stage 7

Posted July 27, 2014 5:36pm by ROBERT ROBINSON

ROBERT ROBINSON
7,723 Points
3 Answers
Bruno Calheira
12,625 Points
When should I use HAVING in SQL Statements?

Posted July 2, 2014 8:06pm by Bruno Calheira

Bruno Calheira
12,625 Points
2 Answers
Marc Bienaimé
1,116 Points
Password for localhost

Posted June 10, 2014 1:17am by Marc Bienaimé

Marc Bienaimé
1,116 Points
2 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
. Ali
9,799 Points
Just a heads up

Posted March 15, 2014 7:57am by . Ali

. Ali
9,799 Points
1 Answer
Coders Unlimited
10,112 Points
Select the first letter of the "first_name", add a period after it, followed by a space and add the "last_name". Also, convert "last_name" to upper case. Call it "name". Example: "A. CHALKLEY".

Posted February 27, 2014 6:42am by Coders Unlimited

Coders Unlimited
10,112 Points
3 Answers
Coders Unlimited
10,112 Points
String Function

Posted February 27, 2014 6:37am by Coders Unlimited

Coders Unlimited
10,112 Points
2 Answers
Gareth Redfern
36,217 Points
PHP / Database Help On Task 3

Posted February 17, 2014 1:46pm by Gareth Redfern

Gareth Redfern
36,217 Points
3 Answers

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.