Treehouse | Community | 7th Grade Science

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

Join our Live Career-Building Workshop: Fast-Track Your Tech Career Without a Degree! ⭐ Register here!

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

Curious which AI tools Treehouse developers love? ⚙️ Check them out!

🫡 Treehouse for Military offers discounts to Veterans, service members and their families!

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

PLUS

kevin hudson
Courses Plus Student 11,987 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,987 Points
2 Answers
PLUS

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

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

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

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

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

kevin hudson
Courses Plus Student 11,987 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
seth aruby
10,111 Points
Making query account for unknown PERIODS count

Posted February 20, 2019 7:25pm by seth aruby

seth aruby
10,111 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
Harris Handoko
3,932 Points
Question on order of joining tables

Posted February 3, 2019 11:34pm by Harris Handoko

Harris Handoko
3,932 Points
2 Answers
Mark Chesney
11,747 Points
smelly issue: query came close

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

Mark Chesney
11,747 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
Urooba Urooba
3,565 Points
database

Posted November 6, 2018 11:08am by Urooba Urooba

Urooba Urooba
3,565 Points
2 Answers
Fairooz Adams
2,704 Points
Quiz Question Issues

Posted October 14, 2018 11:16pm by Fairooz Adams

Fairooz Adams
2,704 Points
3 Answers
Fairooz Adams
2,704 Points
Quiz Question Issues

Posted October 14, 2018 11:14pm by Fairooz Adams

Fairooz Adams
2,704 Points
1 Answer
Teacher Russell
16,873 Points
Finding the ID

Posted October 10, 2018 6:16pm by Teacher Russell

Teacher Russell
16,873 Points
2 Answers
elomaur
5,276 Points
How can I show all periods without using a CTE?

Posted September 21, 2018 3:05am by elomaur

elomaur
5,276 Points
3 Answers
kevin nadjarian
1,498 Points
LIKE "%x"

Posted September 15, 2018 7:18pm by kevin nadjarian

kevin nadjarian
1,498 Points
1 Answer
Brian Ross
11,209 Points
How do I set up a database on my computer?

Posted August 31, 2018 7:30pm by Brian Ross

Brian Ross
11,209 Points
3 Answers
lukej
34,222 Points
The meaning of COUNT(1)?

Posted July 28, 2018 12:17pm by lukej

lukej
34,222 Points
2 Answers
Ronald Greer
Front End Web Development Techdegree Graduate 56,430 Points
Can anybody help me find this answer

Posted July 14, 2018 1:07am by Ronald Greer

Ronald Greer
Front End Web Development Techdegree Graduate 56,430 Points
1 Answer
Deborah Watson
2,614 Points
Write a query to find out which managers have more than 5 people on their team

Posted July 11, 2018 6:00pm by Deborah Watson

Deborah Watson
2,614 Points
2 Answers
amahmartin
3,031 Points
Which managers have greater than 5 employees on team quiz question

Posted July 9, 2018 6:06pm by amahmartin

amahmartin
3,031 Points
2 Answers
James Ramsey
15,948 Points
SHIFT + ENTER

Posted May 24, 2018 2:09pm by James Ramsey

James Ramsey
15,948 Points
2 Answers
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
Patricia Hector
42,901 Points
Issue with DB working locally with phpmyadmin [SOLVED]

Posted May 10, 2018 1:01pm by Patricia Hector

Patricia Hector
42,901 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
Olutope Ayorinde
2,875 Points
highest employee salary challenge

Posted April 13, 2018 6:44pm by Olutope Ayorinde

Olutope Ayorinde
2,875 Points
1 Answer
Olutope Ayorinde
2,875 Points
returning 1 row per employee

Posted April 13, 2018 6:41pm by Olutope Ayorinde

Olutope Ayorinde
2,875 Points
2 Answers
Gavin Schilling
37,904 Points
Doesn't NANs or blanks in columns change the count?

Posted April 4, 2018 7:21am by Gavin Schilling

Gavin Schilling
37,904 Points
1 Answer
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,046 Points
Joining teachers name onto student schedule

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

Charlie Harcourt
8,046 Points
3 Answers
Abdullah Jassim
4,551 Points
Once the two functions: Fifth and Seventh are created, instead of using inner join, why cant we use Union ALL?

Posted February 7, 2018 7:03pm by Abdullah Jassim

Abdullah Jassim
4,551 Points
1 Answer

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.