MY SQL MY SQL

12. Update table excursion, set the value of column type equal to the corresponding id value in the table type. This requires a SELECT * FROM type; to see what the id value is for each exType. For example, in my database a. 1 Scenic b. 2 Cultural, Scenic 13. Update table excursion, set the value of column foodBeverage equal to the corresnondino id value in the tahle fondBeverage. This renuires a SFIFCT FROM a. Loinimis in aniu name iroin laole excursion b. Column exSize from table size c. Column exType from table type d. Column offering from table foodBeverage e. Column exLevel from table activityLevel f. Columns durationMinutes and price from table excursion