Question: I am working on structured query language homework. I have already created the necessary tables for completing these questions, they are just based on concepts
I am working on structured query language homework. I have already created the necessary tables for completing these questions, they are just based on concepts I haven't quite mastered 
I will attach screenshots of the tables needed. Please help me with these queries b-j.

v structure of PADDLING table


In response to the comment: Question f is inserting this column. It is one of the things help is needed with.. According to my instructions, the minimum group size is only relevant to the PADDLING table.

b. Run a query for all paddling trips located in New Hampshire that increases the max group size by 2 unless it is already over 12. Insert a new trip into the database with a trip ID of 43, named Paddling Lake Granbury, in TX, with a max group size of 15, a distance of 6 and the season is Summer. Delete all paddling trips that are in CT. The max group size for the Lower Pond Tour in ME is under review due to changes in permits from the park department. Your boss wants you to update the table to show that this number is unknown at this time. Add a new column to the paddling table that indicates a minimum group's size and set the default value for all trips to 4 c. d. e. f. g. Change the table to disallow null values in the new field for group minimum size h. Change the minimum group size for all paddling trips in CT to 5 i. Decrease the customer's first name field to a length of 25 j. Delete the paddling table
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
