GAME OF THRONES

Projeto final do módulo 3 da formação em Desenvolvimento Web Full Stack da Resilia Educação.

Link para a página aqui

Tecnologias utilizadas:

• MYSQL.

• HTML5.

• CSS3.

• Bootstrap5.

• JavaScript.

• Jquery.

• Google Charts.

  

  Mortes por casa

     SELECT
    allegiance as Casa, COUNT(*) as mortes
FROM
    deaths
WHERE
    allegiance LIKE %house%
GROUP BY allegiance
ORDER BY COUNT (*) DESC;

Quantas mortes por temporada

   SELECT
    season as Temporada, COUNT (*) as Mortes
FROM
    deaths
GROUP BY season
ORDER BY season;

Mortes por armas e métodos

   SELECT
    Method AS Método, COUNT (*) AS Vezes
FROM
    deaths
GROUP BY method
ORDER BY COUNT (*) DESC
LIMIT 10;

Qual familia matou mais

   SELECT
    killers_house as Casa, COUNT(*) as Assassinatos
FROM
    deaths
WHERE
    killers_house <> 'none'
GROUP BY killers_house
ORDER BY count(*) desc
limit 10;  

Qual familia matou mais entre si/mais se matou

   SELECT
    killers_house as Casa, COUNT(*) as Assassinatos
FROM
    deaths
WHERE
    killers_house <> 'none'
GROUP BY killers_house
ORDER BY count(*) desc
limit 10;

Mortes Por Região

SELECT
    location, COUNT(*) AS mortes
FROM
    deaths
GROUP BY location
ORDER BY COUNT(*) DESC;

Os personagens que mais mataram por casa

   SELECT
    killer as Personagem, assassinatos
FROM
    (SELECT
         COUNT (*) AS assassinatos, killer, killers_house
    FROM
        deaths
    GROUP BY killer
    ORDER BY COUNT(*) DESC) melhores_de_sua_casa
WHERE
    killer NOT LIKE %soldier%
        AND killer NOT LIKE '%brother%'
        AND killer NOT LIKE '%agent%'
        AND killer NOT LIKE '%man%"
        AND killer NOT LIKE '%none%
GROUP BY killers_house

As temporadas mais populares de got

   SELECT
Season as Temporada, FORMAT( sum(rating), 'N', en-us') as Score, SUM(votes) as Votos
FROM
episodes
GROUP BY season;

Quantidades de casa por região

   SELECT
    region as Região, COUNT(*) as Casas
FROM
    houses
GROUP BY region
ORDER BY COUNT (*) DESC
limit 10;

Rank de personagens que mais participaram de episodios

   SELECT
    `character` as Personagens, episodes_appeared as Episódios
FROM
    `characters`
ORDER BY Episodes_appeared DESC
limit 10;

Equipe:

• Edu Moreira
• Fernanda Pereira
• Kaio Novais
• Luciana Vivarelli
• Patricia Milane
• Raphael Vicentini