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.
Diese Übung ist Teil des Kurses
Introduction to Data Modeling in Snowflake
Interaktive Übung
Vervollständige den Beispielcode, um diese Übung erfolgreich abzuschließen.
-- Create a view customer_financial_summary
___ ___ ___
SELECT c.customerid,
c.estimatedsalary,
cp.productid
FROM customers AS c
-- Merge entity
___ AS cp
___ c.customerid = ___;