Seagull

Lesson 5 - 14. OEE for each machine

Dataset statusEasy SQL exercisesvv1

Exercise content

Use the machine and machine_oee tables to calculate the oee for each machine.

For each machine, aggregate the production data and apply these formulas in the same query:

Show these columns:

Round oee to 2 decimal places and sort by oee DESC, machine ASC.

Hint 1
Connect machine_oee to machine with a JOIN on machine_id. Then group by machine name.
Hint 2
For quality, availability, and efficiency, use SUM(...) in both the numerator and the denominator. Multiply by 1.0 to avoid integer division.
Hint 3
You can write the product of the three fractions directly inside ROUND(..., 2), without using WITH.

Not completed

Loading dataset...

No result set available.