I just need the SQL statements for these problems. 1.)Make the distance for the
ID: 3827886 • Letter: I
Question
I just need the SQL statements for these problems.
1.)Make the distance for the Pontook Reservoir Tour trip equal to an unknown number.
2.)Add to the PADDLING table a new character column named DIFFICULTY_LEVEL that is three characters in length. Then set the default difficulty level value for all rows to the value MOD.
3.)Change the DIFFICULTY_LEVEL column in the PADDLING table to HRD for the Lake Champlain Tour trip.
4.)Change the DIFFICULTY_LEVEL column in the PADDLING table to reject nulls.
PADDLING Column Type Length Decimal Places Nulls Allowed? Description DECIMAL 3 TRIP ID Trip ID (primary key) 75 TRIP NAME CHAR Trip name 2 STATE CHAR Trip state DISTANCE DECIMAL 4 Trip distance MAX GRP SIZE DECIMAL 4 0 Maximum number of people on trip 20 Season in which trip takes place SEASON CHARExplanation / Answer
1.update Table paddling SET distance=1234 where TRIP_NAME='pontook reservoir';
2.Alter Table Paddling ADD difficulty_level char(3);
Alter Table Paddling Alter Column difficulty_level SET DEFAULT 'MOD';
3.Update Table Paddling SET difficulty_level='HRD' where TRIP_NAME='Lake Champlain';
4.Alter Table Paddling Alter column difficulty_level char(3) NOT NULL;