Yes, that's exactly what I mean
select sum ( t2.killed ) from people as t1 join perpetrator as t2 on t1.people_id = t2.people_id where t1.height > 1.84
How many perpetrators does that include?
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
When did the earliest killing take place?
select date from perpetrator order by date asc limit 1
Can you tell me how many people were injured for the most recent date?
select injured from perpetrator order by date desc limit 1
Yes, that is what I mean.
select country from perpetrator group by country order by sum ( killed ) +sum ( injured ) desc limit 1