graphs/sql/file_archaeology/req05.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14

SELECT
    owner,
    COUNT(filename) AS num_files
FROM dtf.madelines_files
GROUP BY owner
HAVING
    COUNT(filename)
    = (
        SELECT MIN(test)
        FROM
            (SELECT COUNT(filename) AS test FROM dtf.madelines_files GROUP BY owner
            ) AS n
    )
ORDER BY owner