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
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

Jordan young
Courses Plus Student 5,276 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,276 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
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
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
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
PLUS

J R
Courses Plus Student 12,168 Points
Why doesn't ' WHERE LAST_NAME <= 'N' ' work?

Posted February 17, 2019 9:36pm by J R

J R
Courses Plus Student 12,168 Points
4 Answers
Mark Chesney
11,746 Points
smelly issue: query came close

Posted January 23, 2019 5:14am by Mark Chesney

Mark Chesney
11,746 Points
2 Answers
Mishu Jahur
5,238 Points
How can "GROUP BY" act on non-column values?

Posted January 10, 2019 2:22am by Mishu Jahur

Mishu Jahur
5,238 Points
1 Answer
Ahmed Mohamed Fouad
11,735 Points
My Code for this lesson using CTE

Posted May 14, 2018 5:12am by Ahmed Mohamed Fouad

Ahmed Mohamed Fouad
11,735 Points
0 Answers
Vanessa Van Gilder
7,034 Points
Here's my version of making the schedule. Feedback appreciated.

Posted April 30, 2018 4:21pm by Vanessa Van Gilder

Vanessa Van Gilder
7,034 Points
6 Answers
Giuseppe Ardito
14,130 Points
Are students using 6 rooms at the same time for 6th grade?

Posted March 1, 2018 8:19am by Giuseppe Ardito

Giuseppe Ardito
14,130 Points
2 Answers
Charlie Harcourt
8,045 Points
Joining teachers name onto student schedule

Posted February 15, 2018 4:15pm by Charlie Harcourt

Charlie Harcourt
8,045 Points
3 Answers
Donnie Driskell
2,243 Points
sql reporting by example: Day 2 Review (stuck)

Posted January 6, 2018 3:46am by Donnie Driskell

Donnie Driskell
2,243 Points
2 Answers
PLUS

sujal Khatiwada
Courses Plus Student 291 Points
SQL Practice Problem

Posted December 15, 2017 5:42am by sujal Khatiwada

sujal Khatiwada
Courses Plus Student 291 Points
1 Answer
olu adesina
23,007 Points
SQL help! i know the answer but i want to understand why

Posted December 12, 2017 10:59pm by olu adesina

olu adesina
23,007 Points
1 Answer
olu adesina
23,007 Points
sql help do i need to use the group by key word

Posted December 12, 2017 8:57pm by olu adesina

olu adesina
23,007 Points
1 Answer
Mathias Schulenburg
2,679 Points
Determining Capacity

Posted November 9, 2017 9:18pm by Mathias Schulenburg

Mathias Schulenburg
2,679 Points
1 Answer
Rashmi Jha
2,842 Points
Fill in the blanks

Posted October 22, 2017 9:10am by Rashmi Jha

Rashmi Jha
2,842 Points
2 Answers
mykolash
12,955 Points
Have an idea how to improve building schedule

Posted October 16, 2017 11:00pm by mykolash

mykolash
12,955 Points
2 Answers
renhe
10,282 Points
Alternative Soln: Generate a list of students with last names from A to M

Posted August 1, 2017 9:20pm by renhe

renhe
10,282 Points
7 Answers
Noah Fields
13,985 Points
Math was Wrong

Posted July 31, 2017 7:16pm by Noah Fields

Noah Fields
13,985 Points
3 Answers
Noah Fields
13,985 Points
My version of the answer with subqueries

Posted July 31, 2017 6:39pm by Noah Fields

Noah Fields
13,985 Points
0 Answers
György Varga
19,198 Points
Chech my solution please!

Posted July 28, 2017 10:52am by György Varga

György Varga
19,198 Points
0 Answers
György Varga
19,198 Points
Here is my solution for the prediction...

Posted July 28, 2017 9:11am by György Varga

György Varga
19,198 Points
1 Answer
Ken Stone
29,702 Points
I see some sixth grade classes with a max capacity of 15.

Posted July 22, 2017 8:28pm by Ken Stone

Ken Stone
29,702 Points
1 Answer
Stamos Bolovinos
4,320 Points
Why joining the students table?

Posted July 21, 2017 6:11pm by Stamos Bolovinos

Stamos Bolovinos
4,320 Points
3 Answers
Stamos Bolovinos
4,320 Points
How to sort on start_time?

Posted July 20, 2017 8:52am by Stamos Bolovinos

Stamos Bolovinos
4,320 Points
2 Answers

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