title: Case expression in sqlite3
body: <p>I have been told to use case expression like this in one of the books I'm reading:</p>
  
  <pre><code>select name || case type_id
          when 7 then ' is a drink'
          when 8 then ' is a fruit'
          when 9 then ' is junkfood'
          when 13 then ' is seafood'
          else null
      end description
  from foods
  where description is not null
  order by name
  limit 10;
  </code></pre>
  
  <p>However, this gives me an error: </p>
  
  <blockquote>
    <p>Error while executing query: no such column: description</p>
  </blockquote>
  
  <p>What I'm trying to do is avoiding the null values. So where is it going wrong?</p>