Treehouse | Community | Searching Tables with 'WHERE'

🤑 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

pra saw
233 Points
stuck

Posted March 20, 2019 11:29am by pra saw

pra saw
233 Points
1 Answer
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
Ker Sing Tan
10,573 Points
Code Challenge: Task 1 of 1

Posted March 12, 2019 3:28pm by Ker Sing Tan

Ker Sing Tan
10,573 Points
3 Answers
Zoe Dadian
177 Points
im not sure what Im doing wrong here

Posted March 11, 2019 3:17am by Zoe Dadian

Zoe Dadian
177 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
Seamus Sionóid
27,798 Points
NOT BETWEEN ?

Posted January 13, 2019 1:11pm by Seamus Sionóid

Seamus Sionóid
27,798 Points
0 Answers
Tevin Muparadzi
1,724 Points
From the users table, find all the username fields with the last_name of "Chalkley". Only return the usernames.

Posted January 13, 2019 4:22am by Tevin Muparadzi

Tevin Muparadzi
1,724 Points
1 Answer
arjunyad
Python Web Development Techdegree Student 444 Points
i don't understand

Posted December 25, 2018 8:24am by arjunyad

arjunyad
Python Web Development Techdegree Student 444 Points
2 Answers
Ben Brown
799 Points
I am typing in results for the Table, but it is saying that I am not selecting from the results table

Posted December 13, 2018 3:58pm by Ben Brown

Ben Brown
799 Points
1 Answer
PLUS

Brandy Steals
Courses Plus Student 5,457 Points
Did you select from the 'results' table error message

Posted October 27, 2018 1:37am by Brandy Steals

Brandy Steals
Courses Plus Student 5,457 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
Andrew Davis
2,405 Points
Why are the exercises already filled in on my SQL workspace?

Posted October 15, 2018 7:45pm by Andrew Davis

Andrew Davis
2,405 Points
3 Answers
Sandeep Padda
2,781 Points
how would i answer this challenge?

Posted October 15, 2018 4:29pm by Sandeep Padda

Sandeep Padda
2,781 Points
2 Answers
Rhea Khanna
2,838 Points
I do not understand the concept of WHERE (column, operator and value is put)

Posted October 14, 2018 2:40pm by Rhea Khanna

Rhea Khanna
2,838 Points
2 Answers
Phillip Blake
1,182 Points
Problem while trying to filter by Dates

Posted October 9, 2018 11:28pm by Phillip Blake

Phillip Blake
1,182 Points
1 Answer
Thue Madsen
4,219 Points
"You didn't select all columns" but there are not more columns.

Posted October 3, 2018 8:05pm by Thue Madsen

Thue Madsen
4,219 Points
3 Answers
Fairooz Adams
2,704 Points
Problem with code.

Posted September 28, 2018 9:22pm by Fairooz Adams

Fairooz Adams
2,704 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
kevin nadjarian
1,498 Points
Select Multiple table VS INNER JOIN?

Posted September 15, 2018 6:08pm by kevin nadjarian

kevin nadjarian
1,498 Points
2 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
Fairooz Adams
2,704 Points
Can't get this to work!

Posted September 5, 2018 9:14pm by Fairooz Adams

Fairooz Adams
2,704 Points
1 Answer
PLUS

Ethan Martin
Courses Plus Student 1,883 Points
Invalid Ratings

Posted August 27, 2018 9:56pm by Ethan Martin

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

Ethan Martin
Courses Plus Student 1,883 Points
Who are these Actors?

Posted August 27, 2018 9:47pm by Ethan Martin

Ethan Martin
Courses Plus Student 1,883 Points
4 Answers
Ruchi P
123 Points
We have a database that runs a sports team's website. In the results table we have the columns id, home_team, home_score

Posted August 21, 2018 7:24am by Ruchi P

Ruchi P
123 Points
1 Answer
Erin Clayton
3,840 Points
What's up with the SQL Playground mismatch on this video??

Posted August 20, 2018 12:33am by Erin Clayton

Erin Clayton
3,840 Points
1 Answer
Shain Jones
1,315 Points
the code challenge is asking if I "selected results as my table." My code is SELECT * FROM results WHERE away_team<10;

Posted August 16, 2018 7:04pm by Shain Jones

Shain Jones
1,315 Points
3 Answers
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

Prev Page 4 of 6 Next

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