Question: a . Write the SQL code to list the name of each trip that does not start in KZN . ( 3 ) b .

a.Write the SQL code to list the name of each trip that does not start in KZN.(3)
b.Write the SQL code to list the name and start location for each trip that has the type
Biking. (2)
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. (4)
d.Write the SQL code to list the name of each trip that has the type Paddling or that is
located 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
summer season. Sort the results by trip name within the same province. (4)
g.How many reservations include a trip with a price that is greater than R2000.00 but less
than R35000.00?(5)
h.Write the SQL code to delete table RESERVATION from the database. (2)
a . Write the SQL code to list the name of each

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!