starwars_average_height_of_speciesstarwars_average_species_heightstarwars_fastest_vehiclesstarwars_planet_climate_distributionstarwars_planet_population_distributionstarwars_species_average_lifespanstarwars_species_characters_overviewstarwars_species_classificationstarwars_species_classification_distributionstarwars_species_homeworld_details_overviewstarwars_species_inputstarwars_species_lifespan_distributionstarwars_species_most_common_skin_colorstarwars_species_overviewstarwars_starship_cost_distributionstarwars_starship_manufacturer_distributionstarwars_starship_passenger_distributionstarwars_top_10_largest_planetsstarwars_total_charactersstarwars_total_planetsstarwars_total_speciesstarwars_total_starshipsstarwars_vehicle_cargo_capacity_comparison
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 planetswhere name = (select homeworld from species where name = $1);
Dashboards
The query is used in the dashboards: