knoteva

Untitled

Oct 13th, 2019
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.19 KB | None | 0 0
  1. SELECT u.Username, AVG(f.Size)
  2. FROM Users AS u
  3. JOIN Commits AS c ON u.Id = c.ContributorId
  4. JOIN Files AS f ON c.Id = f.CommitId
  5. GROUP BY u.Username
  6. ORDER BY AVG(f.Size) DESC, u.Username
Add Comment
Please, Sign In to add comment