commit d10564d2b0a874a39b7397407e5d79dced8fbe64 parent 61054fd2b5705d233cb45679095a1a5627b08a32 Author: AndrewLockVI <andrewlaack1@gmail.com> Date: Fri, 30 Jun 2023 10:58:59 -0500 Completed average time of process using mysql Diffstat:
| A | average-time-of-process-per-machine/average-time-per-machine.sql | | | 10 | ++++++++++ |
1 file changed, 10 insertions(+), 0 deletions(-)
diff --git a/average-time-of-process-per-machine/average-time-per-machine.sql b/average-time-of-process-per-machine/average-time-per-machine.sql @@ -0,0 +1,10 @@ +--Given a list of machines and timestamps write a query +--that calculates the average time between the start and finish +--for each machine. +SELECT + s.machine_id, + ROUND(AVG(e.timestamp-s.timestamp),3) as processing_time +FROM Activity s +JOIN Activity e ON e.machine_id=s.machine_id +WHERE s.activity_type='start' AND e.activity_type='end' +GROUP BY s.machine_id