Treehouse | Community | Subqueries Review

💫 Take our 2024 Developer Survey and enter to win a FREE Techdegree! 🏆

Join our Live Career-Building Workshop: How to Master the Job Hunt! ⭐ Register here!

🏛️ Access Treehouse at your local library for free! Check out Treehouse Near Me.

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

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

Join our free community Discord server here!

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

theteamtreehouse
3,472 Points
When and where is this mentioned, what is the answer and why?

Posted August 22, 2020 2:50pm by theteamtreehouse

theteamtreehouse
3,472 Points
1 Answer
theteamtreehouse
3,472 Points
Link broken

Posted August 22, 2020 12:50am by theteamtreehouse

theteamtreehouse
3,472 Points
1 Answer
devis
4,059 Points
Where are the solutions for the workspace practice sessions of each of the 4 chapters of the course?

Posted August 21, 2020 10:39am by devis

devis
4,059 Points
0 Answers
theteamtreehouse
3,472 Points
I don't get why this is wrong

Posted August 21, 2020 12:24am by theteamtreehouse

theteamtreehouse
3,472 Points
1 Answer
theteamtreehouse
3,472 Points
Why wouldn't this also work?

Posted August 20, 2020 10:55pm by theteamtreehouse

theteamtreehouse
3,472 Points
1 Answer
theteamtreehouse
3,472 Points
Is there a CAP() function in SQL?

Posted August 20, 2020 4:37pm by theteamtreehouse

theteamtreehouse
3,472 Points
- Databases
1 Answer
theteamtreehouse
3,472 Points
This test case only supports "operator ||", but it did not specify that it only supports SQLite syntax. I used CONCAT().

Posted August 20, 2020 4:15pm by theteamtreehouse

theteamtreehouse
3,472 Points
0 Answers
Betlem Ferrer
347 Points
Order by

Posted August 16, 2020 2:33pm by Betlem Ferrer

Betlem Ferrer
347 Points
0 Answers
Ash Mitchell
6,034 Points
Why do we not use 'SELECT FROM' in this query case?

Posted August 13, 2020 12:31pm by Ash Mitchell

Ash Mitchell
6,034 Points
1 Answer
Leo Scheid
10,240 Points
To me this seems to give a better overview of the schedule ... What do you think?

Posted August 13, 2020 12:02pm by Leo Scheid

Leo Scheid
10,240 Points
- Databases
0 Answers
Adam Hughes
1,259 Points
Getting Max Length with title

Posted August 11, 2020 1:28pm by Adam Hughes

Adam Hughes
1,259 Points
1 Answer
sherelle smith
1,387 Points
Hey for challenge 1 of 6. Create a distinct result. I'm getting an error "you're missing UNION keyword"

Posted August 8, 2020 8:19pm by sherelle smith

sherelle smith
1,387 Points
2 Answers
SHAWNELL HARRISON
16,282 Points
can someone please hellp me?

Posted August 4, 2020 10:04pm by SHAWNELL HARRISON

SHAWNELL HARRISON
16,282 Points
1 Answer
Justin Young
7,015 Points
SELECT first_name || " " || last_name || " " || <email> AS "to_field" FROM patrons; [SOLVED]

Posted August 4, 2020 9:20pm by Justin Young

Justin Young
7,015 Points
1 Answer
CarteA Sharrock
4,860 Points
I am inputting my code as: SELECT * FROM results WHERE id = "Hessle" AND played_on >= "2015-10-01"; what is wrong?

Posted August 3, 2020 3:44pm by CarteA Sharrock

CarteA Sharrock
4,860 Points
2 Answers
aditya verma
1,853 Points
Please improve the quality of questions, the period at the end of the text, is it part of the output or not?!

Posted August 2, 2020 11:06am by aditya verma

aditya verma
1,853 Points
2 Answers
aditya verma
1,853 Points
Don't know whats wrong

Posted August 2, 2020 10:58am by aditya verma

aditya verma
1,853 Points
1 Answer
aditya verma
1,853 Points
Cannot identify the mistake

Posted August 2, 2020 10:55am by aditya verma

aditya verma
1,853 Points
1 Answer
aditya verma
1,853 Points
Mistake in code

Posted August 2, 2020 5:58am by aditya verma

aditya verma
1,853 Points
1 Answer
Todd Hamblen
4,523 Points
What type system is this supposed to be ran on?

Posted July 20, 2020 4:36pm by Todd Hamblen

Todd Hamblen
4,523 Points
1 Answer
sherelle smith
1,387 Points
SELECT * FROM books WHERE genre LIKE "%Fantasy" ORDER BY first_published LIMIT 5 ASC;

Posted July 19, 2020 5:57pm by sherelle smith

sherelle smith
1,387 Points
2 Answers
Alexander Vasin
7,938 Points
Bummer: Expected results to look like "Andrew CHALKLEY", "MCL1001" not "Andrew CHALKLEY", "MCL1001". Looks like the same

Posted July 17, 2020 4:53pm by Alexander Vasin

Alexander Vasin
7,938 Points
1 Answer
sherelle smith
1,387 Points
"Was expecting 11 entries in the users table. There's only 10" error?

Posted July 11, 2020 4:18am by sherelle smith

sherelle smith
1,387 Points
3 Answers
PLUS

mohammad almotairy
Courses Plus Student 606 Points
I did not understand the question Write the SQL query to retrieve the 3rd page of results

Posted July 9, 2020 12:23pm by mohammad almotairy

mohammad almotairy
Courses Plus Student 606 Points
1 Answer
Jorgen Rasmussen
3,367 Points
Loans,books and patrons question

Posted July 8, 2020 7:02pm by Jorgen Rasmussen

Jorgen Rasmussen
3,367 Points
- Databases
0 Answers
Timmy Welch
1,599 Points
Getting same result as expected but not being allowed past the question.

Posted July 4, 2020 3:27pm by Timmy Welch

Timmy Welch
1,599 Points
1 Answer
Ariadna Rodriguez
6,281 Points
I don't understand where I should SELECT a new column and where I should concatenate the new output

Posted July 4, 2020 9:39am by Ariadna Rodriguez

Ariadna Rodriguez
6,281 Points
1 Answer
Matt Fuller
2,395 Points
Is Order Count w/ Date Challenge Still Flawed?

Posted July 3, 2020 5:53pm by Matt Fuller

Matt Fuller
2,395 Points
1 Answer
Benjamin Hanley
3,410 Points
SQL Error: near "Car": syntax error

Posted July 2, 2020 2:34pm by Benjamin Hanley

Benjamin Hanley
3,410 Points
2 Answers
Tom Holliday
2,868 Points
I don't understand how we are supposed to know what the correct email formatting is. Are we supposed to add the < signs?

Posted July 1, 2020 1:36pm by Tom Holliday

Tom Holliday
2,868 Points
1 Answer

Prev Page 13 of 388 Next

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