Treehouse | Community | Searching Tables with 'WHERE'

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

Jason Nutt
Front End Web Development Techdegree Graduate 24,851 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,851 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
Usha Rani
107 Points
using as and special character " " but not getting correct query

Posted August 28, 2020 8:56pm by Usha Rani

Usha Rani
107 Points
1 Answer
Shain Jones
1,315 Points
BETWEEN , SELECT statement

Posted August 28, 2020 6:03pm by Shain Jones

Shain Jones
1,315 Points
1 Answer
Shain Jones
1,315 Points
seems to be simple but I am missing something. task is get results of home team scores <=. Not liking my syntax

Posted August 28, 2020 2:06pm by Shain Jones

Shain Jones
1,315 Points
1 Answer
SHAWNELL HARRISON
16,282 Points
Can someone please help me?

Posted August 26, 2020 9:55pm by SHAWNELL HARRISON

SHAWNELL HARRISON
16,282 Points
1 Answer
SHAWNELL HARRISON
16,282 Points
can someone please hellp me?

Posted August 4, 2020 10:04pm by SHAWNELL HARRISON

SHAWNELL HARRISON
16,282 Points
1 Answer
CarteA Sharrock
4,860 Points
I am inputting my code as: SELECT * FROM results WHERE id = "Hessle" AND played_on >= "2015-10-01"; what is wrong?

Posted August 3, 2020 3:44pm by CarteA Sharrock

CarteA Sharrock
4,860 Points
2 Answers
Joe Li
3,234 Points
What column am I missing from my query?

Posted May 28, 2020 4:34pm by Joe Li

Joe Li
3,234 Points
2 Answers
Richard Chintembo
5,400 Points
In the Yorkshire Division Four in Rugby, the team Hessle RUFC have a website that shows their latest matches. Their data

Posted May 23, 2020 2:21pm by Richard Chintembo

Richard Chintembo
5,400 Points
1 Answer
Blake Miller
247 Points
I think there is a bug not letting me move on. I believe this query is correct.

Posted April 26, 2020 9:20pm by Blake Miller

Blake Miller
247 Points
1 Answer
Stacy Villibord
2,017 Points
Challange Task

Posted April 22, 2020 2:38am by Stacy Villibord

Stacy Villibord
2,017 Points
2 Answers
Dennis Dumbreni
14,146 Points
search

Posted April 18, 2020 6:54pm by Dennis Dumbreni

Dennis Dumbreni
14,146 Points
1 Answer
Farfetch UK Spinetto
2,139 Points
Hello, I don't understand why my answer is incorrect

Posted April 16, 2020 8:42am by Farfetch UK Spinetto

Farfetch UK Spinetto
2,139 Points
0 Answers
Bas Spijker
353 Points
Hello. I got stuck with this database challenge. Could someone provide me the correct query?

Posted April 14, 2020 6:14pm by Bas Spijker

Bas Spijker
353 Points
2 Answers
Chris Hummel
13,960 Points
The database doesn't respond when I enter my query

Posted April 3, 2020 11:22pm by Chris Hummel

Chris Hummel
13,960 Points
1 Answer
A X
12,842 Points
What is a Foreign Key?

Posted March 30, 2020 10:35pm by A X

A X
12,842 Points
2 Answers
A X
12,842 Points
Why do companies use 3rd party tools to generate reports?

Posted March 30, 2020 9:15pm by A X

A X
12,842 Points
2 Answers
Ashish Thannippara
2,793 Points
hello the code section is broken and will not assess my code or let me progress with the course?

Posted March 19, 2020 10:06pm by Ashish Thannippara

Ashish Thannippara
2,793 Points
2 Answers
Brendan Quinn
2,847 Points
Hi guys, I am having difficulty with the challenge task please help :)

Posted March 18, 2020 1:19pm by Brendan Quinn

Brendan Quinn
2,847 Points
1 Answer
pratyush raj
7,097 Points
why he used id=15 instead of book_id=15???

Posted March 18, 2020 7:23am by pratyush raj

pratyush raj
7,097 Points
1 Answer
Richard Sun
11,257 Points
What is wrong with this query?

Posted March 14, 2020 11:19pm by Richard Sun

Richard Sun
11,257 Points
1 Answer
Ellen Longman
144 Points
what's wrong with code?

Posted March 8, 2020 4:31pm by Ellen Longman

Ellen Longman
144 Points
1 Answer
Ellen Longman
144 Points
wrong with code?

Posted March 8, 2020 3:54pm by Ellen Longman

Ellen Longman
144 Points
1 Answer
mihneaburtescu
348 Points
I dont understand

Posted February 28, 2020 5:02am by mihneaburtescu

mihneaburtescu
348 Points
1 Answer
Claire Uzenski
1,026 Points
having trouble with SQL, this is what I have so far, SELECT 'Hessle' FROM away_team WHERE results = 2015-10-01

Posted January 23, 2020 2:36pm by Claire Uzenski

Claire Uzenski
1,026 Points
4 Answers
PLUS

Abu-al Fahad
Courses Plus Student 719 Points
whatis the correct answer

Posted January 23, 2020 10:47am by Abu-al Fahad

Abu-al Fahad
Courses Plus Student 719 Points
0 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
Claire Uzenski
1,026 Points
How do i complete the equation

Posted January 16, 2020 2:24pm by Claire Uzenski

Claire Uzenski
1,026 Points
1 Answer

Prev Page 3 of 10 Next

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