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.
This exercise is part of the course
Introduction to Data Modeling in Snowflake
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Create a view customer_financial_summary
___ ___ ___
SELECT c.customerid,
c.estimatedsalary,
cp.productid
FROM customers AS c
-- Merge entity
___ AS cp
___ c.customerid = ___;