Treehouse | Community | Filtering by Comparing Values

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

Join our Live Career-Building Workshop: Launch Your Tech-Adjacent Career! ⭐ Register here!

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

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

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

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

João Mendonça
2,793 Points
Stuck on SQL question, did I not SELECT?

Posted October 4, 2021 11:36am by João Mendonça

João Mendonça
2,793 Points
1 Answer
Tyler Young
1,581 Points
Why can't I use aliases for this query, following an example where first_name can be presented as "First Name"?

Posted September 10, 2021 8:03pm by Tyler Young

Tyler Young
1,581 Points
0 Answers
chris muhirwa
1,112 Points
need help with the code challenge

Posted September 2, 2021 5:17am by chris muhirwa

chris muhirwa
1,112 Points
1 Answer
chris muhirwa
1,112 Points
need help answering the question

Posted September 2, 2021 4:48am by chris muhirwa

chris muhirwa
1,112 Points
0 Answers
chris muhirwa
1,112 Points
need help figuring out what am missing in my code

Posted September 2, 2021 3:09am by chris muhirwa

chris muhirwa
1,112 Points
1 Answer
Holly Bancroft
5,162 Points
Dates in SQL

Posted August 22, 2021 11:20am by Holly Bancroft

Holly Bancroft
5,162 Points
1 Answer
Kate Johnson
Python Development Techdegree Graduate 20,155 Points
I don't understand what is wrong with my code here. [solved]

Posted July 25, 2021 8:35pm by Kate Johnson

Kate Johnson
Python Development Techdegree Graduate 20,155 Points
1 Answer
Michael Reta
255 Points
How do I query to find all of the rows with missing data without individually typing out each column name?

Posted July 25, 2021 6:09pm by Michael Reta

Michael Reta
255 Points
1 Answer
Andy McDonald
Python Development Techdegree Graduate 13,801 Points
how to find values outside of a given range in SQL

Posted July 24, 2021 5:32am by Andy McDonald

Andy McDonald
Python Development Techdegree Graduate 13,801 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
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
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
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
sv vs
Full Stack JavaScript Techdegree Student 925 Points
Im a little bit confused about the difference between these two options in the quiz, help!!

Posted May 20, 2021 5:37pm by sv vs

sv vs
Full Stack JavaScript Techdegree Student 925 Points
1 Answer
Piotr Sochaczewski
13,038 Points
Minor mistake

Posted April 12, 2021 7:23am by Piotr Sochaczewski

Piotr Sochaczewski
13,038 Points
1 Answer
Abirame Kumarathasan
1,053 Points
code not working

Posted March 19, 2021 7:36pm by Abirame Kumarathasan

Abirame Kumarathasan
1,053 Points
1 Answer
Beckett Brees
3,390 Points
I am being told I am missing a column but cannot find it - id, home_team, home_score, away_team, away_score, played_on.

Posted March 17, 2021 10:07am by Beckett Brees

Beckett Brees
3,390 Points
1 Answer
Tremayne Moncrief
2,380 Points
I am trying to answer this question and I keep getting an error stating something is wrong with my SQL statement.

Posted January 26, 2021 3:02am by Tremayne Moncrief

Tremayne Moncrief
2,380 Points
1 Answer
cgeorge
5,493 Points
Bummer: Did you select from the `users` table?

Posted January 11, 2021 1:22am by cgeorge

cgeorge
5,493 Points
1 Answer
Ra Bha
2,201 Points
Last Name Cruise

Posted November 27, 2020 10:32pm by Ra Bha

Ra Bha
2,201 Points
1 Answer
Ra Bha
2,201 Points
Find all actors whos first name starts with Will - not sure how to do this one

Posted November 27, 2020 10:20pm by Ra Bha

Ra Bha
2,201 Points
3 Answers
Ra Bha
2,201 Points
Why wouldn't the query here have the last_name before the first_name?

Posted November 9, 2020 4:36pm by Ra Bha

Ra Bha
2,201 Points
1 Answer
Cole Vance
882 Points
What is my query missing? SELECT * FROM users WHERE last_name = "Hinkley" OR "Pettit";

Posted October 25, 2020 5:25pm by Cole Vance

Cole Vance
882 Points
2 Answers
Alex Moon
1,888 Points
Picking all the data that is null

Posted October 24, 2020 11:16pm by Alex Moon

Alex Moon
1,888 Points
2 Answers
Jason Nutt
Front End Web Development Techdegree Graduate 24,760 Points
SELECT * FROM products WHERE price BETWEEN >= 10.99 AND price <= 12.99;

Posted October 24, 2020 6:08pm by Jason Nutt

Jason Nutt
Front End Web Development Techdegree Graduate 24,760 Points
1 Answer
Jason Nutt
Front End Web Development Techdegree Graduate 24,760 Points
I'm not sure how I am writing this wrong...SELECT username FROM users WHERE last_name = "Chalkey";

Posted October 24, 2020 3:48pm by Jason Nutt

Jason Nutt
Front End Web Development Techdegree Graduate 24,760 Points
5 Answers
Leslie Whitford
714 Points
What am I doing wrong in my command?

Posted September 10, 2020 6:50pm by Leslie Whitford

Leslie Whitford
714 Points
1 Answer
Aravind Rangaswamy
2,035 Points
this sports team database there's a results table with the columns of id, home_team, home_score, away_team, away_score

Posted September 8, 2020 8:29am by Aravind Rangaswamy

Aravind Rangaswamy
2,035 Points
1 Answer

Prev Page 2 of 10 Next

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