turbot/starwars

Query: starwars_species_lifespan_distribution

Usage

powerpipe query starwars.query.starwars_species_lifespan_distribution

SQL

select
name,
cast(average_lifespan as integer) as average_lifespan
from
species
where
average_lifespan not in ('N/A', 'NA', 'indefinite')
order by
average_lifespan desc
limit 10;

Dashboards

The query is used in the dashboards: