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.
This exercise is part of the course
Introduction to Data Modeling in Snowflake
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- 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
___;