Sqls

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. The average time is calculated by the total time to complete every process on the machine divided by the number of processes that were run. ...

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. The average time is calculated by the total time to complete every process on the machine divided by the number of processes that were run. ...

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. Each row of this table indicates the ID of an order and the ID of the customer who ordered it. ...