Databases SQL Basics Finding the Data You Want Filtering by Dates

Cosmin Iuga
Cosmin Iuga
2,352 Points

I'm stuck here.

Here's my try:

SELECT * FROM results WHERE away_team = "Hessle" AND played_on >= "2015-10-01”;

I'm messing up somewhere.

3 Answers

Cosmin Iuga
Cosmin Iuga
2,352 Points

SELECT * FROM results WHERE away_team = "Hessle" AND played_on >= "2015-10-01”;

KRIS NIKOLAISEN
KRIS NIKOLAISEN
54,172 Points

Your final quotes appear to be curly quotes. Replace those with straight quotes and you'll pass.

See the difference?

"2015-10-01”

Cosmin Iuga
Cosmin Iuga
2,352 Points

These are the straight quotes. SELECT * FROM results WHERE away_team = "Hessle" AND played_on >= "2015-10-01”;

Cosmin Iuga
Cosmin Iuga
2,352 Points

Thank you Kris. These are the straight "