Treehouse | Community | Subqueries

You found it first ⚡ 50% off any plan for 6 months, exclusive to new subscribers for a limited time only.

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

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

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

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Danny Gomez
2,317 Points
In a car database there is a Sale table with columns, SaleID, CarID, CustomerID, LocationID, SalesRepID, SaleAmount and

Posted September 24, 2025 9:05pm by Danny Gomez

Danny Gomez
2,317 Points
0 Answers
Aiya Ayazbayeva
3,524 Points
The hint says "did you select from the results table" and I did so I am not sure why the answer is incorrect

Posted August 1, 2025 4:09pm by Aiya Ayazbayeva

Aiya Ayazbayeva
3,524 Points
1 Answer
David Register
184 Points
Can I have some help with this query?

Posted July 16, 2025 4:18am by David Register

David Register
184 Points
1 Answer
Serena Woolard
73 Points
not sure how to do this im soo confused

Posted July 8, 2025 12:19am by Serena Woolard

Serena Woolard
73 Points
0 Answers
Abigail Solomon
4,716 Points
Name Error: name 'User' is not defined. I cannot add my name to the userbase because of this error.

Posted March 19, 2025 12:23am by Abigail Solomon

Abigail Solomon
4,716 Points
- Databases
2 Answers
Abigail Solomon
4,716 Points
Error: Was expecting 5 entries in the phone book. There's only 3.

Posted March 18, 2025 10:42pm by Abigail Solomon

Abigail Solomon
4,716 Points
1 Answer
Abigail Solomon
4,716 Points
Bummer: Was expecting 11 entries in the users table. There's only 10.

Posted March 18, 2025 9:27pm by Abigail Solomon

Abigail Solomon
4,716 Points
0 Answers
Robert Edmonds
1,690 Points
Unable to figure this answer out.

Posted March 15, 2025 6:03pm by Robert Edmonds

Robert Edmonds
1,690 Points
1 Answer
Odessa Winter
1,397 Points
Why is my query returning model that sold for less than 30000

Posted January 28, 2025 4:08am by Odessa Winter

Odessa Winter
1,397 Points
2 Answers
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
PLUS

abdel ahbe
Python Development Techdegree Student 2,125 Points
SELECT Name FROM Fruit WHERE Name <= 'K' UNION SELECT Name FROM Vegetable WHERE Name <= 'K'; Why is my query wrong?

Posted January 6, 2025 1:11pm by abdel ahbe

abdel ahbe
Python Development Techdegree Student 2,125 Points
2 Answers
Grant Whiting
3,645 Points
Question 4 asks me to get a list of all Female customers but I'm told this query doesn't do it:

Posted November 13, 2024 6:03pm by Grant Whiting

Grant Whiting
3,645 Points
2 Answers
Angelus Miculek
6,979 Points
no asterisk

Posted November 6, 2024 4:46pm by Angelus Miculek

Angelus Miculek
6,979 Points
2 Answers
Alexandra Washick
7,693 Points
WHERE clause and ORDER BY?

Posted October 24, 2024 4:42pm by Alexandra Washick

Alexandra Washick
7,693 Points
2 Answers
Wen Yan Cheong
1,482 Points
my query is not giving the correct results

Posted September 14, 2024 2:08pm by Wen Yan Cheong

Wen Yan Cheong
1,482 Points
1 Answer
Carlos Salame
Full Stack JavaScript Techdegree Student 13,418 Points
Im not sure why this isn't working

Posted September 6, 2024 4:27am by Carlos Salame

Carlos Salame
Full Stack JavaScript Techdegree Student 13,418 Points
0 Answers
missjones74
239 Points
select home_team as "Home Team",home_score as "Home Score",away_team as "Away Team",away_score as "Away Score",played_on

Posted August 5, 2024 6:48pm by missjones74

missjones74
239 Points
2 Answers
Rachel Waybill
1,837 Points
is there anywhere in here that i can practice more SQL? Like the input statements, creating a table & things like that?

Posted August 3, 2024 3:01am by Rachel Waybill

Rachel Waybill
1,837 Points
1 Answer
Rachel Waybill
1,837 Points
I don't understand what this is supposed to be.

Posted July 30, 2024 7:11pm by Rachel Waybill

Rachel Waybill
1,837 Points
1 Answer
Rachel Waybill
1,837 Points
This is backward - it hasn't shown me how to do this yet but it is supposed to in the next section

Posted July 30, 2024 12:15am by Rachel Waybill

Rachel Waybill
1,837 Points
1 Answer
Laura Dumitru
9,819 Points
DOESNT WORK: SELECT title LENGTH(title) AS longest_length FROM books ORDER BY longest_length DESC LIMIT 1;

Posted July 10, 2024 2:10pm by Laura Dumitru

Laura Dumitru
9,819 Points
1 Answer
Crystal Vesely
15,065 Points
Can I use JavaScript to connect SQL databases to a website?

Posted June 25, 2024 2:20pm by Crystal Vesely

Crystal Vesely
15,065 Points
- Databases
1 Answer
Nile Rankin-Watson
1,780 Points
What's wrong with this code? SELECT first_name || " " || last_name || " <" || email || ">" AS "to_field";

Posted June 18, 2024 8:28pm by Nile Rankin-Watson

Nile Rankin-Watson
1,780 Points
1 Answer
Jorge Rehlaender
16,422 Points
Error loading this resource

Posted May 24, 2024 2:45pm by Jorge Rehlaender

Jorge Rehlaender
16,422 Points
1 Answer
Abigail Solomon
4,716 Points
How do you alias the strings you concatenate to "to_field"? And properly concatenate these strings?

Posted May 10, 2024 8:33pm by Abigail Solomon

Abigail Solomon
4,716 Points
2 Answers
Killeon Patterson
18,528 Points
Accessing my MongDB Database

Posted May 3, 2024 12:05pm by Killeon Patterson

Killeon Patterson
18,528 Points
- Databases
4 Answers
Blake Leal
6,239 Points
SQL Basics - Challenge 1 -- Create a list of mailing information for orders that took place on April 20th, 2017.

Posted May 3, 2024 2:31am by Blake Leal

Blake Leal
6,239 Points
- Databases
1 Answer
Sultan X
530 Points
a Question about the SQL track

Posted April 30, 2024 11:27am by Sultan X

Sultan X
530 Points
- Databases
1 Answer
Ethan Scott
5,005 Points
Did he just say...Car DB...? lol made my day.

Posted April 11, 2024 10:43pm by Ethan Scott

Ethan Scott
5,005 Points
1 Answer
Daniel Benisti
1,466 Points
What's wrong with my query?

Posted March 3, 2024 4:40pm by Daniel Benisti

Daniel Benisti
1,466 Points
0 Answers

Prev Page 1 of 389 Next

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