Treehouse | Community | Using IN with Subqueries to Filter Data

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

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
Remi Vledder
14,144 Points
Subquery 'loans challenge': Feedback on this solution

Posted July 29, 2019 12:40pm by Remi Vledder

Remi Vledder
14,144 Points
1 Answer
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
PLUS

Sharina Jones
Courses Plus Student 18,771 Points
Combining the results of subqueries

Posted February 20, 2019 10:10pm by Sharina Jones

Sharina Jones
Courses Plus Student 18,771 Points
1 Answer
PLUS

Sharina Jones
Courses Plus Student 18,771 Points
Query producing incorrect results

Posted February 20, 2019 7:55pm by Sharina Jones

Sharina Jones
Courses Plus Student 18,771 Points
2 Answers
Harris Handoko
3,932 Points
Please critique my code for the North South Book Loan practice problem

Posted February 3, 2019 4:41am by Harris Handoko

Harris Handoko
3,932 Points
4 Answers
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
Teacher Russell
16,873 Points
https://teamtreehouse.com/library/querying-relational-databases/subqueries/subqueries

Posted October 24, 2018 6:17pm by Teacher Russell

Teacher Russell
16,873 Points
1 Answer
Sam Beattie
2,413 Points
Not sure what I'm getting wrong here. It says I'm missing the "IN keyword," but where would I put it?

Posted October 15, 2018 5:26am by Sam Beattie

Sam Beattie
2,413 Points
5 Answers
Fairooz Adams
2,704 Points
Keep getting an error.

Posted October 14, 2018 10:29pm by Fairooz Adams

Fairooz Adams
2,704 Points
2 Answers
Elsie Martinson
2,704 Points
Can't get past Task 2 of 4 - Querying Relational Databases

Posted October 2, 2018 1:13pm by Elsie Martinson

Elsie Martinson
2,704 Points
1 Answer
Sassafras Finley
13,168 Points
I have no idea why this isn't returning the right amount of rows. Please tell me what I've got wrong here.

Posted September 26, 2018 4:22pm by Sassafras Finley

Sassafras Finley
13,168 Points
1 Answer
D Elis
13,571 Points
Question about SQL - Review and Practice from Querying Relational Databases …

Posted August 9, 2018 1:37pm by D Elis

D Elis
13,571 Points
2 Answers
Braedon Currah
10,272 Points
I think I have a correct answer, but the course doesn't clear.

Posted July 17, 2018 10:28pm by Braedon Currah

Braedon Currah
10,272 Points
1 Answer
Deborah Watson
2,614 Points
Subquries

Posted June 29, 2018 6:44pm by Deborah Watson

Deborah Watson
2,614 Points
2 Answers
jlampstack
23,932 Points
Is my solution correct?

Posted June 29, 2018 12:52pm by jlampstack

jlampstack
23,932 Points
2 Answers
Kareem Jeiroudi
14,984 Points
Last Challenge Task 4 of 4 Bummer: Your query didn't return all columns from the Sale table for who's CustomerIDs .....

Posted May 26, 2018 6:05pm by Kareem Jeiroudi

Kareem Jeiroudi
14,984 Points
1 Answer
Philip Schultz
11,437 Points
Why does UNION ALL work in this case and not just UNION

Posted May 13, 2018 1:10pm by Philip Schultz

Philip Schultz
11,437 Points
2 Answers
Sean Flanagan
33,237 Points
Book count

Posted April 17, 2018 5:43pm by Sean Flanagan

Sean Flanagan
33,237 Points
1 Answer
Claudio Paladini
13,403 Points
How is this different from a join?

Posted April 4, 2018 3:05pm by Claudio Paladini

Claudio Paladini
13,403 Points
1 Answer
Abdullah Jassim
4,551 Points
Why does the GROUP BY Function in SQL add more names. It isnt just suppose to cluster together rows together?

Posted February 6, 2018 6:37am by Abdullah Jassim

Abdullah Jassim
4,551 Points
1 Answer
Donnie Driskell
2,243 Points
Relational Data Bases PlayGround Challenge: books north and south

Posted December 28, 2017 12:56am by Donnie Driskell

Donnie Driskell
2,243 Points
4 Answers

Prev Page 2 of 3 Next

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