Standings as of , Sorted by Winning Percentage
RANK |
NAME |
NRATE | GMS |
WINS |
TIES |
LOSS |
WPCT |
AVG |
DEF |
SPR |
HGM |
H3SR | WS |
Nothing returned for query:select
concat(p.fname,' ',p.lname),
p.pid,
cur_nrating,
cur_crating,
games,
wins,
ties,
losses,
concat(round(wpct,1),'%'),
round(avg_score,0),
round(oavg_score,0),
round(avg_spread,0),
high_game,
high_3series,
high_4series,
high_loss,
max_wstreak,
concat(round(oavg_wpct,1),'%'),
round(oavg_scoreavg,0),
cur_wrating,
byes,
concat(round(bye_pct,1),'%')
from player p, stand s
where s.venue_code = '651'
and s.stand_code = 'cur2017NN'
and s.games >=
and p.pid = s.pid
order by wpct desc, cur_crating desc, games desc, avg_spread desc
Key: NRATE: NASPA rating, WPCT: Winning percentage, AVG: Scoring average, DEF: Defensive average (avg score against), SPR: Average spread, HGM: High game, H3SR: High 3-game series, WS: Longest win streak