noble-quiz

[divo93]

--#14
/*
The expression subject IN ('Chemistry','Physics') can be used as a value - it will be 0 or 1.
Show the 1984 winners ordered by subject and winner name; but list Chemistry and Physics last.
*/
SELECT winner, subject, subject IN ('Physics','Chemistry')
FROM nobel
WHERE yr=1984
ORDER BY subject IN ('Physics','Chemistry'),subject,winner

will be
SELECT winner, subject
FROM nobel
WHERE yr=1984
ORDER BY subject IN ('Physics','Chemistry'),subject,winner

[dubeyji10]

i think this works
'''
select winner,subject from nobel where yr=1984 order by ( case subject
when 'Chemistry' then 0
when 'Physics' then 1
end) , subject , winner

'''