---
# System prepended metadata

title: Exercícios Resolvidos para Casa - Aula 9

---

![](https://i.imgur.com/xG74tOh.png)

# Exercícios Resolvidos para Casa - Aula 9

Questão 1

```sql
select distinct category from nobel;
```


Questão 2

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

Questão 3

```sql
select birth_country from nobel group by birth_country order by birth_country;
```

Questão 4

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

Questão 5

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

Questão 6

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

Questão 7

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

Questão 8

```sql
    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;
```