Seagul

Lesson 3 - Total stop time by month and machine

Dataset statusEasy SQL exercisesvv1

Exercise content

In the machine and machine_oee tables, calculate the total stop downtime for each month and for each machine.

Order by:

month ascending
machine ascending

Hints

Hint 1

From reference_date you only need YYYY-MM. You can extract it with substr(reference_date, 1, 7).
Hint 2

Do a JOIN between machine_oee and machine to get the machine name. Then use SUM(stop) and GROUP BY both month and machine.

Not completed

Loading dataset...

Latest result

No result set available.