kittenparade kittenparade - 7 months ago 21
SQL Question

List the titles of movies that have a higher score than some movie in the database

I'm completely stuck on this query. My table is:

Movie(MovieID, Title, Year, Score, Votes)


How do I list the titles of movies that have a higher score than some movie in the database.

I know this is wrong but something that would accomplish essentially

SELECT title FROM movie WHERE score > Alien;


Hope I explained myself well enough.

Answer

Use this

Select title from movie where score > (select score from movie where title = 'Alien')
Comments