Treehouse | Community | 8th Grade Teachers

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

New No-Code Track! 🚀start learning today!

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

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

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

PLUS

abdel ahbe
Python Development Techdegree Student 2,125 Points
I believe the solution provided in the video is not correct!

Posted January 7, 2025 9:08am by abdel ahbe

abdel ahbe
Python Development Techdegree Student 2,125 Points
1 Answer
Alex Hort-Francis
12,924 Points
My solution

Posted October 15, 2023 4:40pm by Alex Hort-Francis

Alex Hort-Francis
12,924 Points
0 Answers
Alex Hort-Francis
12,924 Points
On the `DISTINCT` keyword per column in the instructor's example query

Posted October 15, 2023 3:42pm by Alex Hort-Francis

Alex Hort-Francis
12,924 Points
1 Answer
Uhunoma Osula
6,414 Points
THIS WORKED TOO

Posted July 17, 2023 11:37am by Uhunoma Osula

Uhunoma Osula
6,414 Points
1 Answer
Geovani Mejia
Front End Web Development Techdegree Student 7,940 Points
Question on the GROUP BY keyword

Posted October 12, 2022 7:25pm by Geovani Mejia

Geovani Mejia
Front End Web Development Techdegree Student 7,940 Points
1 Answer
Fahad Ahsan
2,595 Points
SELECT JOBS.ROLE, COUNT(1) FROM EMPLOYEES JOIN JOBS ON EMPLOYEES.JOB_ID = JOBS.ID ;

Posted September 8, 2021 12:18pm by Fahad Ahsan

Fahad Ahsan
2,595 Points
1 Answer
J de la Torre
2,858 Points
Difference in speed/efficiency between CTEs, INTERSECT, WHERE clause solutions?

Posted August 4, 2021 7:04pm by J de la Torre

J de la Torre
2,858 Points
1 Answer
Kathleen Pitches
2,967 Points
What does .* mean in SQL?

Posted June 9, 2021 4:50pm by Kathleen Pitches

Kathleen Pitches
2,967 Points
1 Answer
Cody Stephenson
8,361 Points
My overly explicit solution starting from a different table.

Posted May 24, 2021 7:25pm by Cody Stephenson

Cody Stephenson
8,361 Points
0 Answers
PLUS

Rushabha Jain
Front End Web Development Techdegree Student 9,859 Points
cte vs join performance

Posted April 18, 2021 7:01am by Rushabha Jain

Rushabha Jain
Front End Web Development Techdegree Student 9,859 Points
1 Answer
jun cheng wong
17,021 Points
NO SUCH COLUMN: A.STUDENT_ID WHEN I RUN THIS CODE

Posted March 4, 2021 2:40am by jun cheng wong

jun cheng wong
17,021 Points
2 Answers
PLUS

Jordan young
Courses Plus Student 5,277 Points
Circular logic of all of these tables "Predicting the Future".

Posted September 25, 2020 3:30am by Jordan young

Jordan young
Courses Plus Student 5,277 Points
1 Answer
PLUS

Jordan young
Courses Plus Student 5,277 Points
Hi. I did a totally different query, but generated the same result. Is there a preference for either method?

Posted September 24, 2020 3:02pm by Jordan young

Jordan young
Courses Plus Student 5,277 Points
1 Answer
Jorgen Rasmussen
3,367 Points
Continuing my SQL learning

Posted September 16, 2020 5:20pm by Jorgen Rasmussen

Jorgen Rasmussen
3,367 Points
2 Answers
spencer tintorri
6,184 Points
CTE reference question

Posted August 25, 2020 1:56pm by spencer tintorri

spencer tintorri
6,184 Points
1 Answer
Michael Hill
3,960 Points
My Solution to this Challenge

Posted May 17, 2020 5:13pm by Michael Hill

Michael Hill
3,960 Points
1 Answer
mihneaburtescu
348 Points
Please can you help me with the answer to understand how it works?

Posted March 24, 2020 6:13pm by mihneaburtescu

mihneaburtescu
348 Points
1 Answer
Claire Brehm
9,098 Points
SQL reporting by example quiz, complete code question

Posted February 28, 2020 6:34pm by Claire Brehm

Claire Brehm
9,098 Points
1 Answer
Frances Angulo
5,311 Points
My solution returned more results

Posted January 25, 2020 4:02pm by Frances Angulo

Frances Angulo
5,311 Points
3 Answers
Ronald Greer
Front End Web Development Techdegree Graduate 56,430 Points
I thought that the answer to the first fill in the blank was "* FROM". what am i doing wrong?

Posted December 29, 2019 4:00pm by Ronald Greer

Ronald Greer
Front End Web Development Techdegree Graduate 56,430 Points
1 Answer
Austin Cumberlander
13,997 Points
student

Posted November 16, 2019 6:41pm by Austin Cumberlander

Austin Cumberlander
13,997 Points
1 Answer
Steve Rogers
3,285 Points
Left Outer Join question

Posted November 12, 2019 3:18pm by Steve Rogers

Steve Rogers
3,285 Points
1 Answer
Steve Rogers
3,285 Points
trouble

Posted October 29, 2019 10:29pm by Steve Rogers

Steve Rogers
3,285 Points
1 Answer
Steve Rogers
3,285 Points
Counting issue?

Posted October 21, 2019 2:24pm by Steve Rogers

Steve Rogers
3,285 Points
1 Answer
Steve Rogers
3,285 Points
The quiz asked me to return a list of employees ordered by salary starting with the highest. I got it wrong?

Posted October 16, 2019 8:00pm by Steve Rogers

Steve Rogers
3,285 Points
2 Answers
Shreemangal Sethi
Full Stack JavaScript Techdegree Student 15,552 Points
I am not able to understand how to link the table? Can someone explain me please.

Posted October 8, 2019 3:19am by Shreemangal Sethi

Shreemangal Sethi
Full Stack JavaScript Techdegree Student 15,552 Points
1 Answer
Tommy Gebru
30,164 Points
Solution: Finding the Troublemaker

Posted August 31, 2019 8:58pm by Tommy Gebru

Tommy Gebru
30,164 Points
1 Answer
Tommy Gebru
30,164 Points
Solution: JANIS Schedule

Posted August 31, 2019 4:52pm by Tommy Gebru

Tommy Gebru
30,164 Points
1 Answer
Paul Brubaker
14,290 Points
Forgot about HAVING keyword and came up with this monstrosity.

Posted August 26, 2019 3:37am by Paul Brubaker

Paul Brubaker
14,290 Points
3 Answers
Ikechukwu Arum
5,337 Points
ERROR: NO SUCH COLUMN

Posted April 9, 2019 6:41pm by Ikechukwu Arum

Ikechukwu Arum
5,337 Points
3 Answers

Prev Page 1 of 4 Next

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