I just need the SQL statements for these problems: 1.)Insert into the PADDLING t
ID: 3826854 • Letter: I
Question
I just need the SQL statements for these problems:
1.)Insert into the PADDLING table the trip ID, trip name, state, distance, maximum group size, and season from the TRIP table for only those trips having type PADDLING.
2.) For all trips located in Connecticut (CT), increase the maximum group size by two.
3.)Insert a new trip into the PADDLING table. The trip ID is 43, the trip name is Lake Champlain Tour, the state is Vermont (VT), the maximum group size is 12, the distance is 16, and the season is Summer.
4.)Delete the trip in the PADDLING table with the trip ID 23.
Explanation / Answer
insert into paddling(id,trip_name,state,distance,maximum_group_size,season) values(34,'Jungle Camp','Connecticut',90,40,'Monsoon');
update paddling set maximum_group_size=maximum_group_size+2 where state='Connecticut';
insert into paddling(id,trip_name,state,distance,maximum_group_size,season) values(43,'Lake Champlain Tour','Vermont',16,12,'Summer');
delete from paddlig where id=23;