Question: a . Write the SQL code to list the name of each trip that does not start in KZN . ( 3 ) b .
aWrite the SQL code to list the name of each trip that does not start in KZN
bWrite the SQL code to list the name and start location for each trip that has the type
Biking.
cWrite the SQL code to list the name of each trip that has the type Hiking and that has a
distance greater than twenty kilometers.
dWrite the SQL code to list the name of each trip that has the type Paddling or that is
located in Mpumalanga.
eWrite 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.
gHow many reservations include a trip with a price that is greater than R but less
than R
hWrite the SQL code to delete table RESERVATION from the database.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
