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
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
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
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
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
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
Tracy Cano
6,656 Points
Can someone help me understand how to answer this question about outer joins?

Posted October 15, 2023 8:54pm by Tracy Cano

Tracy Cano
6,656 Points
1 Answer
Rosina Marchan
3,011 Points
There are two tables Fruit and Vegetable table. The Fruit table has a FruitID and a Name column and the Vegetable table

Posted September 7, 2023 6:58pm by Rosina Marchan

Rosina Marchan
3,011 Points
1 Answer
Rosina Marchan
3,011 Points
What am I missing?

Posted September 7, 2023 6:53pm by Rosina Marchan

Rosina Marchan
3,011 Points
1 Answer
Jason Chalangary
11,695 Points
Bug in the Javascript

Posted August 16, 2023 12:39pm by Jason Chalangary

Jason Chalangary
11,695 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
PLUS

zaal rottunda
Courses Plus Student 2,434 Points
SQL Error: no such column: VIN

Posted May 3, 2023 8:46pm by zaal rottunda

zaal rottunda
Courses Plus Student 2,434 Points
1 Answer
Alyssa Daniel
1,944 Points
I don't understand

Posted April 20, 2023 7:43pm by Alyssa Daniel

Alyssa Daniel
1,944 Points
1 Answer
Anakin Bjelland
7,176 Points
I need some help with this union challenge

Posted March 30, 2023 9:40pm by Anakin Bjelland

Anakin Bjelland
7,176 Points
1 Answer
Vincent Almeroth
12,123 Points
What lesson shows use how to filter by the first letter of a column value?

Posted February 22, 2023 12:25am by Vincent Almeroth

Vincent Almeroth
12,123 Points
1 Answer
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
Vernon Kincaid
11,447 Points
What is a where statement that will not return a row that starts with the letter L through Z

Posted January 29, 2023 8:11pm by Vernon Kincaid

Vernon Kincaid
11,447 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
Gabriel Guerra
Data Analysis Techdegree Graduate 9,109 Points
Car data base query

Posted January 24, 2023 10:14pm by Gabriel Guerra

Gabriel Guerra
Data Analysis Techdegree Graduate 9,109 Points
2 Answers
Gabriel Guerra
Data Analysis Techdegree Graduate 9,109 Points
Querying Relational Database error

Posted January 21, 2023 2:03pm by Gabriel Guerra

Gabriel Guerra
Data Analysis Techdegree Graduate 9,109 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
Alexei Lazarowicz
5,153 Points
I have no idea how to sort the names by what letter they start with

Posted January 11, 2023 6:31am by Alexei Lazarowicz

Alexei Lazarowicz
5,153 Points
1 Answer
Spencer Lebel
3,125 Points
Code Challenge Task 3

Posted December 6, 2022 3:03am by Spencer Lebel

Spencer Lebel
3,125 Points
1 Answer
Geovani Mejia
Front End Web Development Techdegree Student 7,940 Points
Help with Querying Relational Databases

Posted October 3, 2022 10:27pm by Geovani Mejia

Geovani Mejia
Front End Web Development Techdegree Student 7,940 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
Katie Martens
1,962 Points
Need the WHERE clause?

Posted July 18, 2022 8:54pm by Katie Martens

Katie Martens
1,962 Points
1 Answer
Katie Martens
1,962 Points
Inner Join

Posted June 28, 2022 8:41pm by Katie Martens

Katie Martens
1,962 Points
2 Answers
Luis Brito
24,527 Points
Querying Relational Databases , Challenge Task 4 of 6

Posted May 27, 2022 8:20pm by Luis Brito

Luis Brito
24,527 Points
2 Answers

Prev Page 1 of 9 Next

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