Output always column name.

Question

Select name
From films
Where year >= 2010
And (production= ‘marvel studios’)
Order by name;

Output always comes out with just the column name “name”. What am I doing wrong?

Answer 1

Thanks for the prompt response! what I meant was I want the names in the column that follow that specific guidline, but the output is literally just “name” I want the actually names under the “name” column.

Answer 2

i have the same issue

Answer 3

Select name
From films
Where year >= 2010
And (production = ‘Marvel Studios’)
Order by name;

take note of the Character in 'Marvel Studio' herein lies your bug

Answer 4

Is somebody have code which will work?

Answer 5

This has been broken that long. I’m getting the same thing even though i have the correct answer.

Answer 6

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

Answer 7

You are only selecting the name column in your select clause. To select all columns do this:

SELECT * FROM .....