शुरू करेंमुफ़्त में शुरू करें

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.

यह अभ्यास पाठ्यक्रम का हिस्सा है

Introduction to Snowflake CoCo CLI

पाठ्यक्रम देखें

अभ्यास निर्देश

  • Ask CoCo for the three best-rated products, using a plain question with no extra rules. Press Ctrl+O to 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 /quit to close the session.

इंटरैक्टिव व्यावहारिक अभ्यास

हमारे इंटरैक्टिव अभ्यासों में से किसी एक के साथ सिद्धांत को व्यवहार में बदलें

अभ्यास शुरू करें