SPARBONDE OVERBLIK
:select b.id, b.year, a.season_meta_id, sum(a.ffj_points) ffj, sum(a.lmd_points) lmd, sum(a.rtp_points) rtp, sum(a.sac_points) sac from game_result a right join season_meta b on a.season_meta_id = b.id group by b.id, b.year order by b.id, b.year :
Sæson FFJ LMD RTP SAC
Placering SpilPoint Point Placering SpilPoint Point Placering SpilPoint Point Placering SpilPoint Point
2004 1 219 3 213 2 216 4 200
2005 4 160 3 161 2 172 1 207
2006 2 131 1 138 3 99 4 97
2007 2 467 3 412 4 401 1 474
2008 2 438 1 480 3 432 4 403
2009 3 377 2 391 4 351 1 419
2010
2011
2012 3 402 2 444 4 349 2 444
2013 3 422 2 458 4 365 1 510
2014 3 479 2 550 4 430 1 551
2015 3 454 2 482 4 397 1 558
2016 3 510 2 571 4 492 1 632
2017 3 502 1 652 4 495 2 621
2018 4 463 1 605 3 569 2 573
2019 1 562 4 516 3 518 2 534
2020 4 420 1 587 3 491 2 585