NOTE: Al 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 thecompany'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 importantbenefits of using a DBMS$.$ Use SQL commands to answer the following exercises, you will use the data in theColonial Adventure Tours dFigure $4\mathrm{.}1$ presents sample trip data for BTEE Adventure Tours. Each trip is identified by a unique number calledTriplD. Furthermore, management tracks the trip name, the trip's starting location, and the province in which thetrip 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 thFigure $4\mathrm{.}1$: TripTriplD$13456789101112$State Park RideMount MandelaThaba TshwaaneGod's WindowMount ZweliSharak HillsWaterfallsNjomane MountTripNameRiver LoopSwaart KopLong PondMpuma FallsFigure $4\mathrm{.}2$: ReservationReseravtioniD$24001240022400324002400424006240072400024008$TripiDBiking$\mathrm{.}311110$Maloti$-$Drakensberg ParkBoschkopStartLocationGrootfontein Bike ParkiSimangaliso Wetland ParkHazeldean Valley TrailsUnderbergPaarlyear.CanoeingRosemary Hill FarmTierpoort Adventure FarVelddrifKayaking$14/02/202418/03/202427/02/202429/03/2024$than R$35000\mathrm{.}00?10/04/202419/04/202403/03/202421/02/202425/04/202412$TripDate NumPersons$106$ProvinceKZN$3$GautengGautengKZNGautengWestern CapeMpumalangaGautengGauteneWestern capeMpumalangadistance greater than twenty kilometers.TripPriceR$2250\mathrm{.}00$R$18000\mathrm{.}00$R$9000\mathrm{.}00$R$450\mathrm{.}0$oR$19500\mathrm{.}00$R$45000\mathrm{.}00$R$1350\mathrm{.}00$Distance MaxGrpSize TypeThe table named Reservation shown in Figure $4\mathrm{.}2$ shows the sample of reservation data for BTEE AdventureTours. Each reservation is identified by a unique reservation number that uses the last $2$ digits of the current yearfollowed by a three$-$digit number that increments sequentially. The table shows the TriplD, date, number ofpersons, price per person, and other related information.R$1650\mathrm{.}00$B$1150,0$o$151975815027110414438$OtherFeesRO$\mathrm{.}0$RO$\mathrm{.}00$R$10\mathrm{.}00$R$15\mathrm{.}00$RO$\mathrm{.}00$R$25\mathrm{.}00$R$12\mathrm{.}00$R$35\mathrm{.}0016$R$25\mathrm{.}003121518414$HikingBikineBikingHikingBikingHikineh.Write the SQL code to delete table RESERVATION from the database.BikingBikingPaddlingPaddlingCustomerNumPaddlingEarly FallPaddling Summer$5501550155265521551355085509$SeasonSummer$5521$Early spring$5502$SpringSpringSummerLate SpringSpringa.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 typeEarly SpringLate SpringSpring$(3)$c$.$ Write the SQL code to list the name of each trip that has the type Hiking and that has a$(4)(2)$d$.$Write the SQL code to list the name of each trip that has the type Paddling or that islocated in Mpumalanga.$(4)$e$.$Write the SQL command that calculates how many trips have a type of Paddling or Biking.$(6)$f$.$ Write the SQL code to list the trip name and province for each trip that occurs during the$(4)$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$(5)(2)$s database shown in the below figures:

HI pleas help me with number g$.$