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”?
This exercise is part of the course
Intro to Snowflake for Devs, Data Scientists, Data Engineers
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise