turbot/starwars

Query: starwars_species_characters_overview

Usage

powerpipe query starwars.query.starwars_species_characters_overview

SQL

select
name as 'Character Name',
height as 'Height in cm',
mass as 'Mass in kg',
hair_color as 'Hair Colors',
eye_color as 'Eye Colors',
birth_year as 'Birth Year',
skin_color as 'Skin Colors',
gender as 'Gender',
homeworld as 'Homeworld'
from
characters
where
species = $1;

Dashboards

The query is used in the dashboards: