Question 14 nobel

[therealjjz]

Keep getting
Error:
Incorrect syntax near the keyword 'IN'.

not sure why

[LeslieWongCV]

Keep getting Error: Incorrect syntax near the keyword 'IN'.

not sure why

In the top right of the page there is a settings icon in that change SQL engine to MYSQL it will work. These solutions won't work with Microsoft SQL engine.

[krishnachaudhary596]

Hey there I would like to solve this question. Could you tell me how can I get started as I'm new in contribution.

[Dadanon]

I solved this issue like this for PostgreSQL

SELECT winner, subject FROM nobel WHERE yr = 1984 ORDER BY CASE subject WHEN 'chemistry' THEN 1 WHEN 'physics' THEN 1 ELSE 0 END, subject, winner