# // Semana de Desafio Módulo 1

###### tags: `backend` `fullstackprogram`
_______

## // Grupo 1

**Questão 1**:

select house,
COUNT (*) as count 
from harry_potter
where blood_status ='Muggle-born' or blood_status = 'Half-blood'
group by house
order by COUNT desc
limit 4;

**Questão 2**:

select house, 
COUNT (*) as count
from harry_potter 
where blood_status = 'Pure-blood'
and house is not null
group by house
order by COUNT (*) asc
limit 1;

**Questão 3**:

select COUNT (name)
from harry_potter
where name like '%Weasley%'
order by COUNT;

**Questão 4**:

select COUNT (name)
from harry_potter
where name like '%Weasley%'
and name <> 'Red'
order by COUNT;

**Questão 5**:

select Patronus, count(*)
from harry_potter
where Patronus not in ('Unknown', 'Non-corporeal', 'None')
group by Patronus
order by COUNT desc 
limit 3;

**Questão 6**:

**Questão 7**:

select name
from harry_potter 
where loyalty like '%Lord Voldemort%'
and house <> 'Slytherin';

## // Grupo 2

**Questão 1**:

**Questão 2**:

**Questão 3**:

**Questão 4**:

select * from harry_potter;

select name
from harry_potter 
where
name not in(
select "name" 
from harry_potter
where loyalty like '%Lord Voldermort%'
and house <> 'Slytherin')
and birth like '%September%'
and death is null
and loyalty is null 
and (patronus <> 'Non-corporeal')

## // Grupo 3

**Questão 1A**:

**Questão 1B**:

**Questão 1C**:

**Questão 1D**:

**Questão 1E**:

**Questão 1F**:

**Questão 1G**:

**Questão 2.A**:

**Questão 2.B**:

**Questão 2.C**:

**Questão 2.D**:

**Questão 3**:

**Questão 4.A**:

**Questão 4.B**:

**Questão 4.C**:

**Questão 4.D**: