Table: olympic_skeet_results
Columns: rank
athlete
country
day_1
total

Question: what is the country when the total is 111 and the day 1 is 69?
SQL: SELECT "country" FROM olympic_skeet_results WHERE "total" = 111 AND "day_1" = 69

Question: what is the average rank when the day 1 is less than 71 and the country is romania?
SQL: SELECT AVG("rank") FROM olympic_skeet_results WHERE "day_1" < 71 AND "country" = 'romania'

Question: how many times is the athlete jin di and the total less than 118?
SQL: SELECT COUNT("rank") FROM olympic_skeet_results WHERE "athlete" = 'jin di' AND "total" < 118