im wondering if is possible data explorer can check which user are heavy download picture from my site ? sorry im MySQL idiot and i try to edit it from 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