Treehouse | Community | Filtering by Comparing Values

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

Join our Live Career-Building Workshop: Fast-Track Your Tech Career Without a Degree! ⭐ 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

MUSTAFA TAHA
5,150 Points
why when I write this come I get error what is the wrong? SELECT * FROM results WHERE home_team > 12;

Posted July 25, 2018 8:05pm by MUSTAFA TAHA

MUSTAFA TAHA
5,150 Points
2 Answers
yan wang
2,449 Points
Select Query

Posted July 25, 2018 2:06pm by yan wang

yan wang
2,449 Points
1 Answer
PLUS

Jonathan Pina
Courses Plus Student 157 Points
From the users table, find all the username fields with the last_name of "Chalkley". Only return the usernames.

Posted June 21, 2018 10:44am by Jonathan Pina

Jonathan Pina
Courses Plus Student 157 Points
2 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
Susan Thatcher
1,217 Points
My code: SELECT username FROM user WHERE last_name= "Chalkley"; It's not working.

Posted June 17, 2018 10:13pm by Susan Thatcher

Susan Thatcher
1,217 Points
2 Answers
adam woolf
1,181 Points
there is a bug here. i believe my syntax is correct

Posted June 12, 2018 12:35am by adam woolf

adam woolf
1,181 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
Nosin mahbub
664 Points
From the users table, find all the username fields with the last_name of "Chalkley". Only return the usernames

Posted June 3, 2018 7:30pm by Nosin mahbub

Nosin mahbub
664 Points
1 Answer
Hanna Han
4,105 Points
19 th century

Posted May 31, 2018 9:32am by Hanna Han

Hanna Han
4,105 Points
3 Answers
Hanna Han
4,105 Points
Keyword IN usage

Posted May 29, 2018 2:06pm by Hanna Han

Hanna Han
4,105 Points
2 Answers
PLUS

Ed Peters
Courses Plus Student 567 Points
Hi. I'm stuck on what goes between the two numerical values here.

Posted April 29, 2018 9:25pm by Ed Peters

Ed Peters
Courses Plus Student 567 Points
2 Answers
Hiroyuki Watanabe
7,800 Points
CC/VScript says "end keyword" instead of "IN" keyword.

Posted December 22, 2017 12:51am by Hiroyuki Watanabe

Hiroyuki Watanabe
7,800 Points
1 Answer
Mohammad Aslam
6,053 Points
Can someone please explain this? What will happen if I select B as the answer?

Posted October 15, 2017 4:25am by Mohammad Aslam

Mohammad Aslam
6,053 Points
2 Answers
Patrik Horváth
11,110 Points
why its not AND ? it telling both Conditions as i underestend good

Posted August 27, 2017 9:34am by Patrik Horváth

Patrik Horváth
11,110 Points
1 Answer
Max F
9,900 Points
Question about relation between LIKE and %

Posted April 27, 2017 3:46am by Max F

Max F
9,900 Points
1 Answer
Ashley Chenn
8,329 Points
I'm brand-spanking-new to SQL. Any recommendations on tools to build and store a SQL database?

Posted April 13, 2017 2:58pm by Ashley Chenn

Ashley Chenn
8,329 Points
1 Answer
nathanielcusano
9,808 Points
Can you have AND <condition 3> etc?

Posted March 14, 2017 11:26pm by nathanielcusano

nathanielcusano
9,808 Points
1 Answer
PLUS

Abhishek Yadav
Courses Plus Student 692 Points
qUIZ

Posted March 5, 2017 7:20am by Abhishek Yadav

Abhishek Yadav
Courses Plus Student 692 Points
1 Answer
Elaine Tran
809 Points
Is there a better way to solve "Find all the invalid ratings in one query." I did NOT IN (1,2,3,4,5).

Posted January 3, 2017 7:43am by Elaine Tran

Elaine Tran
809 Points
4 Answers
Mohammed Safa
639 Points
Download sql File

Posted October 6, 2016 6:43am by Mohammed Safa

Mohammed Safa
639 Points
2 Answers
Kristian Woods
23,414 Points
SQL relationships between tables?

Posted October 2, 2016 3:56pm by Kristian Woods

Kristian Woods
23,414 Points
1 Answer
András Novoszáth
1,283 Points
Difference between IN and Between?

Posted September 17, 2016 3:20pm by András Novoszáth

András Novoszáth
1,283 Points
2 Answers
Andreas Frost Nordstrøm-Hansen
2,443 Points
Need help on the SQL Playground. Movies with any missing data

Posted September 6, 2016 1:42pm by Andreas Frost Nordstrøm-Hansen

Andreas Frost Nordstrøm-Hansen
2,443 Points
5 Answers
Miguel Nunez
3,266 Points
Why isn't tree house giving any more badges now? Its very rare now I notice.

Posted August 12, 2016 12:39am by Miguel Nunez

Miguel Nunez
3,266 Points
1 Answer
Miguel Nunez
3,266 Points
Fill in the missing operator. Today is 19th October 2019. I want to find all matches happening today and in the future.

Posted August 12, 2016 12:19am by Miguel Nunez

Miguel Nunez
3,266 Points
2 Answers
Miguel Nunez
3,266 Points
If I wanted to return rows that match both conditions, which keyword would I use?

Posted August 11, 2016 10:38am by Miguel Nunez

Miguel Nunez
3,266 Points
4 Answers
Miguel Nunez
3,266 Points
Please fill in the correct answer in each blank provided below. Fill in the blank(s) below:

Posted August 11, 2016 10:04am by Miguel Nunez

Miguel Nunez
3,266 Points
2 Answers
Miguel Nunez
3,266 Points
Two wild cards vs One in SQL?

Posted August 11, 2016 8:34am by Miguel Nunez

Miguel Nunez
3,266 Points
1 Answer
ammarkhan
Front End Web Development Techdegree Student 21,661 Points
Why use IN, where = make sense?

Posted July 8, 2016 9:34am by ammarkhan

ammarkhan
Front End Web Development Techdegree Student 21,661 Points
2 Answers
sowmya Badida
394 Points
How does SQL know which id to take as we have book_id,patron_id,id in loans table?

Posted June 2, 2016 8:58pm by sowmya Badida

sowmya Badida
394 Points
4 Answers

Prev Page 5 of 6 Next

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