/*SELECT tb_imovel.valor, tb_tipo.descricao
    FROM tb_imovel
    INNER JOIN tb_tipo
    ON tb_imovel.tipo=tb_tipo.id_imovel*/

    /* 4 */
    SELECT tb_tipo.descricao, COUNT(*) AS quantidade,
    SUM(tb_imovel.valor) AS soma,
    AVG(tb_imovel.valor) AS media
    FROM tb_imovel
    INNER JOIN tb_tipo
    ON tb_imovel.tipo=tb_tipo.id_imovel
    GROUP BY tb_tipo.descricao;

    /* 5 */
    SELECT MAX(tb_imovel.valor) AS maior, MIN(tb_imovel.valor) AS menor FROM tb_imovel;

    /* 6 */
    SELECT * FROM tb_imovel WHERE tb_imovel.valor >= 78000 AND tb_imovel.valor <= 119500;

    /* 7 */
    SELECT tb_imovel.valor, tb_tipo.descricao, tb_localizacao.endereco
    FROM tb_imovel
    INNER JOIN tb_tipo
    ON tb_imovel.tipo=tb_tipo.id_imovel
    INNER JOIN tb_localizacao
    ON tb_imovel.localizacao=tb_localizacao.id_imovel
    WHERE tb_tipo.descricao LIKE 'Sobrados' OR tb_tipo.descricao LIKE 'Apartamentos';

    /* 8 */

    SELECT tb_imovel.valor, tb_tipo.descricao, tb_localizacao.endereco
    FROM tb_imovel
    INNER JOIN tb_tipo
    ON tb_imovel.tipo=tb_tipo.id_imovel
    INNER JOIN tb_localizacao
    ON tb_imovel.localizacao=tb_localizacao.id_imovel
    WHERE tb_localizacao.endereco LIKE '%Rua Bela Cintra%';