turbot/powerpipe-mod-starwars

Query: starwars_species_homeworld_details_overview

Usage

powerpipe query starwars.query.starwars_species_homeworld_details_overview

SQL

select
name as 'Homeworld Name',
rotation_period as 'Rotation Period in Hours',
orbital_period as 'Orbital Period in Days',
diameter as 'Diameter in km',
climate as 'Climate',
gravity as 'Gravity',
terrain as 'Terrain',
surface_water as 'Surface Water',
population as 'Population'
from
planets
where
name = (
select
homeworld
from
species
where
name = $1
);

Dashboards

The query is used in the dashboards: