Syntax error in 10.2 Practice - Superheros

Question

Hi While trying to solve the above mentioned practice problem, I am facing below syntax error. Request you to kindly correct me. My code lines are also mentioned below along with Error.

ERROR: syntax error at or near "Studios"
LINE 2: where "production" = Marvel Studios AND "year" >= 2010

My code -
select "name" from films
where "production" = Marvel Studios AND "year" >= 2010
Order by "Name";

Answer 1

Remove all quotation marks. Instead put 'Marvel Studios' into single quotation marks.

Answer 2

Srikanth VS

You can't write columns name inside quotation marks.

Otherwise that's would be call String.

And also you have to write string values inside single quotes like: 'Marvel Studios'

Answer 3

select name from films where production = 'Marvel Studios' AND year >= 2010 Order by name;