Treehouse | Community | Filtering on More than One Condition

💥 2026 New Year's Sale 💥 Take $20.26 off your first month on any monthly plan (new subscribers only, renews at regular price).

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

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

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
PLUS

Abhijeet Pednekar
Courses Plus Student 1,294 Points
Trying to update with this query

Posted September 1, 2018 12:05pm by Abhijeet Pednekar

Abhijeet Pednekar
Courses Plus Student 1,294 Points
1 Answer
PLUS

Ethan Martin
Courses Plus Student 1,883 Points
Enter a review for E.T. Use a username and review of your choosing.

Posted August 31, 2018 3:55pm by Ethan Martin

Ethan Martin
Courses Plus Student 1,883 Points
- Databases
2 Answers
PLUS

Ethan Martin
Courses Plus Student 1,883 Points
Select multiple columns from multiple tables in a specific order.

Posted August 31, 2018 12:45am by Ethan Martin

Ethan Martin
Courses Plus Student 1,883 Points
- Databases
1 Answer
PLUS

Takyi Akwah
Courses Plus Student 1,049 Points
AVG Help

Posted August 30, 2018 8:08pm by Takyi Akwah

Takyi Akwah
Courses Plus Student 1,049 Points
1 Answer
Daniel Sparks
2,695 Points
I am uncertain as to why I am receiving an error message suggesting that I have only entered three of the four values.

Posted August 27, 2018 6:40pm by Daniel Sparks

Daniel Sparks
2,695 Points
1 Answer
Brian Ross
11,209 Points
Getting a weird error: Expected results to look like "Andrew CHALKLEY", "MCL1001" not "Andrew CHALKLEY", "MCL1001".

Posted August 26, 2018 11:04pm by Brian Ross

Brian Ross
11,209 Points
5 Answers
Hasan Ali
2,039 Points
Not sure where i am going wrong

Posted July 27, 2018 6:34pm by Hasan Ali

Hasan Ali
2,039 Points
3 Answers
PLUS

Tony Tomczeszyn
Courses Plus Student 2,919 Points
Databases

Posted July 26, 2018 3:55pm by Tony Tomczeszyn

Tony Tomczeszyn
Courses Plus Student 2,919 Points
- Databases
3 Answers
Avid Coder
2,053 Points
SQL help regarding aliasing

Posted July 25, 2018 4:08pm by Avid Coder

Avid Coder
2,053 Points
2 Answers
Rajnish Kumar
41,092 Points
query for Name autocomplete??

Posted July 25, 2018 4:53am by Rajnish Kumar

Rajnish Kumar
41,092 Points
- Databases
1 Answer
Hasan Ali
2,039 Points
not sure what the question is asking me.

Posted July 24, 2018 9:10pm by Hasan Ali

Hasan Ali
2,039 Points
1 Answer
Jonathan Hartmayer
5,626 Points
Average cost of order

Posted July 20, 2018 7:21am by Jonathan Hartmayer

Jonathan Hartmayer
5,626 Points
1 Answer
Daniele Fusari
40,669 Points
CREATE TABLE MEMBERS (ID PRIMARY KEY, FIRST_NAME, LAST_NAME, FAVORITE_ROCK)

Posted July 16, 2018 7:40pm by Daniele Fusari

Daniele Fusari
40,669 Points
1 Answer
Kendell Dancy
15,158 Points
What am I doing wrong here?

Posted July 12, 2018 8:46pm by Kendell Dancy

Kendell Dancy
15,158 Points
1 Answer
Felix Bynum
1,129 Points
I think my issue is more about showing the difference in exchange rate rather than the set up of the query.

Posted July 5, 2018 10:23pm by Felix Bynum

Felix Bynum
1,129 Points
1 Answer
michelle gleed
23,811 Points
How to Edit Permissions for data/db?

Posted June 23, 2018 6:42am by michelle gleed

michelle gleed
23,811 Points
2 Answers
Killeon Patterson
18,528 Points
Adding Data to MongoDB

Posted June 22, 2018 5:38pm by Killeon Patterson

Killeon Patterson
18,528 Points
- Databases
8 Answers
Deborah Watson
2,614 Points
STRFTIME() Bummer: You may have got your params the wrong way around.

Posted June 21, 2018 5:07pm by Deborah Watson

Deborah Watson
2,614 Points
3 Answers
Odane Williams
6,692 Points
I followed all the examples but I'm getting an error that says the query is not returning through A and K.

Posted June 15, 2018 6:28pm by Odane Williams

Odane Williams
6,692 Points
1 Answer
Zach Bucek
10,798 Points
Deprecated setup method?

Posted June 15, 2018 5:10pm by Zach Bucek

Zach Bucek
10,798 Points
5 Answers
Michael Martin
8,936 Points
What is wrong here? I don't understand the output matches against itself

Posted June 15, 2018 4:13am by Michael Martin

Michael Martin
8,936 Points
2 Answers
Hanna Han
4,105 Points
Columns that are able to have null values

Posted June 4, 2018 12:47pm by Hanna Han

Hanna Han
4,105 Points
1 Answer
Daniele Santos
16,536 Points
Querying issues SELECT Name FROM Fruit UNION SELECT Name FROM Vegetable WHERE Name BETWEEN "A" AND "K";

Posted May 31, 2018 1:43pm by Daniele Santos

Daniele Santos
16,536 Points
1 Answer
Troy Erby
6,332 Points
Having trouble with Reporting SQL with the REPLACE function

Posted May 22, 2018 1:29pm by Troy Erby

Troy Erby
6,332 Points
1 Answer
Giuseppe Ardito
14,130 Points
Replacement functions with multiple conditions

Posted January 11, 2018 12:10am by Giuseppe Ardito

Giuseppe Ardito
14,130 Points
1 Answer
Hosam Darwish
14,309 Points
I don't understand what is wrong with my query

Posted January 17, 2017 5:15pm by Hosam Darwish

Hosam Darwish
14,309 Points
- Databases
4 Answers
Dino Heras
8,381 Points
SQL quiz question

Posted January 24, 2016 3:52am by Dino Heras

Dino Heras
8,381 Points
- Databases
4 Answers

Prev Page 233 of 389 Next

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