Leetcode SQL

1661. Average Time of Process per Machine

Solution:

select machine_id, 
       round((sum(case when activity_type = 'end' then timestamp end)- sum(case when activity_type = 'start' then timestamp end))
/count(distinct process_id),3) as processing_time
from Activity
group by 1;

Link