The correct answer is Movie
I had to add a Genre to the last record set and correct the syntax for the movie title [It's a Wonderful Life] to get this to run.
Only order by Movie will give you Ebenezer Scrooge
if you order by Locale the answer is Frosty,
if you order by Age the answer is George Bailey,
if you order by Genre the answer is Frosty,
if you order by SomeName the answer is Dumbledore.
SELECT TOP 1
answer = SomeName
( VALUES ('Ebenezer Scrooge', 'A Christmas Carol', 'Old', 'Fiction', 'London'),
('Dumbledore', 'Harry Potter and the Sorcerer''s Stone', 'Very Old', 'Fantasy', 'Hogwarts'),
('Frosty', 'Frosty The Snowman', 'Infant', 'Animated', 'A small town'),
('George Bailey','It''s a Wonderful Life', 'Adult', 'Drama', 'Falls')
) AS a (SomeName, Movie, Age, Genre, Locale)
ORDER BY Movie