Table: rampage_killers
Columns: perpetrator
date
year
location
country
killed
injured

Question: What is Date, when Country is "China", and when Perpetrator is "Shi Yuejun , 35"?
SQL: SELECT "date" FROM rampage_killers WHERE "country" = 'china' AND "perpetrator" = 'shi yuejun , 35'

Question: What is Injured, when Country is "Afghanistan"?
SQL: SELECT "injured" FROM rampage_killers WHERE "country" = 'afghanistan'

Question: What is Country, when Killed is "100.9", and when Year is greater than 1939.9?
SQL: SELECT "country" FROM rampage_killers WHERE "killed" = 100.9 AND "year" > 1939.9

Question: What is the average Year, when Date is "04.01 April 1"?
SQL: SELECT AVG("year") FROM rampage_killers WHERE "date" = '04.01 april 1'