Exercise

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.

Instructions 1/3

undefined XP

1

2

3

Query the combinations of distinct manufacturer, cocoa_percent, and ingredients values from the productqualityrating entity.
Filter results where bar_name is equal to 'Arriba'.
Filter results for year_reviewed to be greater than 2006.

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercise

Instructions 1/3

Exercise