Advertisement
Guest User

Untitled

a guest
Feb 9th, 2018
338
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.30 KB | None | 0 0
  1. SELECT
  2.     [t2].[Username],
  3.     CAST(SUM([t1].[Uploaded]) AS decimal)/CAST(SUM([t1].[Downloaded]) AS decimal) AS Ratio
  4. FROM UserTorrentTracking t1
  5. JOIN "User" t2 ON [t2].[Id] = [t1].[UserId]
  6. GROUP BY t2.Username
  7. ORDER BY Ratio DESC
  8. OFFSET 0 ROWS -- needed for sql server 2014
  9. FETCH FIRST 10 ROWS ONLY
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement