I am learning SQL from sololearn while doing one of assignments I write query which is not accepted by sololearn

Question

Write a query to output the names of all of the films which were produced by Marvel Studios in 2010 or later, sorted by the 'name' column

And this is my query but sololearn is not accepting it and showing same error that column Marvel studios doesn't exist

SELECT name FROM films

WHERE production = "Marvel Studios" AND year >=

2010 ORDER BY name;

Answer 1

Nitin Bisht ,

you also have to use *single quotes* , not *double quotes*

Answer 2

Nitin Bisht ,

it is requested to output only the *names* of the films, your statement uses '*'.

Answer 3

I changed but still it's showing error column 'Marvel Studios' does not exist Lothar

Answer 4

Yes now it's working, I never thought that by using single qoutes or double qoutes would effect my outcome Lothar