10.2 Practice - Logical Operators (Superheroes)

Question

You are given the following films table with details about superhero movies:

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.

My code:

SELECT name
FROM films
WHERE year >= '2010'
AND production = 'Marvel Studios';

But it says no input. Please help.

Answer 1

Chin Eu

Year is numeric value not string so remove single quotes and also result should be in Ascending ORDER of Name.

SELECT name FROM films WHERE production = 'Marvel Studios' and year >= 2010 ORDER BY name

Answer 2

select name,year from films where production IN('Marvel Studios') and year >= 2010 order by year

Answer 3

OMG thank you so much!!!! I thought I will cry :))) been struggling with this, just because I wrote marvel studios and not Marvel Studios

Answer 4

select name from films
where production = 'Marvel Studios'
and year >= 2010
order by films.name;

be careful when marvel studios M should be upper case and S should be in Upper case ..
thankyou

Answer 5

SELECT name, year FROM films
WHERE production IN ('Marvel Studios')
AND films.year >= 2010

Answer 6

Thanks Ajanant !

Answer 7

Thank you so much. I struggled for two hours and couldn't find it, time was not wasted thanks to you.

Answer 8

This is Correct answer for this

SELECT name
FROM films
WHERE production = 'Marvel Studios' and year >= 2010 ORDER BY name

Answer 9

I keep getting the same error with this code

SELECT name
FROM films
WHERE production = 'Marvel studios' AND year >= 2010 ORDER BY name

Answer 10

SELECT name FROM films WHERE production = 'Marvel Studios' and year >= 2010 ORDER BY name

Answer 11

great thanks

Answer 12

My solution:

SELECT name FROM films WHERE production = 'Marvel Studios' and year >= 2010 ORDER BY name

Answer 13

i keep getting the no input error as well. my code is literally the same as the one in the solution. Is this a coding error from Sololearn?

Answer 14

SELECT name, year FROM films
WHERE production = 'Marvel Studios' AND year >= 2010
ORDER BY name DESC

Answer 15

my code was successful when I used desc instead of asc.
select name , year from films
where production = 'Marvel Studios'
and year >= 2010
order by name desc;

Answer 16

I think this can work:
SELECT name , year
FROM films
WHERE year >= 2010 and production = 'Marvel Studios'
Order by name desc

Answer 17

SELECT name FROM films
WHERE production='Marvel Studios' and year>=2010 ORDER BY name;

Answer 18

why this code that I've written doesn't work?
here is the code:

select name
from films
where production='marvel studios'
and year>=2010
order by name