Fixing an inherited query
A teammate left you daily_revenue.sql, the query behind the store's daily sales report. Finance says its numbers have looked too high for weeks. Rather than debug it yourself, hand the file to CoCo and let it find what's wrong.
This exercise is part of the course
Introduction to Snowflake CoCo CLI
Exercise instructions
- Start a CoCo session and ask it to find out why the report in
daily_revenue.sqloverstates the numbers, then fix the file. - Approve the change when CoCo asks for it.
- Close the session.
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise