Treehouse | Community | Filtering on More than One Condition

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

james mchugh
6,234 Points
It's telling me I didn't select all columns. I did and I checked the snytax and still getting this error

Posted February 17, 2022 3:00am by james mchugh

james mchugh
6,234 Points
1 Answer
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
Tremayne Moncrief
2,446 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,446 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
Claire Uzenski
1,026 Points
Need more help with SQL basics, having trouble with more of the equations

Posted January 20, 2020 1:18pm by Claire Uzenski

Claire Uzenski
1,026 Points
8 Answers
Antonio Pala
Front End Web Development Techdegree Student 16,928 Points
Am I missing something?

Posted October 24, 2019 10:08pm by Antonio Pala

Antonio Pala
Front End Web Development Techdegree Student 16,928 Points
1 Answer
Devin Goodson
907 Points
SELECT * FROM users WHERE last_name = "Hinkley" OR "Pettit" ; = Hinkley OR Pettit;

Posted October 15, 2019 7:40am by Devin Goodson

Devin Goodson
907 Points
1 Answer
Cliona Dowling
559 Points
What is incorrect in this query:

Posted September 4, 2019 4:01pm by Cliona Dowling

Cliona Dowling
559 Points
1 Answer
Cosmin Iuga
2,352 Points
your site is down

Posted July 20, 2019 5:52pm by Cosmin Iuga

Cosmin Iuga
2,352 Points
0 Answers
Cosmin Iuga
2,352 Points
I'm not able to answer this question.

Posted July 20, 2019 2:31pm by Cosmin Iuga

Cosmin Iuga
2,352 Points
5 Answers
kimberly moyer
1,773 Points
unsure on error

Posted June 19, 2019 6:41pm by kimberly moyer

kimberly moyer
1,773 Points
1 Answer
Brian Dengler
358 Points
Why is the quiz rejecting my answer?

Posted May 28, 2019 12:48am by Brian Dengler

Brian Dengler
358 Points
2 Answers
David Lucas
851 Points
I answered the question right but the Bummer prompt pops up. Please contact me regarding the SQL Basics course.

Posted May 11, 2019 7:03pm by David Lucas

David Lucas
851 Points
0 Answers
Michael Venner
351 Points
What is wrong with my SQL code ``` SELECT * FROM results WHERE away_team = Hessle AND away_score > 18; ```

Posted March 15, 2019 9:36pm by Michael Venner

Michael Venner
351 Points
1 Answer
Kyle St Jean St Jean
220 Points
i have the " FROM results " typed in for this challenge and it's giving me a prompt that I'm not selecting from results

Posted February 24, 2019 2:14am by Kyle St Jean St Jean

Kyle St Jean St Jean
220 Points
1 Answer
Christian Schou
9,208 Points
Error in SQL challenge

Posted February 19, 2019 9:49am by Christian Schou

Christian Schou
9,208 Points
1 Answer
Elyse Maniaci
349 Points
Why is my answer incorrect?

Posted October 22, 2018 8:12pm by Elyse Maniaci

Elyse Maniaci
349 Points
1 Answer
Ali Dabbir Khan
1,076 Points
What is the correct answer to the 2nd question?

Posted September 28, 2018 8:21am by Ali Dabbir Khan

Ali Dabbir Khan
1,076 Points
1 Answer
Kolio Kolev
785 Points
Not sure what's going on, but it keeps saying "did you select from the results table" and my code clearly selects it

Posted September 27, 2018 1:12am by Kolio Kolev

Kolio Kolev
785 Points
0 Answers
Shain Jones
1,315 Points
trouble with two conditions

Posted September 12, 2018 11:03pm by Shain Jones

Shain Jones
1,315 Points
1 Answer
Shain Jones
1,315 Points
Help with multiple conditions

Posted September 12, 2018 6:58pm by Shain Jones

Shain Jones
1,315 Points
1 Answer
Amy Hsieh
6,023 Points
This is easy but I didn't know what's wrong with my SQL code. I guess played_on means who play in that game.

Posted August 5, 2018 3:11pm by Amy Hsieh

Amy Hsieh
6,023 Points
4 Answers
Trevor Ward
353 Points
SELECT * FROM results WHERE id = "Hessle" and away_score > 18; Bummer: Did you select from the 'results' table?

Posted June 21, 2018 1:58am by Trevor Ward

Trevor Ward
353 Points
1 Answer
ericwidman3
4,679 Points
Not allowing me to continue

Posted June 3, 2018 10:24pm by ericwidman3

ericwidman3
4,679 Points
2 Answers

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