Advertisement
Guest User

Untitled

a guest
Jan 19th, 2019
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.57 KB | None | 0 0
  1. 5.
  2. SELECT COUNT(G.ID) AS GOALS, P.FIRSNAME, P.LASTNAME
  3. FROM GOAL G
  4. JOIN MATCH M ON M.ID = G.MATCH_ID
  5. JOIN PLAYER P ON P.ID = G.PLAYER_ID
  6. WHERE YEAR(M.DATE) = 2016
  7. GROUP BY G.PLAYER_ID
  8. ORDER BY GOALS DESC
  9. LIMIT 3
  10.  
  11. 6.
  12. WITH ARBITER_MATCHES AS
  13. (
  14. SELECT COUNT(M.ID) AS MATCHES, A.FIRSTNAME, A.LASTNAME
  15. FROM MATCH M
  16. JOIN ARBITER A ON M.ARBITER_ID = A.ID
  17. WHERE YEAR(M.DATE) = 2016
  18. GROUP BY A.ID
  19. ),
  20. MAX_MATCHES AS
  21. (
  22. SELECT MAX(AM.MATCHES) AS MAX_MATCHES
  23. FROM ARBITER_MATCHES AM
  24. )
  25. SELECT AM.*
  26. FROM ARBITER_MATCHES AM
  27. JOIN MAX_MATCHES MM ON MM.MAX_MATCHES = AM.MATCHES
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement