Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Databases

adi veliman
adi veliman
5,343 Points
Posted by adi veliman
adi veliman
5,343 Points

My statement doesn't work! What should i do?

My statement doesn't work! What should i do?

6 Answers

jacobproffer
jacobproffer
24,604 Points
jacobproffer
jacobproffer
24,604 Points

Hey Adi,

Can you post your statement and what you're attempting to achieve?

adi veliman
adi veliman
5,343 Points
adi veliman
adi veliman
5,343 Points

Hello! This is the task: We have a database that runs a sports team's website. In the results table we have the columns id, home_team, home_score, away_team, away_score, played_on. Find all results where the home team's score is above 12.

And here is what I wrote: SELECT * FROM results WHERE home_score > 12;

jacobproffer
jacobproffer
24,604 Points

Hey Adi,

I'm not seeing anything wrong with your SELECT statement.

Can you post a link to the challenge for me, please?

jacobproffer
jacobproffer
24,604 Points

Thanks, Adi.

I just pasted your code for task 1 of 3 and the challenge passed for me. Can you try to copy and paste the SELECT statement from this thread into the challenge prompt?

adi veliman
adi veliman
5,343 Points
adi veliman
adi veliman
5,343 Points

Now it worked. I dont't know what was the problem. Thanks for your help!

jacobproffer
jacobproffer
24,604 Points

No problem. I'm wondering if there was an invalid character or if the input was corrupted somehow. Did you copy the statement from somewhere else before? I've had that happen to me in the past.

adi veliman
adi veliman
5,343 Points
adi veliman
adi veliman
5,343 Points

No I don't. I wrote by myself like I did in the comments below too.Maybe it was a problem with my internet connection? or anything localy related.

jacobproffer
jacobproffer
24,604 Points

Not sure. Glad you got it working though!