Query: starwars_species_average_lifespan

select
  'Average Lifespan in years' as label,
  avg(case
      when average_lifespan not in ('NA', 'indefinite') then cast(average_lifespan as float)
      else null
  end) as value
from
  species
where
  name = $1;