Update 1661_Average_Time_of_Process_per_Machine.sql

rajtuts · web-flow · commit d851587207c8 · 2024-08-02T07:57:44.000-05:00
diff --git a/2-Basic-Joins/1661_Average_Time_of_Process_per_Machine.sql b/2-Basic-Joins/1661_Average_Time_of_Process_per_Machine.sql
@@ -27,39 +27,39 @@
 
 -- Return the result table in any order.
 
-Example 1:
+-- Example 1:
 
-Input: 
-Activity table:
-+------------+------------+---------------+-----------+
-| machine_id | process_id | activity_type | timestamp |
-+------------+------------+---------------+-----------+
-| 0          | 0          | start         | 0.712     |
-| 0          | 0          | end           | 1.520     |
-| 0          | 1          | start         | 3.140     |
-| 0          | 1          | end           | 4.120     |
-| 1          | 0          | start         | 0.550     |
-| 1          | 0          | end           | 1.550     |
-| 1          | 1          | start         | 0.430     |
-| 1          | 1          | end           | 1.420     |
-| 2          | 0          | start         | 4.100     |
-| 2          | 0          | end           | 4.512     |
-| 2          | 1          | start         | 2.500     |
-| 2          | 1          | end           | 5.000     |
-+------------+------------+---------------+-----------+
-Output: 
-+------------+-----------------+
-| machine_id | processing_time |
-+------------+-----------------+
-| 0          | 0.894           |
-| 1          | 0.995           |
-| 2          | 1.456           |
-+------------+-----------------+
-Explanation: 
-There are 3 machines running 2 processes each.
-Machine 0's average time is ((1.520 - 0.712) + (4.120 - 3.140)) / 2 = 0.894
-Machine 1's average time is ((1.550 - 0.550) + (1.420 - 0.430)) / 2 = 0.995
-Machine 2's average time is ((4.512 - 4.100) + (5.000 - 2.500)) / 2 = 1.456
+-- Input: 
+-- Activity table:
+-- +------------+------------+---------------+-----------+
+-- | machine_id | process_id | activity_type | timestamp |
+-- +------------+------------+---------------+-----------+
+-- | 0          | 0          | start         | 0.712     |
+-- | 0          | 0          | end           | 1.520     |
+-- | 0          | 1          | start         | 3.140     |
+-- | 0          | 1          | end           | 4.120     |
+-- | 1          | 0          | start         | 0.550     |
+-- | 1          | 0          | end           | 1.550     |
+-- | 1          | 1          | start         | 0.430     |
+-- | 1          | 1          | end           | 1.420     |
+-- | 2          | 0          | start         | 4.100     |
+-- | 2          | 0          | end           | 4.512     |
+-- | 2          | 1          | start         | 2.500     |
+-- | 2          | 1          | end           | 5.000     |
+-- +------------+------------+---------------+-----------+
+-- Output: 
+-- +------------+-----------------+
+-- | machine_id | processing_time |
+-- +------------+-----------------+
+-- | 0          | 0.894           |
+-- | 1          | 0.995           |
+-- | 2          | 1.456           |
+-- +------------+-----------------+
+-- Explanation: 
+-- There are 3 machines running 2 processes each.
+-- Machine 0's average time is ((1.520 - 0.712) + (4.120 - 3.140)) / 2 = 0.894
+-- Machine 1's average time is ((1.550 - 0.550) + (1.420 - 0.430)) / 2 = 0.995
+-- Machine 2's average time is ((4.512 - 4.100) + (5.000 - 2.500)) / 2 = 1.456
 
 
 ------------------------------------------------------------------------------
