Write SQL qureries for (i) to (iv) and find outputs for SQL queries (v) to (viii), which are based on the tables TRANSPORT and TRIENote:PERKS is Freight Charages per kilometerTTYPE is Transport Vehicle TypeNote:NO is Driver NumberKM is Kilometer travelledNOP is number of travellers travelled in vehicleTDATE is Trip Date1. To display NO, NAME, TDATE from the table TRIP in descending order of NO.2. To display the NAME of the drivers from the table TRIP who are traveling by transport vehicle with code 101 or 103.3. To display the NO and NAME of those drivers from the table TRIP who travelled between ‘2015-02-10’ and ‘2015-04-01’.4. To display all the details from table TRIP in which the distance travelled is more than 100 KM in ascending order of NOP5. SELECT COUNT (*), TCODE From TRIP GROUP BY TCODE HAVNING COUnT (*) > 1;6. SELECT DISTINCT TCODE from TRIP;7. SELECT A.TCODE, NAME, TTYPE FROM TRIP A, TRANSPORT B WHERE A. TCODE = B. TCODE AND KM < 90;8. SELECT NAME, KM *PERKM FROM TRIP A, TRANSPORT B WHERE A. TCODE = B. TCODE AND A. TCODE = 105′;