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

Henri Hyacinthe TAMO FODJO
Henri Hyacinthe TAMO FODJO
1,653 Points
Posted by Henri Hyacinthe TAMO FODJO
Henri Hyacinthe TAMO FODJO
1,653 Points

please help me

We still using the sports team's database. In the results table we have the columns id, home_team, home_score, away_team, away_score, played_on.

Find all results where the away team's score is lower than 10.

1 Answer

Thomas Guest
Thomas Guest
3,001 Points
Thomas Guest
Thomas Guest
3,001 Points

Hi Henri. I'm not sure if I understood you correctly, but if you are looking for an SQL that will find all results where the away team's score is less than 10, I believe this should work:

SELECT* from results WHERE away_score <10;

"SELECT* " is another way of saying "SELECT ALL", then you point to the table you want to get the information from, simply by saying "from <table name>". After that you specify your criteria, which is that you only want to see all the results "where away_score is less than 10".

I hope this helps you out :) Good luck!