graphs/sql/file_archaeology/req03.sql


1
2
3
4
5
6
7

SELECT
    filename,
    size
FROM dtf.madelines_files
WHERE
    size >= (SELECT 0.75 * AVG(size) FROM dtf.madelines_files)
ORDER BY size DESC,filename