Query: starwars_species_classification_distribution

select
  classification,
  count(*) as "Number of Species"
from
  species
where
  classification not in ('N/A', 'NA')
group by
  classification
order by
  count(*) desc;