Let's Check solution and learn to analyse
Approach\nAs we have to find average time of each process under each machine_id\nso \n- at first let\'s make group by machine_id and process\n- From previous re
# Approach\nAs we have to find average time of each process under each machine_id\nso \n- at first let\'s make group by machine_id and process\n- From previous result let\'s find the average in 3 deci round figure by group under machine_id\n\n**So the solution is that level of easy , use your brain now and code**\n\n\n\n\n\n# Code\n```\n# Write your MySQL query statement below\n\nselect machine_id,round(avg(timetaken),3) as processing_time\nfrom\n(select machine_id,process_id,(max(timestamp)-min(timestamp)) as timetaken\nfrom Activity\ngroup by machine_id,process_id) t\ngroup by machine_id\n\n```\n![Screenshot 2023-12-03 042253.png](https://assets.leetcode.com/users/images/92c186e0-6d77-44b3-8f28-15df04ab1979_1705775283.7345104.png)\n
['MySQL']