select name as "Nome do Set ",
year as "Ano Lançamento"from sets
order by num_parts desc limit 10;

select part_categories.name as "Categorias", sum(quantity) as "Total"
from parts inner join inventory_parts using(part_num)
inner join part_categories on parts.part_cat_id = part_categories.id
group by part_cat_id having sum(quantity) < 11 order by total desc;

select name, year
from sets
order by year asc limit 10;

select name, num_parts as quantidade, year
from sets
where name like '%Star War%'
order by quantidade > 100 desc limit 10;

select name, num_parts
from sets where name like '%Harry Potter%'
order by num_parts
desc limit 5;

SELECT sets.name,sets.year , sets.num_parts
FROM sets INNER JOIN themes
ON sets.theme_id = themes.id
WHERE themes.name LIKE %batman% AND sets.num_parts > 500
ORDER BY num_parts DESC LIMIT 5;

select name, case when
name like '%DC%' Then'Herois DC '
when
name like '%Marvel%' then 'Herois Marvel'
END AS Herois_LEGO
FROM sets order by Herois_LEGO desc limit 137;

select distinct themes.name as "Temas", count(sets.theme_id) as "Total",
year as "Ano"from themes
inner join sets on themes.id = sets.theme_id
where year between "1980" and "1989"
group by theme_id having count(sets.theme_id)> 08
order by total desc limit 5;

select name as "Nome", num_parts as "Qtd Peças", case
when num_parts >= 4000 then 'Sim'
when num_parts < 4000 then 'Não'
end as 'True Set' from sets group by set_num
order by num_parts desc limit 20;