Treehouse | Community | Subqueries

⚡ CYBER NOVEMBER SALE ⚡ 50% off any plan for 6 months, exclusive to new subscribers.

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

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

zaal rottunda
Courses Plus Student 2,434 Points
Use a subquery along with IN to list all the Model Names with a Sticker Price greater than $30000

Posted May 7, 2023 11:56pm by zaal rottunda

zaal rottunda
Courses Plus Student 2,434 Points
4 Answers
Sam Speaks
6,013 Points
What is this supposedly outputting? (Subqueries)

Posted January 25, 2023 12:37am by Sam Speaks

Sam Speaks
6,013 Points
1 Answer
Viktorija Kalniņa
1,652 Points
Error in script

Posted January 17, 2023 3:37pm by Viktorija Kalniņa

Viktorija Kalniņa
1,652 Points
2 Answers
Katie Martens
1,962 Points
Subquery using IN

Posted July 19, 2022 8:01pm by Katie Martens

Katie Martens
1,962 Points
1 Answer
Özgür Yildirim
4,088 Points
What is wrong with this query?

Posted July 17, 2021 8:39pm by Özgür Yildirim

Özgür Yildirim
4,088 Points
1 Answer
Özgür Yildirim
4,088 Points
Task 4 of 4 is driving me mad. Obviously I do not get it

Posted July 17, 2021 8:33pm by Özgür Yildirim

Özgür Yildirim
4,088 Points
0 Answers
Özgür Yildirim
4,088 Points
My subquery doesn't return all CustomerIDs for people who identify as female (F), apparently. But why?

Posted July 17, 2021 7:47pm by Özgür Yildirim

Özgür Yildirim
4,088 Points
0 Answers
Ola Ajayi
3,034 Points
I Have No Idea Where I Have Gone Wrong!

Posted May 6, 2021 9:28am by Ola Ajayi

Ola Ajayi
3,034 Points
1 Answer
Max Toth
3,777 Points
Subquery in the WHERE clause not detected?

Posted April 28, 2021 2:45pm by Max Toth

Max Toth
3,777 Points
1 Answer
John Richter
2,351 Points
Not sure what the syntax error is

Posted November 20, 2020 11:25pm by John Richter

John Richter
2,351 Points
1 Answer
Ariadna Rodriguez
6,281 Points
I'm getting a syntax error and I don't know what I am missing.

Posted November 10, 2020 9:54am by Ariadna Rodriguez

Ariadna Rodriguez
6,281 Points
1 Answer
Joseph Fox
3,648 Points
I cannot figure out what I am doing wrong and this code runs properly in the playground before this quiz.

Posted November 8, 2020 9:04pm by Joseph Fox

Joseph Fox
3,648 Points
0 Answers
Taylor Han
2,406 Points
Subquery Task 4 (with alias?)

Posted April 26, 2020 3:04am by Taylor Han

Taylor Han
2,406 Points
2 Answers
Taylor Han
2,406 Points
In my yellow subquery, my yellow subquery (task 2)

Posted April 24, 2020 6:19pm by Taylor Han

Taylor Han
2,406 Points
1 Answer
Taylor Han
2,406 Points
Subquery with SQL (Task 1)

Posted April 23, 2020 11:39pm by Taylor Han

Taylor Han
2,406 Points
2 Answers
James Goedicke
2,205 Points
I have taken this quiz several times and have put in a query that matches the query discussed in the training,

Posted April 13, 2020 11:00pm by James Goedicke

James Goedicke
2,205 Points
4 Answers
George Waller
5,228 Points
Subquery using IN

Posted March 23, 2020 4:54pm by George Waller

George Waller
5,228 Points
1 Answer
Erin DeSpain
6,763 Points
Impossible Results? "The subquery didn't return all CustomerIDs for people who identify as female (F)."

Posted December 11, 2019 7:34pm by Erin DeSpain

Erin DeSpain
6,763 Points
1 Answer
Tommy Gebru
30,164 Points
Challenge Task 4 of 4 Bummer: SQL Error: near "SELECT": syntax error

Posted August 22, 2019 10:12pm by Tommy Gebru

Tommy Gebru
30,164 Points
2 Answers
Skylar Gordon
7,943 Points
What does this return, if it doesn't return all sales to female customers?

Posted May 10, 2019 9:58pm by Skylar Gordon

Skylar Gordon
7,943 Points
2 Answers
PLUS

Kate Woodroffe
Courses Plus Student 6,685 Points
Stuck on task 4 of querying relational databases, sub queries assessment

Posted April 29, 2019 1:32pm by Kate Woodroffe

Kate Woodroffe
Courses Plus Student 6,685 Points
4 Answers
Ikechukwu Arum
5,337 Points
related to the subquery challenge using the "IN" Keyword

Posted April 4, 2019 6:40pm by Ikechukwu Arum

Ikechukwu Arum
5,337 Points
1 Answer
Hans Eisenman
1,315 Points
Having a little trouble with this derived table query. Error I'm getting is just "Bummer: try again!" :-\

Posted March 7, 2019 4:57pm by Hans Eisenman

Hans Eisenman
1,315 Points
1 Answer
Arthur Dunn
2,094 Points
Can I get help with Question 4: Derived Tables?

Posted January 18, 2019 11:49pm by Arthur Dunn

Arthur Dunn
2,094 Points
1 Answer
PLUS

YA Abidakadr
Courses Plus Student 2,017 Points
help without using the keyword in

Posted December 26, 2018 5:50am by YA Abidakadr

YA Abidakadr
Courses Plus Student 2,017 Points
1 Answer
PLUS

YA Abidakadr
Courses Plus Student 2,017 Points
I need help please as soon as possible

Posted December 26, 2018 5:27am by YA Abidakadr

YA Abidakadr
Courses Plus Student 2,017 Points
1 Answer
David Corrales
4,698 Points
Oh my gosh this stuff is getting tough! Subqueries are challenging anyone know how to solve this?

Posted December 19, 2018 11:26pm by David Corrales

David Corrales
4,698 Points
4 Answers

Prev Page 1 of 2 Next

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