DIV 1 BILLIARDS stats by handicap (lowest first)

Excludes players who have not played billiards this season
Using database: 2200425_icb17
divnteamidhcapnamescoredavgframesframes wondrawnwin pc%
1GLD4-150Joe Minici3185290117064%
1MAR222-100Grant Meadley173821784050%
1MAR134-100Vic Sacco2582258108080%
1MAR136-100Vic Cravino225025094044%
1MAR137-100Roger Farebrother31402421311085%
1HBY42-100George Chammas2651265106060%
1GLD74-100Ron Tulloch2951268115045%
1HBY178-50Peter Tankard111716073043%
1HBY453-50Dirk Hellenbroich93118651020%
1BLK340-50Ron Vidler206517212108%
1HBY324-50Adwin Teh168121084050%
1MAR2290-50Graham Watts183120394044%
1MAR2287-50Maher (Muz) El Omari2079208107070%
1BLK276-50Peter Bourke147818582025%
1HBY177-50Andy De Haan2158196117064%
1GLD163-50Ricky Lo213323798089%
1GLD161-50Jim Hull151821773043%
1GLD17-50Fred Attard111822452040%
1BLK6-50Dave Vassallo212017712108%
1MAR22190Danny Senko6601106000%
1BLK2510George Neradilek1829183108080%
1MAR22880Shannon Fearnhead3881293000%
1MAR1390Sam Delia1973164126050%
1BLK3370Percy Crow1441441000%
1HBY3580David McMahon127018174057%
1BLK3590Ian Taylor79215851020%
1MAR23790Fred Minici2146195118073%

Records retrieved: 27

SELECT t1.`divn` , t2.`team_code` AS team , t1.`player_id` AS id, t1.`hcap_blds` AS hcap, CONCAT(t1.`player_first` ,' ',t1.`player_surn`) AS name, t1.`nett_blds` AS scored, CAST( (t1.`nett_blds`/t1.`mts_blds`) AS UNSIGNED) AS avg, t1.`mts_blds` AS frames , t1.`mts_won_blds` AS 'frames won' , t1.`mts_draw_blds` AS drawn, CONCAT(FORMAT((t1.`mts_won_blds`/(t1.`mts_blds`))*100,0),'%') AS 'win pc%' FROM `players` AS t1, `teams` AS t2 WHERE t1.`divn` =1 AND t2.`team_id` = t1.`team_id` AND t1.`mts_blds` > 0 ORDER BY hcap ASC;