Implementing views
The Star Customer financial company seeks to streamline its data management to efficiently categorize customers and track their product usage. You will create a view to facilitate quick and efficient data retrieval, calculating specific customer categories.
Bu egzersiz
Introduction to Data Modeling in Snowflake
kursunun bir parçasıdırUygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- Create a view customer_financial_summary
___ ___ ___
SELECT c.customerid,
c.estimatedsalary,
cp.productid
FROM customers AS c
-- Merge entity
___ AS cp
___ c.customerid = ___;