Please help with Question 4

Question 4. There are so many types of California burritos in the burritos table! Winifred wants to know which type is the highest rated across all restaurants. Create a table that has two columns: the name of the burrito and the average overall rating of that burrito across restaurants. In your calculations, you should compare burritos that contain the word "California". For example, there's "California" burritos, "California breakfast" burritos, "California Surf and Turf" burritos, etc. Tip: If multiple restaurants serve the "California - Chicken" burrito, what table method can we use to aggregate those together and find the average overall rating? Note: you can break up the solution into multiple lines, as long as you assign the final output table to california_burritos ! For reference however, the staff solution only used one line. california_burritos california burritos 'Name') burritos = ratings.join('Name', burritos_types, burritos.show(5) Name Yelp Google Overall Menu_Item Cost Albertacos 3.5 3.9 3.45 California 5.7 Albertacos 3.5 3.9 3.45 Carne asada 5.25 Burrito Factory 4.5 4.8 3.5 Steak everything 7.35 Burros and Fries 3.5 4.1 3.575 California 7.19 Burros and Fries 3.5 4.1 3.575 Carne asada 6.89 .. (207 rows omitted) Question 4. There are so many types of California burritos in the burritos table! Winifred wants to know which type is the highest rated across all restaurants. Create a table that has two columns: the name of the burrito and the average overall rating of that burrito across restaurants. In your calculations, you should compare burritos that contain the word "California". For example, there's "California" burritos, "California breakfast" burritos, "California Surf and Turf" burritos, etc. Tip: If multiple restaurants serve the "California - Chicken" burrito, what table method can we use to aggregate those together and find the average overall rating? Note: you can break up the solution into multiple lines, as long as you assign the final output table to california_burritos ! For reference however, the staff solution only used one line. california_burritos california burritos 'Name') burritos = ratings.join('Name', burritos_types, burritos.show(5) Name Yelp Google Overall Menu_Item Cost Albertacos 3.5 3.9 3.45 California 5.7 Albertacos 3.5 3.9 3.45 Carne asada 5.25 Burrito Factory 4.5 4.8 3.5 Steak everything 7.35 Burros and Fries 3.5 4.1 3.575 California 7.19 Burros and Fries 3.5 4.1 3.575 Carne asada 6.89 .. (207 rows omitted)