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.
Diese Übung ist Teil des Kurses
Introduction to Data Modeling in Snowflake
Interaktive Übung
Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.
-- 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
___;