NOTE: All SQL syntax must be correct, missing characters will be penalized!

BTEE Adventure Tours is a small business that organizes daylong, guided trips to South Africa. To support the

company's growing business, management uses a database to ensure that the company's data is current,

accurate, and easily accessible.

The owner of Colonial Adventure Tours knows that being able to run queries is one of the most important

benefits of using a DBMS$.$ Use SQL commands to answer the following exercises, you will use the data in the

Colonial Adventure Tours database shown in the below figures:

Figure $4\mathrm{.}1$ presents sample trip data for BTEE Adventure Tours. Each trip is identified by a unique number called

TripID. Furthermore, management tracks the trip name, the trip's starting location, and the province in which the

trip originates. In addition, management records the trip's total distance $($in KMs$),$ the trip's maximum group size,

the trip's type, and the season of the year.

Figure $4\mathrm{.}1$: Trip

The table named Reservation shown in Figure $4\mathrm{.}2$ shows the sample of reservation data for BTEE Adventure

Tours. Each reservation is identified by a unique reservation number that uses the last $2$ digits of the current year

followed by a three$-$digit number that increments sequentially. The table shows the TripID, date, number of

persons, price per person, and other related information.

Figure $4\mathrm{.}2$: Reservation

a$.$ Write the SQL code to list the name of each trip that does not start in KZN$.$

b$.$ Write the SQL code to list the name and start location for each trip that has the type

Biking.

c$.$ Write the SQL code to list the name of each trip that has the type Hiking and that has a

distance greater than twenty kilometers.

d$.$ Write the SQL code to list the name of each trip that has the type Paddling or that is

located in Mpumalanga.

e$.$Write the SQL command that calculates how many trips have a type of Paddling or Biking.

f$.$ Write the SQL code to list the trip name and province for each trip that occurs during the

summer season. Sort the results by trip name within the same province.

g$.$How many reservations include a trip with a price that is greater than R$2000\mathrm{.}00$ but less

than R$35000\mathrm{.}00?$

h$.$ Write the SQL code to delete table RESERVATION from the database.