Treehouse | Community

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

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,272 Points
My overly explicit solution starting from a different table.

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

Cody Stephenson
8,272 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,251 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,251 Points
1 Answer
PLUS

Jordan young
Courses Plus Student 5,251 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,251 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,280 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,280 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,250 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,250 Points
1 Answer
Tommy Gebru
30,150 Points
Solution: Finding the Troublemaker

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

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

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

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

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

Paul Brubaker
14,263 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
PLUS

kevin hudson
Courses Plus Student 11,577 Points
No Help needed but want to share Code with mistakes

Posted April 9, 2019 3:58pm by kevin hudson

kevin hudson
Courses Plus Student 11,577 Points
0 Answers
PLUS

kevin hudson
Courses Plus Student 11,577 Points
Is it a bad approach to use subqueries over CTE and JOINING?

Posted April 8, 2019 6:20pm by kevin hudson

kevin hudson
Courses Plus Student 11,577 Points
2 Answers
PLUS

kevin hudson
Courses Plus Student 11,577 Points
What is penultimate?

Posted April 8, 2019 3:51pm by kevin hudson

kevin hudson
Courses Plus Student 11,577 Points
1 Answer
PLUS

kevin hudson
Courses Plus Student 11,577 Points
The first challenge should include GROUP BY

Posted April 8, 2019 2:51pm by kevin hudson

kevin hudson
Courses Plus Student 11,577 Points
5 Answers
Gia Hoang Nguyen
4,137 Points
How to find the discrepancy between the current grade 7 students and the future grade 6 students who move to grade 7?

Posted March 27, 2019 3:28am by Gia Hoang Nguyen

Gia Hoang Nguyen
4,137 Points
1 Answer

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.