Spotting Anomalies
The company has set a standard after 2006 that all 'Arriba' chocolate bars from the same manufacturer must have the same cocoa percentage and ingredients.
The business will need to update any record that is not compliant. And want to implement these updates quickly and efficiently.
Your task is to ensure that the data complies with this standard. You need to review the data to ensure no anomalies limit updating the records.
Deze oefening maakt deel uit van de cursus
Introduction to Data Modeling in Snowflake
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
-- Select the different values for the attributes list
SELECT ___,
___,
___
FROM productqualityrating
-- Add filter for attribute referring to name
___
-- Add filter for attribute referring to year
___;