turbot/starwars

Query: starwars_top_10_largest_planets

Usage

powerpipe query starwars.query.starwars_top_10_largest_planets

SQL

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

Dashboards

The query is used in the dashboards: