AVG(a.preco_total / DATEDIFF(a.data_fim, a.data_inicio)) AS media_preco_aluguel, MAX(a.preco_total / DATEDIFF(a.data_fim, a.data_inicio)) AS max_preco_dia, MIN(a ...