Please how can I solved this codes

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 they want to use by AND clause

Answer 1

Jamilu Abubakar Sadiq

Write your question and attempts together.

https://www.sololearn.com/Discuss/2879338/?ref=app

Answer 2

Please my friend who can help me?

Answer 3

Please look how I solved it
SELECT Name
FROM Films
WHERE Year >= 2010 AND Year <= 2020
ORDER BY Name;

Answer 4

Jamilu Abubakar Sadiq

Where is your attempts?

Learn how to write SELECT query based on condition

Answer 5

Jamilu Abubakar Sadiq

You missed the condition for "Marvel Studios" films only

Answer 6

Jamilu Abubakar Sadiq

Here is your right query:

SELECT Name
FROM Films
WHERE production = 'Marvel Studios' AND Year >= 2010 ORDER BY Name;

Answer 7

Let me try again