SELECT
    e.UsuarioID,
    u.Nome,
    COUNT(e.UsuarioID) AS Total_Emprestimos
FROM
    Emprestimos e
INNER JOIN
    Usuarios u ON e.UsuarioID = u.UsuarioID
GROUP BY
    e.UsuarioID,
    u.Nome
ORDER BY
    Total_Emprestimos DESC
LIMIT 5;


CREATE OR REPLACE VIEW Usuarios_Mais_Ativos AS
SELECT
    e.UsuarioID,
    u.Nome,
    COUNT(e.UsuarioID) AS Total_Emprestimos
FROM
    Emprestimos e
INNER JOIN
    Usuarios u ON e.UsuarioID = u.UsuarioID
GROUP BY
    e.UsuarioID,
    u.Nome
ORDER BY
    Total_Emprestimos DESC
LIMIT 5;

SELECT * FROM Usuarios_Mais_Ativos;