Seagul

Lesson 3 - 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, first aggregate the production data and then apply these formulas:

Show these columns:

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

Hint 1

Join machine_oee to machine with a JOIN. Then group by machine: the formulas must be calculated on totals.
Hint 2

For quality, availability, and efficiency, use SUM(...) in both the numerator and the denominator. To avoid integer division, multiply by 1.0.
Hint 3

Calculate quality * availability * efficiency * 100. Round with ROUND(..., 2) and order by oee DESC, machine ASC.

Not completed

Loading dataset...

No result set available.