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

Question: What is the average Year, when Country is "U.S.", and when Location is "Edmond , OK"?
SQL: SELECT AVG("year") FROM rampage_killers_6 WHERE "country" = 'u.s.' AND "location" = 'edmond , ok'

Question: What is the lowest Killed, when Perpetrator is "Sherrill, Patrick Henry , 44"?
SQL: SELECT MIN("killed") FROM rampage_killers_6 WHERE "perpetrator" = 'sherrill, patrick henry , 44'