shaddf Posted June 2, 2017 Share Posted June 2, 2017 (edited) i have this table: +---------+-----------+------+----------+------------+------+----+ | playerid| ShortName | logo | SeasonID | SeasonName | Apps | Gl | +---------+-----------+------+----------+------------+------+----+ | 9 | Friendly | NULL | 12 | 2016/17 | 1 | 0 | | 4 | NDIV V | NULL | 12 | 2016/17 | 1 | 0 | | 17 | NDIV V | NULL | 12 | 2016/17 | 1 | 0 | | 10 | Friendly | NULL | 12 | 2016/17 | 1 | 0 | | 5 | NDIV V | NULL | 12 | 2016/17 | 1 | 0 | | 18 | NDIV V | NULL | 12 | 2016/17 | 1 | 0 | | 11 | Friendly | NULL | 12 | 2016/17 | 1 | 0 | | 6 | NDIV V | NULL | 12 | 2016/17 | 1 | 0 | | 12 | Friendly | NULL | 12 | 2016/17 | 1 | 0 | | 7 | NDIV V | NULL | 12 | 2016/17 | 1 | 0 | | 13 | Friendly | NULL | 12 | 2016/17 | 1 | 0 | | 8 | NDIV V | NULL | 12 | 2016/17 | 1 | 0 | | 1 | Friendly | NULL | 12 | 2016/17 | 1 | 3 | | 14 | Friendly | NULL | 12 | 2016/17 | 1 | 0 | | 9 | NDIV V | NULL | 12 | 2016/17 | 1 | 0 | | 2 | Friendly | NULL | 12 | 2016/17 | 1 | 1 | | 15 | Friendly | NULL | 12 | 2016/17 | 1 | 0 | | 10 | NDIV V | NULL | 12 | 2016/17 | 1 | 0 | | 3 | Friendly | NULL | 12 | 2016/17 | 1 | 0 | | 16 | Friendly | NULL | 12 | 2016/17 | 1 | 0 | How can I get the player statistics for a given competition like so,Getting the total Appearances(Apps),total goals(Gl)for each player in a particular competition I also wonder how to identify the player on bench for a particular game: KKL Lge NDIV Cup Friendly Cup Africa Other † Total playerId. Ap Gl Ap Gl Ap Gl Ap Gl Ap Gl Ap Gl 13 0 + 1 0 0 + 0 0 0 + 0 0 0 + 0 0 0 + 0 0 0 + 1 0 2 0 + 2 0 0 + 0 0 0 + 0 0 0 + 0 0 0 + 0 0 0 + 2 0 16 4 + 9 1 1 + 1 1 1 + 0 0 1 + 0 0 0 + 0 0 7 + 10 2 8 36 + 1 2 3 + 0 0 0 + 0 0 8 + 0 0 1 + 0 0 48 + 1 2 17 24 + 0 1 1 + 1 0 2 + 0 0 4 + 0 0 1 + 0 0 32 + 1 1 Edited June 2, 2017 by shaddf Quote Link to comment Share on other sites More sharing options...
dalecosp Posted June 2, 2017 Share Posted June 2, 2017 "given competition" ? I only see "Season ID" ... so you could probably aggregate appearances and goals for a given season, but if by "competition" you mean "particular game/contest" ... I don't see that happening with this data. Quote Link to comment Share on other sites More sharing options...
shaddf Posted June 3, 2017 Author Share Posted June 3, 2017 "given competition" ? I only see "Season ID" ... so you could probably aggregate appearances and goals for a given season, but if by "competition" you mean "particular game/contest" ... I don't see that happening with this data. sorry it has to be by seasonId Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.