Table: iran_1998_asian_games
Columns: athlete
event
snatch
clean_jerk
total

Question: How many snatches were there with a total of 267.5?
SQL: SELECT COUNT("snatch") FROM iran_1998_asian_games WHERE "total" < 267.5

Question: What event has a 122.5 snatch rate?
SQL: SELECT "event" FROM iran_1998_asian_games WHERE "snatch" = 122.5

Question: What is the lowest total that had less than 170 snatches, 56 kg events and less than 145 clean & jerk?
SQL: SELECT MIN("total") FROM iran_1998_asian_games WHERE "snatch" < 170 AND "event" = '56 kg' AND "clean_jerk" < 145

Question: What is the total that had an event of +105 kg and clean & jerk less than 227.5?
SQL: SELECT COUNT("total") FROM iran_1998_asian_games WHERE "event" = '+105 kg' AND "clean_jerk" < 227.5