search

gesundkrank / mrfoosball

GNU General Public License v3.0
2 stars 1 forks source link

Team skill #78

Closed bratke closed 5 years ago

bratke commented 5 years ago 
postgres=# select trueskillmean,trueskillstandarddeviation,id from player;
  trueskillmean   | trueskillstandarddeviation |    id     
------------------+----------------------------+-----------
 29.1753579557308 |           5.95432253666433 | U12SQMB5W
 17.7505020734372 |           5.95432253666433 | UGZT9UB3L
 26.3018228313482 |           5.95432253666433 | U12JD3LQG
 26.7723171394838 |           5.95432253666433 | U12PAFQ9E
(4 rows)

postgres=# select * from team;
  trueskillmean   | trueskillstandarddeviation | player2_id | player1_id 
------------------+----------------------------+------------+------------
 20.7943586078794 |           7.19471815777177 | UGZT9UB3L  | U12JD3LQG
 29.2056413921206 |           7.19471815777177 | U12SQMB5W  | U12PAFQ9E
 20.7943586078794 |           7.19471815777177 | UGZT9UB3L  | U12PAFQ9E
 29.2056413921206 |           7.19471815777177 | U12SQMB5W  | U12JD3LQG
 23.0050378955886 |           5.31163635492655 | UGZT9UB3L  | U12SQMB5W
 26.9949621044114 |           5.31163635492655 | U12PAFQ9E  | U12JD3LQG
(6 rows)

postgres=# select count(*) from tournament;
 count 
-------
     5
(1 row)
bratke commented 5 years ago

this implements #76