title: CASE is not working and showing the NULL values when runned the query
body: <p>I am getting all <code>NULL</code> values in the column. I have some data in table <code>species_data</code> like</p>
  
  <pre><code>| ID |     science_name_short    |database_value   |
  |  1 | Rhododendron phipli       |3                |
  |  2 | Rhododendron felica       |5                |
  |3   | Rhododendron deron        |5                | 
  |4   | Rhododendron  sednuns     |5                |
  </code></pre>
  
  <p>I have tried to bring the output as</p>
  
  <pre><code>| ID |       NAME                |Number|
  |  1 | Rhododendron Species      |18    |
  </code></pre>
  
  <p>The SQL I tried is</p>
  
  <pre><code>Select sum(database_value)
   CASE when science_name_short='rhodo'
   THEN 'Rhododendron species'
  END AS real_name
  from species_data;
  </code></pre>