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.
Latihan ini adalah bagian dari kursus
Introduction to Data Modeling in Snowflake
Latihan interaktif praktis
Cobalah latihan ini dengan menyelesaikan kode contoh berikut.
-- Create a view customer_financial_summary
___ ___ ___
SELECT c.customerid,
c.estimatedsalary,
cp.productid
FROM customers AS c
-- Merge entity
___ AS cp
___ c.customerid = ___;