SELECT a.codigo, a.nome, AVG( c.volume )
FROM ativo a, cotacao c
WHERE a.idativo = c.idativo
GROUP BY a.idativo
ORDER BY AVG( c.volume ) DESC
LIMIT 0 , 30