Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- u.UserName,
- AVG(f.SIZE) AS SIZE
- FROM Users AS u
- INNER JOIN Commits AS c ON u.Id = c.ContributorId
- INNER JOIN Files AS f ON c.Id = f.CommitId
- GROUP BY u.UserName
- ORDER BY SIZE DESC,
- u.UserName
Advertisement
Add Comment
Please, Sign In to add comment