Estou me perguntando se é possível que o Explorador de Dados verifique quais usuários baixaram muitas imagens do meu site. Desculpe, sou um iniciante em MySQL e estou tentando editar isso a partir dos uploads.
WITH heavy_uploads AS ( SELECT
( SUM(downloads.filesize) / 1024) AS sum_kb
, COUNT(downloads.filesize) AS upload_count
, ( (SUM(downloads.filesize) / COUNT(downloads.filesize)) / 1024) AS avg_weight_kb
, downloads.user_id
FROM downloads
GROUP BY downloads.user_id
)
SELECT heavy_downloads.sum_kb
, heavy_downloads.downloads_count
, heavy_downloads.avg_weight_kb
, heavy_downloads.user_id
FROM heavy_downloads
WHERE heavy_downloads.sum_kb > 100
ORDER BY heavy_downloads.sum_kb DESC