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.
Questo esercizio fa parte del corso
Introduction to Data Modeling in Snowflake
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
-- Create a view customer_financial_summary
___ ___ ___
SELECT c.customerid,
c.estimatedsalary,
cp.productid
FROM customers AS c
-- Merge entity
___ AS cp
___ c.customerid = ___;