List the registration number/s of the vehicle/s that have the most number of current bookings (trips which have not as yet been completed). The output should display the vehicle registration number and the total current bookings for the vehicle. If there is more than one vehicle with the most number of current bookings, order the output in descending order of the registration number.

Transcribed Image Text:

PF ORMER ID PF LANG ISO_CODE PDRIVER D DRIVER LANGUAGE DRIVER DOB DRIVER DRIVER GIVENNAME DRIVER FAMILYNAME NUMERIC (4) De CHAR (2) DRIVER LICENCE NO DRIVER CLEARANCE LEVEL DRIVER MODSCOMP PF DRIVER JO PF TRAINING CODE PDT DATE COMPLETED NUMERIC (4) VARCHAR (50) VARCHAR(50) Date DRIVER TRAINING TRAINING CHAR(18) CHAR (1) NUMERIC (2) NUMERIC (4) CHAR (5) Date TRAINING CODE CHAR (5) * TRAINING NAME VARCHAR (80) HI- LOCATION TYPE LOCTYPE JD NUMERIC (3) LOCTYPE_DESC VARCHAR (50) LOCATION ID LOCATION NAME LOCATION STREET LOCATION TOWN *LOCTYPE_ID P. TRIP JO U TRIP START LOCATION TRIP TRIP END TRIP_START_ACTUAL TRIP END ACTUAL TRIP START KM TRIP END KM TRIP PASSENGERS UF VEH VIN FLOCATION ID FROM FLOCATION JO TO UF OFF OLYMPIC JO UF DRIVER D p VEH VIN U VEH REGONUMBER VEH MAKE *VEH MODEL VEH COLOUR VEH SEATSAVAILABLE NUMERIC (6) VARCHAR (40) VARCHAR (50) VARCHAR (20) NUMERIC (3) NUMERIC (6) Date Date Jassigned so VEHICLE Date Date NUMERIC (5) NUMERIC () NUMERIC (2) CHAR (17) NUMERIC (5) NUMERIC (6) CHAR (8) NUMERIC (4) CHAR(17) CHAR (7) VARCHAR (40) VARCHAR (40) VARCHAR (20) NUMERIC (2) H LANG ISO_CODE LANG NAME books LANGUAGE OFFICIAL OFF OLYMPIC JO *OFF GIVENNAME *OFF FAMILYNAME * IOC ROLE_CODE * COUNTRY JOC_CODE LANG ISO CODE VEHICLE FEATURE PF VEH VIN PF FEATURE O COUNTRY COUNTRY JOC CODE CHAR (3) COUNTRY JOC_NAME VARCHAR (50) CHAR (2) VARCHAR (50) ofered by FEATURE CHAR (17) CHAR (2) FEATURE JO FEATURE DESC CHAR (2) VARCHAR (50) CHAR (8) VARCHAR (50) VARCHAR (50) CHAR (2) CHAR (3) CHAR (2) app IOC ROLE *10C ROLE CODE *10C ROLE DESC CHAR (2) VARCHAR (50) PF ORMER ID PF LANG ISO_CODE PDRIVER D DRIVER LANGUAGE DRIVER DOB DRIVER DRIVER GIVENNAME DRIVER FAMILYNAME NUMERIC (4) De CHAR (2) DRIVER LICENCE NO DRIVER CLEARANCE LEVEL DRIVER MODSCOMP PF DRIVER JO PF TRAINING CODE PDT DATE COMPLETED NUMERIC (4) VARCHAR (50) VARCHAR(50) Date DRIVER TRAINING TRAINING CHAR(18) CHAR (1) NUMERIC (2) NUMERIC (4) CHAR (5) Date TRAINING CODE CHAR (5) * TRAINING NAME VARCHAR (80) HI- LOCATION TYPE LOCTYPE JD NUMERIC (3) LOCTYPE_DESC VARCHAR (50) LOCATION ID LOCATION NAME LOCATION STREET LOCATION TOWN *LOCTYPE_ID P. TRIP JO U TRIP START LOCATION TRIP TRIP END TRIP_START_ACTUAL TRIP END ACTUAL TRIP START KM TRIP END KM TRIP PASSENGERS UF VEH VIN FLOCATION ID FROM FLOCATION JO TO UF OFF OLYMPIC JO UF DRIVER D p VEH VIN U VEH REGONUMBER VEH MAKE *VEH MODEL VEH COLOUR VEH SEATSAVAILABLE NUMERIC (6) VARCHAR (40) VARCHAR (50) VARCHAR (20) NUMERIC (3) NUMERIC (6) Date Date Jassigned so VEHICLE Date Date NUMERIC (5) NUMERIC () NUMERIC (2) CHAR (17) NUMERIC (5) NUMERIC (6) CHAR (8) NUMERIC (4) CHAR(17) CHAR (7) VARCHAR (40) VARCHAR (40) VARCHAR (20) NUMERIC (2) H LANG ISO_CODE LANG NAME books LANGUAGE OFFICIAL OFF OLYMPIC JO *OFF GIVENNAME *OFF FAMILYNAME * IOC ROLE_CODE * COUNTRY JOC_CODE LANG ISO CODE VEHICLE FEATURE PF VEH VIN PF FEATURE O COUNTRY COUNTRY JOC CODE CHAR (3) COUNTRY JOC_NAME VARCHAR (50) CHAR (2) VARCHAR (50) ofered by FEATURE CHAR (17) CHAR (2) FEATURE JO FEATURE DESC CHAR (2) VARCHAR (50) CHAR (8) VARCHAR (50) VARCHAR (50) CHAR (2) CHAR (3) CHAR (2) app IOC ROLE *10C ROLE CODE *10C ROLE DESC CHAR (2) VARCHAR (50)