Create a view v_available_trips, that shows trip details like below (date will be different). To do that, you will need to create a select statement to connect all the tables, pull relevant columns and give them names as below. Test your select before creating the view. Hint for the max_number_of_guests column: the boat capacity is total of guests and the captain.