# 1 & 2 SQL class homework.

1. Create a PADDLING table with structure shown in Figure 6-29 PADDLING Column TRIP ID TRIP_NAME STATE DISTANCE MAX GRP SIZE SEASON Type DECIMAL3 CHAR CHAR DECIMAL DECIMAL 4 CHAR Length Decimal Places Nuls Alowed? Description Trip ID (primary key) Trip name Trip state Trip distance Maximum number of people on trip Season in which trip takes place 75 0 20 FIGURE 6-29 PADDLING table layout 2. 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