human
Schema:
perpetrator (Perpetrator_ID, People_ID, Date, Year, Location, Country, Killed, Injured)
people (People_ID, Name, Height, Weight, Home Town)
Please answer with SQL.
assistant
Sure, I understand.
human
I want to know how many perpetrators are taller than 1.84 | So do you mean the kills of perpetrators with height more than 1.84? | Yes, that's exactly what I mean
assistant
SELECT SUM( T2.Killed ) FROM people AS T1 JOIN perpetrator AS T2 ON T1.People_ID = T2.People_ID WHERE T1.Height > 1.84;
human
How many perpetrators does that include?
assistant
SELECT COUNT( T2.Perpetrator_ID ) FROM people AS T1 JOIN perpetrator AS T2 ON T1.People_ID = T2.People_ID WHERE T1.Height > 1.84;
human
When did the earliest killing take place?
assistant
SELECT date FROM perpetrator ORDER by date asc LIMIT 1 ;