Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

Vote For New Content
17. Average Time of Process
On this page

Problem

Table: Activity

+----------------+---------+
| Column Name    | Type    |
+----------------+---------+
| machine_id     | int     |
| process_id     | int     |
| activity_type  | enum    |
| timestamp      | float   |
+----------------+---------+
The table shows the user activities for a factory website.
(machine_id, process_id, activity_type) is the primary key (combination of columns with unique values) of this table.
machine_id is the ID of a machine.
process_id is the ID of a process running on the machine with ID machine_id.

.....

.....

.....

Like the course? Get enrolled and start learning!

On this page