# Exercícios Resolvidos para Casa - Aula 9

Questão 1

select distinct category from nobel;

Questão 2

select min(year), max(year) from nobel;

Questão 3

select birth_country from nobel group by birth_country order by birth_country;

Questão 4

select category, count(*) from nobel group by category order by count(*) desc;

Questão 5

    select category, count(*) from nobel where sex = 'Female' group by category order by count(*) desc ;

Questão 6

    select category, count(*) from nobel where sex = 'Male' group by category order by count(*) desc ;

Questão 7

    select category, count(*) from nobel where birth_city = death_city;

Questão 8

    select full_name, honras from
    (
        select full_name, count(*) as honras from nobel
        where laureate_type = 'Individual'
        group by full_name order by honras desc
    ) as laureados
    where honras > 1;