I will attach screenshots of the tables needed. Please help me with these querie
ID: 3700964 • Letter: I
Question
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 tableExplanation / Answer
b. Update Paddling set max_grp_size = max_grp_size + 2 where state = 'NH' and max_grp_size<12;
c. insert into trip values(43,'paddling lake granbury','lake granbury','TX',15,6,'paddling','summer');
d. delete from trip where state='CT' and type='paddling';
e. update trip set max_grp_size=null where trip_name= 'lower pond tour' and state='ME';
f. alter table paddling add min_grp_size number(38,0) default 4;
g. alter table paddling modify min_grp_size number(38,0) not null default 4;
h. update paddling set min_grp_size = 5 where state = 'CT';
i. alter table customer modify first_name varchar2(25) not null;
j. drop table paddling;