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.
Deze oefening maakt deel uit van de cursus
Introduction to Snowflake CoCo CLI
Oefeninstructies
- 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.
Interactieve oefening met praktijkervaring
Zet theorie om in actie met een van onze interactieve oefeningen
Begin oefening