Treehouse | Community | Subqueries

AI can only take you so far. 🌟 Start with core skills in JavaScript, HTML, CSS, or Python. 🚀

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

New No-Code Track! 🚀start learning today!

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

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

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Ö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
Özgür Yildirim
4,088 Points
When inserting a row, do I have to write NULL for the id to make use of the autoincrementing property?

Posted July 15, 2021 12:39pm by Özgür Yildirim

Özgür Yildirim
4,088 Points
1 Answer
Özgür Yildirim
4,088 Points
Solutions are shown directly at the launch of the Playground!

Posted July 14, 2021 1:21pm by Özgür Yildirim

Özgür Yildirim
4,088 Points
0 Answers
Adam Pearson
19,432 Points
My solution for the Rex Rios schedule

Posted July 13, 2021 10:41am by Adam Pearson

Adam Pearson
19,432 Points
- Databases
0 Answers
Kristine Williams
12,470 Points
Comment to Treehouse about tasks 3 and 4 in subqueries challenge.

Posted July 10, 2021 8:44pm by Kristine Williams

Kristine Williams
12,470 Points
- Databases
0 Answers
Ricky Redman
7,520 Points
WHERE keyword

Posted July 8, 2021 5:36pm by Ricky Redman

Ricky Redman
7,520 Points
1 Answer
Steven Crutchfield
311 Points
Syntax on SQL Alias error

Posted June 27, 2021 2:26pm by Steven Crutchfield

Steven Crutchfield
311 Points
2 Answers
Erland Van Olmen
Full Stack JavaScript Techdegree Graduate 17,825 Points
Why are we passing the "article" object to res.render() in the "/:id" GET route instead of "article.dataValues" ?

Posted June 25, 2021 12:12pm by Erland Van Olmen

Erland Van Olmen
Full Stack JavaScript Techdegree Graduate 17,825 Points
- Databases
- Find Entries
1 Answer
clarence hollins
2,301 Points
what do they mean by missing angle brackets.

Posted June 19, 2021 10:53am by clarence hollins

clarence hollins
2,301 Points
1 Answer
Joseph Bertino
Full Stack JavaScript Techdegree Student 14,652 Points
Don't provide answers to SQL Playground queries

Posted June 18, 2021 3:47pm by Joseph Bertino

Joseph Bertino
Full Stack JavaScript Techdegree Student 14,652 Points
1 Answer
Anna Shepilova
4,128 Points
What is the solution for this question?

Posted June 17, 2021 2:51pm by Anna Shepilova

Anna Shepilova
4,128 Points
0 Answers
Tatia Burdett
1,470 Points
Sharing is Caring - Here is my solution.

Posted June 13, 2021 11:13pm by Tatia Burdett

Tatia Burdett
1,470 Points
- Databases
0 Answers
Tatia Burdett
1,470 Points
My Solution...

Posted June 13, 2021 8:33pm by Tatia Burdett

Tatia Burdett
1,470 Points
- Databases
1 Answer
Tatia Burdett
1,470 Points
LEFT OUTER JOIN, selecting from two tables, not resulting as expected.

Posted June 12, 2021 6:13pm by Tatia Burdett

Tatia Burdett
1,470 Points
1 Answer
Kathleen Pitches
2,967 Points
What does .* mean in SQL?

Posted June 9, 2021 4:50pm by Kathleen Pitches

Kathleen Pitches
2,967 Points
1 Answer
Jessica Malady
11,895 Points
How do I get angle brackets around the email address

Posted June 7, 2021 4:29pm by Jessica Malady

Jessica Malady
11,895 Points
1 Answer
Muaaz Matwadia
Full Stack JavaScript Techdegree Graduate 19,327 Points
SQL define model

Posted June 6, 2021 1:23pm by Muaaz Matwadia

Muaaz Matwadia
Full Stack JavaScript Techdegree Graduate 19,327 Points
- Databases
0 Answers
Regina Ackah
2,649 Points
How can I query a table to display all columns with missing data?

Posted June 2, 2021 10:56pm by Regina Ackah

Regina Ackah
2,649 Points
- Databases
0 Answers
Beau Coplin
7,903 Points
Different Approach

Posted June 1, 2021 8:17pm by Beau Coplin

Beau Coplin
7,903 Points
0 Answers
XXX xxx
Full Stack JavaScript Techdegree Student 1,449 Points
What if I use ORDER BY?

Posted May 29, 2021 10:05am by XXX xxx

XXX xxx
Full Stack JavaScript Techdegree Student 1,449 Points
1 Answer
XXX xxx
Full Stack JavaScript Techdegree Student 1,449 Points
Cannot get the right answer to the Challenge Task

Posted May 29, 2021 9:46am by XXX xxx

XXX xxx
Full Stack JavaScript Techdegree Student 1,449 Points
- Databases
1 Answer
Cody Stephenson
8,361 Points
My overly explicit solution starting from a different table.

Posted May 24, 2021 7:25pm by Cody Stephenson

Cody Stephenson
8,361 Points
0 Answers
Daniel Berger
4,820 Points
When using the wildcard (%) on the LIKE function, when is it appropriate to use 1 or 2 wildcards

Posted May 24, 2021 6:21pm by Daniel Berger

Daniel Berger
4,820 Points
1 Answer
tejaswini vadnal
1,587 Points
help this following query

Posted May 24, 2021 2:53pm by tejaswini vadnal

tejaswini vadnal
1,587 Points
1 Answer
Alessandro Pappacena
2,589 Points
Wrong count calculation

Posted May 23, 2021 10:31pm by Alessandro Pappacena

Alessandro Pappacena
2,589 Points
1 Answer
Alessandro Pappacena
2,589 Points
Problem with this challenge, what am I missing?

Posted May 23, 2021 12:54pm by Alessandro Pappacena

Alessandro Pappacena
2,589 Points
1 Answer
Cody Stephenson
8,361 Points
I got the correct answer - is there anything wrong with my solution from a best practices/readability standpoint?

Posted May 21, 2021 6:16pm by Cody Stephenson

Cody Stephenson
8,361 Points
- Databases
0 Answers

Prev Page 8 of 389 Next

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