Seagul

Lesson 4 - Create current_oee Table

Dataset statusEasy SQL exercisesvv1

Exercise content

Create a table called current_oee starting from the machine_oee table.

current_oee must contain all and only the rows from machine_oee where the year of reference_date is 2025.

Hints

Hint 1

You do not need to define the columns by hand. Here it is useful to create the table directly from a SELECT.
Hint 2

reference_date is text: you just need to isolate the initial part with the year. Then keep only the rows from 2025.

Not completed

Loading dataset...

Latest result

No result set available.