turbot/starwars

Query: starwars_fastest_vehicles

Usage

powerpipe query starwars.query.starwars_fastest_vehicles

SQL

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

Dashboards

The query is used in the dashboards: