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”?
Deze oefening maakt deel uit van de cursus
Intro to Snowflake for Devs, Data Scientists, Data Engineers
Interactieve oefening met praktijkervaring
Zet theorie om in actie met een van onze interactieve oefeningen
Begin oefening