title: Why my answer is not correct about select_from_nobel_tutorial #14
body: <p><strong>[UPDATE]</strong> Finally figure out, I forget to put subject as ORDER BY Column</p>
  
  <hr>
  
  <p>All:</p>
  
  <p>I am pretty new to SQL, I wonder how to solve the last question in SQLZOO select from nobel tutorial last question:</p>
  
  <p><a href="http://sqlzoo.net/wiki/SELECT_from_Nobel_Tutorial" rel="nofollow">http://sqlzoo.net/wiki/SELECT_from_Nobel_Tutorial</a></p>
  
  <pre><code>14.
  The expression subject IN ('Chemistry','Physics') can be used as a value - it will be 0 or 1.
  Show the 1984 winners and subject ordered by subject and winner name; but list Chemistry and Physics last.
  </code></pre>
  
  <p>I thought is should be(in <strong>MYSQL</strong> version):</p>
  
  <pre><code>SELECT winner, subject
    FROM nobel
   WHERE yr=1984
   ORDER BY subject IN ('Physics','Chemistry'),winner
  </code></pre>
  
  <p>But it gives me Error: <code>"Wrong answer. Some of the data is incorrect."</code></p>