turbot/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: