Table: phil_taylor
Columns: name
lwat
100
140
180s

Question: What's the least 180's of John Part having a LWAT less than 28 with 100+ less than 180?
SQL: SELECT MIN("180s") FROM phil_taylor WHERE "lwat" < 28 AND "name" = 'john part' AND "100" < 180

Question: What's the LWAT having more than 43 for 180s, 194 for 100+, and more than 128 for 140+?
SQL: SELECT AVG("lwat") FROM phil_taylor WHERE "180s" > 43 AND "100" = 194 AND "140" > 128

Question: What's the total 140+ when the 100+ is 173?
SQL: SELECT COUNT("140") FROM phil_taylor WHERE "100" = 173

Question: What's the 100+ when the 140+ is less than 128 and the LWAT of 29?
SQL: SELECT SUM("100") FROM phil_taylor WHERE "lwat" = 29 AND "140" < 128