Commit7fa1046

authored

Update script.sql

1 parentc689247 commit7fa1046Copy full SHA for 7fa1046

File tree

-2

lines changed

src.save/main/java/g1601_1700/s1661_average_time_of_process_per_machine
- script.sql

-2

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`1`	`1`	`# Write your MySQL query statement below`
`2`	`2`	`# #Easy #Database #2023_08_16_Time_429_ms_(79.06%)_Space_0B_(100.00%)`
`3`		`-selectact1.machine_id,round(avg(act2.timestamp-act1.timestamp),3)as processing_timefrom activity act1join activity act2onact1.machine_id=act2.machine_id`
	`3`	`+selectact1.machine_id,round(avg(act2.timestamp-act1.timestamp),3)as processing_timefrom activity act1join activity act2onact1.machine_id=act2.machine_id`
`4`	`4`	`whereact1.process_id=act2.process_idandact1.activity_type='start'`
`5`		`-andact2.activity_type='end'group byact1.machine_id;`
	`5`	`+andact2.activity_type='end'group byact1.machine_id;`

Comments

(0)