Seagull

Lesson 5 - 1. Average total_pieces per machine

Dataset statusEasy SQL exercisesvv1

Exercise content

Using the machine and machine_oee tables, calculate the average of total_pieces for each machine.

Show the columns:

machine
brand
avg_pieces

Round avg_pieces to 2 decimal places and order by avg_pieces DESC, machine ASC.

Hints

Hint 1
Join machine and machine_oee through machine_id. Then calculate AVG(total_pieces) for each machine.
Hint 2
Show machine, brand, and the average with alias avg_pieces. Round with ROUND(..., 2) and sort in descending order.

Not completed

Loading dataset...

Latest result

No result set available.