Treehouse | Community | Grouping, Joining and Cleaning Up

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

MUZ1407800 Doubt Milazi
11,813 Points
help me guys

Posted September 30, 2015 1:42pm by MUZ1407800 Doubt Milazi

MUZ1407800 Doubt Milazi
11,813 Points
1 Answer
Tomas Svojanovsky
26,680 Points
imported sql into XAMPP and did query -> found rows, but here get error message about OUTER JOIN

Posted September 16, 2015 5:36am by Tomas Svojanovsky

Tomas Svojanovsky
26,680 Points
1 Answer
Lucas Hoelscher
3,647 Points
Don't understand the syntax for these quesitons

Posted September 8, 2015 7:51pm by Lucas Hoelscher

Lucas Hoelscher
3,647 Points
1 Answer
Daniel Schwemmlein
4,960 Points
grouping joining and cleaning up challenge 3rd task

Posted August 30, 2015 5:45pm by Daniel Schwemmlein

Daniel Schwemmlein
4,960 Points
1 Answer
gretacipriano
1,341 Points
Problem with the 3rd challenge.

Posted August 22, 2015 2:24pm by gretacipriano

gretacipriano
1,341 Points
1 Answer
MUZ141094 Smart Mashegede
3,335 Points
"Group all reviews by "movie_id" and get the average "score" and alias it as "average"

Posted July 29, 2015 12:42pm by MUZ141094 Smart Mashegede

MUZ141094 Smart Mashegede
3,335 Points
3 Answers
Darren Joy
19,573 Points
DB Foundations Grouping Joining and Cleaning Up Challenge

Posted July 14, 2015 4:49pm by Darren Joy

Darren Joy
19,573 Points
2 Answers
efi domb
9,569 Points
Grouping, Joining and Cleaning Up

Posted July 13, 2015 3:42pm by efi domb

efi domb
9,569 Points
1 Answer
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
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
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
Juliette Tworsey
Front End Web Development Techdegree Graduate 32,628 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,628 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
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
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
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

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