sievrebo

Exam 13 February 2021 Task 10

Oct 11th, 2021
2,724
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.22 KB | None | 0 0
  1. SELECT
  2.     u.UserName,
  3.     AVG(f.SIZE) AS SIZE
  4. FROM  Users AS u
  5. INNER JOIN Commits AS c ON u.Id = c.ContributorId
  6. INNER JOIN Files AS f ON c.Id = f.CommitId
  7. GROUP BY u.UserName
  8. ORDER BY SIZE DESC,
  9.          u.UserName
Advertisement
Add Comment
Please, Sign In to add comment