Guest User

Untitled

a guest
Feb 23rd, 2018
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. SELECT IDUsuario ,COUNT('TotalDeUps') as Total, FROM uploads
  2. WHERE Time >= '2018-02-20 00:00:00'
  3. AND Time < '2018-03-21 00:00:00'
  4. GROUP BY IDUsuario
  5. ORDER BY COUNT("UserID") DESC
  6.  
  7. SELECT IDUsuario ,COUNT('TotalDeUps') as Total,SUM(Size) as TotalDeUp FROM uploads
  8. WHERE Time >= '2018-02-20 00:00:00'
  9. AND Time < '2018-03-21 00:00:00'
  10. GROUP BY IDUsuario
  11. ORDER BY COUNT("UserID") DESC
Add Comment
Please, Sign In to add comment