Ask with what you know
Now that you know your way around, marketing has a first request: the three best-rated products to feature on the homepage. There's a catch CoCo can't know about. The store only features products it still sells, and your team marks discontinued ones with is_active = FALSE.
Cet exercice fait partie du cours
<cours>Introduction to Snowflake CoCo CLI</cours>Instructions de l’exercice
- Ask CoCo for the three best-rated products, using a plain question with no extra rules. Press
Ctrl+Oto see the SQL behind its answer, and note which products made the list. - Ask again, this time adding your team's rule about discontinued products, and compare the new top three with the first one.
- Type
/quitto close the session.
Exercice interactif pratique
Transformez la théorie en action avec l’un de nos exercices interactifs
Commencer l’exercice