Treehouse | Community | Using a Subquery to Create a Temporary Table (Part 1)

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

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

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

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

⭐Get support and network on our Discord server! ⭐

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

John Munger
Data Analysis Techdegree Graduate 9,736 Points
dead link

Posted December 13, 2023 1:00am by John Munger

John Munger
Data Analysis Techdegree Graduate 9,736 Points
2 Answers
Wael Elsisi
211 Points
How to use Subqueries ?

Posted November 6, 2023 1:33am by Wael Elsisi

Wael Elsisi
211 Points
1 Answer
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
Kenzie Iles
1,773 Points
Error: near "ID": syntax error

Posted February 6, 2023 3:07pm by Kenzie Iles

Kenzie Iles
1,773 Points
1 Answer
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
Özgür Yildirim
4,088 Points
Difference between UNION and UNION ALL for the second practice question?

Posted July 17, 2021 7:27pm 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
jun cheng wong
17,021 Points
Check answer for question 2

Posted March 2, 2021 9:41am by jun cheng wong

jun cheng wong
17,021 Points
0 Answers
wc93
25,725 Points
Having problem selecting code because the test workspaces are too close to browser edge

Posted February 6, 2021 6:09pm by wc93

wc93
25,725 Points
0 Answers
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
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
Philip Porwisch
13,229 Points
Query not returning correct total

Posted June 27, 2020 6:20pm by Philip Porwisch

Philip Porwisch
13,229 Points
1 Answer
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
fairest
Full Stack JavaScript Techdegree Graduate 19,303 Points
Is this a decent solution for challenge 2?

Posted March 27, 2020 2:46am by fairest

fairest
Full Stack JavaScript Techdegree Graduate 19,303 Points
2 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
Claire Brehm
9,098 Points
Task 1 challenge help

Posted February 28, 2020 12:57am by Claire Brehm

Claire Brehm
9,098 Points
2 Answers
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

Prev Page 1 of 3 Next

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