DIV 2 Snooker stats by average points scored per frame (highest first)

divnidteamhcapnamenett scorednett_avgframesframes wonwin pc%
2315DLY0Chris Dam139702150%
2185DLY0Franco Di Matteo1376922100%
2340GLD10Ron Vidler1266322100%
2389BLK0Steven Fabian364616583%
2390DLY-20Muhammad Hassan8135814750%
2380GLD5Steve Whitehead66856121192%
2386CHL-5Nima Alizadeh8805516850%
2341GLD5Dennis Sharpe120655221464%
26BLK-15Dave Vassallo322546467%
2406CHL0Sean Gong431548563%
2269DLY-20Clarence Ho107542150%
2198MAR0Phillip Walda117754221777%
2235BLK20Gordon Alexander1065322100%
2262MAR5Sam Youakim91551181161%
2366MAR5George Isaacs8925018950%
2402BLK0Bob Marsh79149161063%
2338BLK5Isaac Epere78249161063%
2349GLD5Yahya Hakimi76448161063%
2350DLY-10Roy Rahmani191484125%
2387CHL15Stefano Fazio104347221359%
2302BLK10Garry Arlidge91462150%
2339BLK-10Alan Crouch367468338%
2189DLY0Farhan Khan7394616531%
2360MAR-10Brian Mills6474614750%
2413RHL215Vinnel Chandra346438338%
259BLK-10Eddie Chew4284310330%
2221RHL120Phil Tilbury7484218950%
2385CHL10Jason Hastings80402150%
2369DLY15Usman Sheikhi302388338%
2124RHL115Roger McLenaghan5193714750%
2381RHL215Darren James87637241146%
2384CHL20Louis Minihan5153714643%
2383RHL115Richard Robinson7833622836%
2298GLD15Danny Ngeru289368225%
2388CHL25Mohammed Shahmaleki3613610440%
2207RHL120Lee Castledine6093418950%
2199GLD25Monica Brettle3913312542%
294RHL215Raymond Farage127324125%
287RHL225John Carbines245318113%
2210RHL210John Burns115294125%
2391DLY10Osama Raja5729200%
297RHL230Paul Hibbard2762810110%
2352RHL230Kenny Langworthy2632212217%

Records retrieved: 43

SELECT t1.divn, t1.`player_id` AS id, t2.team_code AS team , t1.hcap_snkr AS hcap, CONCAT(t1.player_first ,' ',t1.player_surn) AS name, t1.`nett_snkr` AS 'nett scored', FORMAT( (t1.`nett_snkr`/t1.`mts_snkr`)/2,0) AS nett_avg, (t1.mts_snkr*2) AS frames , t1.mts_won_snkr AS 'frames won' , CONCAT(FORMAT((t1.mts_won_snkr/(t1.mts_snkr*2))*100,0),'%') AS 'win pc%' FROM players AS t1, teams AS t2 WHERE t1.divn =2 AND (t1.avg_sc_snkr/2)>0 AND t2.team_id = t1.team_id AND t1.`mts_snkr` > 0 ORDER BY nett_avg DESC;