Leetcode Problem 1661. Average Time of Process per Machine

1661. Average Time of Process per Machine

Leetcode Solutions

Select all records from the Activity table and alias it as a for 'start' timestamps and b for 'end' timestamps.
Join a and b on machine_id and process_id where a.activity_type is 'start' and b.activity_type is 'end'.
Calculate the time difference for each process by subtracting a.timestamp from b.timestamp.
Group the results by machine_id.
Calculate the average processing time for each group.
Round the average processing time to three decimal places.
Select machine_id and the calculated average processing time as processing_time.

erDiagram
    Activity {
        int machine_id
        int process_id
        enum activity_type
        float timestamp
    }

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen