I am getting all `NULL` values in the column. I have some data in table `species_data` like

```
| ID |     science_name_short    |database_value   |
|  1 | Rhododendron phipli       |3                |
|  2 | Rhododendron felica       |5                |
|3   | Rhododendron deron        |5                | 
|4   | Rhododendron  sednuns     |5                |

```

I have tried to bring the output as

```
| ID |       NAME                |Number|
|  1 | Rhododendron Species      |18    |

```

The SQL I tried is

```
Select sum(database_value)
 CASE when science_name_short='rhodo'
 THEN 'Rhododendron species'
END AS real_name
from species_data;

```