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 SQL Basics Finding the Data You Want Finding the Data You Want Review

Miguel Nunez
Miguel Nunez
3,266 Points
Posted by Miguel Nunez
Miguel Nunez
3,266 Points

Fill in the missing operator. Today is 19th October 2019. I want to find all matches happening today and in the future.

SELECT * FROM football_matches WHERE event_date "2019-10-19";

2 Answers

Morgan Strnad
Morgan Strnad
14,292 Points
Morgan Strnad
Morgan Strnad
14,292 Points

I keep getting the wrong answer on this one even though I'm pretty positive I have it right. Is the answer "=>"? If it's not can someone direct/tell me what the answer is??

Steven Parker
Steven Parker
231,236 Points
Steven Parker
Steven Parker
231,236 Points

:point_right: The WHERE clause should have an evaluation expression.

Take a look at it now — it has a column name, and literal value in quotes, but nothing in between to indicate how they are being compared.

You need to supply the symbol(s) to perform the comparison needed for the job described.