Update query questions (5 points per question). Create a table called Biking with the following columns: trip id, trip name, state, distance, max_grp_size and season. The meta information for these columns are below: e. Insert into the biking table the trip id, trip name, state, distance, maximum group size and season from the trip table for only those trips having type biking. f. For all the trips located in Connecticut (CT), increase the trip price by 10 percent (due to inflation). Update the trip table accordingly. g. Change the length of the season column in the biking table to 30 characters.

Tables:

\( \begin{aligned} \text { SELECT } & \text { TOP (1000) [CUSTOMER_NUM] } \\ & ,[\text { LAST_NAME ] } \\ & ,[\text { FIRST_NAME] } \\ & ,[\text { ADDRESS ] } \\ & ,[\text { CITY ] } \\ & ,[\text { STATE ] } \\ & ,[\text { POSTAL_CODE ] } \\ & ,[\text { PHONE ] } \\ \text { FROM } & {[\text { COLONIAL] }][\mathrm{dbo}] \cdot[\text { CUSTOMER ] }}\end{aligned} \) \( \begin{aligned} \text { [SELECT } & \text { TOP (1000) [GUIDE_NUM] } \\ & ,[\text { LAST_NAME] } \\ & ,[\text { FIRST_NAME ] } \\ & ,[\text { ADDRESS] } \\ & {[\text { CITY] }} \\ & ,[\text { STATE }] \\ & ,\left[P O S T A L \_C O D E ight] \\ & ,[\text { PHONE_NUM] } \\ & ,[\text { HIRE_DATE ] } \\ \text { FROM } & {[\text { COLONIAL }] \cdot[\mathrm{dbo}] \cdot[\text { GUIDE }] }\end{aligned} \) \( \begin{aligned} \text { SELECT } & \text { TOP_(1000) [RESERVATION_ID] } \\ & ,[\text { TRIP_ID] } \\ & ,[\text { TRIP_DATE ] } \\ & ,[\text { NUM_PERSONS }] \\ & {[\text { TRIP_PRICE ] }} \\ & ,[\text { OTHER_FEES ] } \\ & ,[\text { CUSTOMER_NUM ] } \\ \text { FROM } & {[\text { COLONIAL] }][\mathrm{dbo}] \cdot[\text { RESERVATION }] }\end{aligned} \) \( \begin{aligned} \text { SELECT } & \text { TOP (1000) [TRIP_ID] } \\ & ,\left[G U I D E \_N U M ight] \\ & {[\text { [ASSIGN_DATE] }} \\ \text { FROM } & {[\text { COLONIAL] }[\text { dbo ] [TRIP_GUIDES ] }}\end{aligned} \) \( \begin{aligned} \text { SSELECT } & \text { TOP }(1000)[\text { TRIP_ID] } \\ & ,[\text { TRIP_NAME] } \\ & ,[\text { START_LOCATION] } \\ & ,[\text { STATE] } \\ & ,[\text { DISTANCE] } \\ & ,[\text { MAX_GRP_SIZE ] } \\ & {[\text { TYPE }] } \\ & ,[\text { SEASON] } \\ \text { FROM } & {[\text { COLONIAL] }][\text { dbo }] \cdot[\text { TRIP }] }\end{aligned} \) Results Messages Query executed successfully