Views — Question 1
Use the CREATE VIEW command to create a truck_franchise view of the following query: SELECT t.*, f.first_name AS franchisee_first_name, f.last_name AS franchisee_last_name FROM tasty_bytes.raw_pos.truck t JOIN tasty_bytes.raw_pos.franchise f ON t.franchise_id = f.franchise_id; What is the “make” of the food truck for the franchisee with the first name of “Sara” and the last name of “Nicholson”?
Diese Übung ist Teil des Kurses
<Kurs>Intro to Snowflake for Devs, Data Scientists, Data Engineers</Kurs>Interaktive praktische Übung
Verwandle Theorie mit einer unserer interaktiven Übungen in die Praxis
Übung starten