Here is the link to the problem: Average time of Process per Machine. Problem Statement: Table: Activity Column Name Type machine_id int process_id int activity_type enum timestamp float There is a factory website that has several machines each running the same number of processes. Write a solution to find the average time each machine takes to complete a process. The time to complete a process is the ’end’ timestamp minus the ‘start’ timestamp....
Here is the link to the problem: Project Employees I . Problem Statement: Table: Activity Column Name Type machine_id int process_id int activity_type enum timestamp float There is a factory website that has several machines each running the same number of processes. Write a solution to find the average time each machine takes to complete a process. The time to complete a process is the ’end’ timestamp minus the ‘start’ timestamp....
Here is the link to the problem: Customers who never order. Problem Statement: Table: Customers Column Name Type id int name varchar id is the primary key (column with unique values) for this table. Each row of this table indicates the ID and name of a customer. Table: Orders Column Name Type id int customerId int id is the primary key (column with unique values) for this table. customerId is a foreign key (reference columns) of the ID from the Customers table....