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”?