From the relational database schema 

1. write sql query to display a list of available Drivers sorted according to their clearance level. Display the drive's license number, first name, last name and the clearance level.

2. Find the locations whose city names consist of one or more word is four character long ending with a 'k'. For each such location, display its street number, street name and city.

  

Transcribed Image Text:

PASSENGER VEHICLE CARGO_VEHICLE OFFICIAL LANGUAGE DropOffLocID VIN StartTimeIntended EndTimelntended Start TimeActual EndTimeActual StartOdometerKM EndOdometerKM VIN Pass_seat_capacity VIN Carg_cfeet_capacity Carg_tons_capacity OfficialID LanguageCode INT CHAR DATETIME DATETIME DATETIME DATETIME INT INT CHAR TINYINT CHAR SMALLINT Decimal CHAR CHAR Off Lang_Preference CHAR 17 17 17 (5,2) 8 2 1 JONID Foreign key references LOCATION (LocationID) Foreign Key references VEHICLE(VIN) Format: DD-MM-YYYY HH:MM:SS Format: DD-MM-YYYY HH:MM:SS Format: DD-MM-YYYY HH:MM:SS Format: DD-MM-YYYY HH:MM:SS Primary Key, Foreign Key references VEHICLE(VIN) e.g., 1, 2, 3, ... Primary Key, Foreign Key references VEHICLE(VIN) e.g., 40, 210, 350 (1 cubic foot = 0.025 tons) e.g., 1, 5.25, 8.75 (1 ton = 40 cubic feet) Primary Key, Foreign key references OFFICIAL(OfficialID) Primary Key, Foreign Key references LANGUAGE(LanguageCode) 1, 2, 3, 4, 5, ... (1 is the highest preference) PASSENGER VEHICLE CARGO_VEHICLE OFFICIAL LANGUAGE DropOffLocID VIN StartTimeIntended EndTimelntended Start TimeActual EndTimeActual StartOdometerKM EndOdometerKM VIN Pass_seat_capacity VIN Carg_cfeet_capacity Carg_tons_capacity OfficialID LanguageCode INT CHAR DATETIME DATETIME DATETIME DATETIME INT INT CHAR TINYINT CHAR SMALLINT Decimal CHAR CHAR Off Lang_Preference CHAR 17 17 17 (5,2) 8 2 1 JONID Foreign key references LOCATION (LocationID) Foreign Key references VEHICLE(VIN) Format: DD-MM-YYYY HH:MM:SS Format: DD-MM-YYYY HH:MM:SS Format: DD-MM-YYYY HH:MM:SS Format: DD-MM-YYYY HH:MM:SS Primary Key, Foreign Key references VEHICLE(VIN) e.g., 1, 2, 3, ... Primary Key, Foreign Key references VEHICLE(VIN) e.g., 40, 210, 350 (1 cubic foot = 0.025 tons) e.g., 1, 5.25, 8.75 (1 ton = 40 cubic feet) Primary Key, Foreign key references OFFICIAL(OfficialID) Primary Key, Foreign Key references LANGUAGE(LanguageCode) 1, 2, 3, 4, 5, ... (1 is the highest preference)

Answer rating: 100% (QA)

1 List of Available Drivers Sorted by Clearance Level Sql Code SELECT DriverLicenceNum DriverFirstNa... View the full answer