Treehouse | Community | Grouping, Joining and Cleaning Up

You found it first ⚡ 50% off any plan for 6 months, exclusive to new subscribers for a limited time only.

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

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

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

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Dave Morse
8,863 Points
BUG in question 1 of 3 (not 2 of 3) of this challenge. The question doesn't specify what table to operate on.

Posted June 27, 2015 2:08pm by Dave Morse

Dave Morse
8,863 Points
0 Answers
MUZ140264 Tsitsi Mupamombe
4,195 Points
TROUBLE ON CHALLENGE 3

Posted June 25, 2015 12:31pm by MUZ140264 Tsitsi Mupamombe

MUZ140264 Tsitsi Mupamombe
4,195 Points
1 Answer
Julius Dockwarder
15,041 Points
Database Foundations Challenge

Posted June 22, 2015 10:33pm by Julius Dockwarder

Julius Dockwarder
15,041 Points
4 Answers
Jacob Hafner
9,864 Points
JOINS are killing me

Posted June 21, 2015 3:55pm by Jacob Hafner

Jacob Hafner
9,864 Points
2 Answers
MUZ140610 Tinashe Marunda
7,028 Points
Select the "first_name" followed by the username in parentheses and alias it as "display_name". For example "Andrew (cha

Posted June 18, 2015 2:38am by MUZ140610 Tinashe Marunda

MUZ140610 Tinashe Marunda
7,028 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
Stefan Hoffmann
24,811 Points
It asks me to group reviews by movie_id and get the average score per movie.

Posted June 13, 2015 8:16am by Stefan Hoffmann

Stefan Hoffmann
24,811 Points
2 Answers
Samuel Sanders
6,992 Points
Why are these not working for Challenge #2

Posted June 4, 2015 8:08pm by Samuel Sanders

Samuel Sanders
6,992 Points
1 Answer
Juliette Tworsey
Front End Web Development Techdegree Graduate 32,625 Points
Select the first letter of the "first_name", add a period after it, followed by a space and add the "last_name".

Posted May 29, 2015 7:18pm by Juliette Tworsey

Juliette Tworsey
Front End Web Development Techdegree Graduate 32,625 Points
0 Answers
dotz
6,733 Points
numeric and aggregate functions challenge 3

Posted May 28, 2015 9:00pm by dotz

dotz
6,733 Points
1 Answer
Juliette Tworsey
Front End Web Development Techdegree Graduate 32,625 Points
Like before, group reviews by "movie_id", get the average "score" as "average" and only include averages under 2.

Posted May 28, 2015 8:35pm by Juliette Tworsey

Juliette Tworsey
Front End Web Development Techdegree Graduate 32,625 Points
2 Answers
Arjun Temurnikar
9,695 Points
I can't figure this out!

Posted May 28, 2015 11:50am by Arjun Temurnikar

Arjun Temurnikar
9,695 Points
2 Answers
Jami Schwarzwalder
17,961 Points
There is something wrong with your query. Challenge Task 3 of 3

Posted May 26, 2015 2:25am by Jami Schwarzwalder

Jami Schwarzwalder
17,961 Points
2 Answers
PLUS

Anuj Nagpal
Courses Plus Student 3,748 Points
Getting wrong answer

Posted May 23, 2015 1:26pm by Anuj Nagpal

Anuj Nagpal
Courses Plus Student 3,748 Points
1 Answer
Becca Ades
4,205 Points
Don't understand why my code isn't working: SELECT CONCAT(first_name," ",(username)) AS display_name FROM users;

Posted May 22, 2015 10:27pm by Becca Ades

Becca Ades
4,205 Points
1 Answer
Mark Prather
16,454 Points
What's the name of the table? It never mentions which table name it wants.

Posted May 22, 2015 7:01pm by Mark Prather

Mark Prather
16,454 Points
1 Answer
Becca Ades
4,205 Points
Outer Join not working! I put the following to run my query and I'm confused as to why it's not working.

Posted May 22, 2015 6:54pm by Becca Ades

Becca Ades
4,205 Points
3 Answers
Becca Ades
4,205 Points
I'm not sure why this isn't working! I'm getting a message that there is an error with my query.

Posted May 22, 2015 5:39pm by Becca Ades

Becca Ades
4,205 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
PLUS

Saira Bottemuller
Courses Plus Student 1,749 Points
SQL Challenge: Grouping, Joining, & Cleaning Up

Posted May 20, 2015 9:41pm by Saira Bottemuller

Saira Bottemuller
Courses Plus Student 1,749 Points
2 Answers
Pedro nieto Sanchez
28,169 Points
Help with this query please.

Posted May 18, 2015 10:40pm by Pedro nieto Sanchez

Pedro nieto Sanchez
28,169 Points
0 Answers
Pedro nieto Sanchez
28,169 Points
Could anyone help me with this Mysql query? I am using the Concat function.

Posted May 17, 2015 5:40pm by Pedro nieto Sanchez

Pedro nieto Sanchez
28,169 Points
0 Answers
Andrew VanVoorhis
7,760 Points
String Functions Challenge Task 2

Posted May 17, 2015 6:57am by Andrew VanVoorhis

Andrew VanVoorhis
7,760 Points
1 Answer
Daniele Vicinanzo
21,277 Points
Challenge Task 1 of 3 In the "users" table, lowercase the "email" column and alias it as "lower_email".

Posted May 16, 2015 12:30pm by Daniele Vicinanzo

Daniele Vicinanzo
21,277 Points
2 Answers
Pedro nieto Sanchez
28,169 Points
What am I doing wrong in this Concat query? Thanks

Posted May 15, 2015 7:08pm by Pedro nieto Sanchez

Pedro nieto Sanchez
28,169 Points
0 Answers
Binu Alexander
4,081 Points
what am i missing here ?

Posted May 13, 2015 4:39am by Binu Alexander

Binu Alexander
4,081 Points
3 Answers
Matthew Fenton
6,331 Points
objective 2 of 3 in database foundations.

Posted May 5, 2015 11:17pm by Matthew Fenton

Matthew Fenton
6,331 Points
2 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
Joseph Damiani
1,066 Points
Numeric and Aggregate Functions in Database Foundations.

Posted April 3, 2015 8:28pm by Joseph Damiani

Joseph Damiani
1,066 Points
2 Answers

Prev Page 2 of 4 Next

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