Table: world_matchplay_2008
Columns: player
played
legs_won
legs_lost
lwat
100
140
180s
high_checkout
3_dart_average

Question: What is the number of high checkout with fewer than 13 legs won, a 180s lower than 2 and an LWAT of more than 1?
SQL: SELECT COUNT("high_checkout") FROM world_matchplay_2008 WHERE "legs_won" < 13 AND "180s" < 2 AND "lwat" > 1

Question: What is the total 140+ with a high checkout of 74 and a 100+ higher than 17?
SQL: SELECT SUM("140") FROM world_matchplay_2008 WHERE "high_checkout" = 74 AND "100" > 17

Question: How many played are there with a 3-dart average of more than 90.8, an LWAT higher than 5 and fewer than 17 legs lost?
SQL: SELECT AVG("played") FROM world_matchplay_2008 WHERE "3_dart_average" > 90.8 AND "lwat" > 5 AND "legs_lost" < 17