The Driver Relationship team realized that there is no need for DRIVER_DRIVING_LICENSE_CHECKED field in the active drivers table. Since all the drivers are already active in InstantRide, their driving licenses should be checked regularly. The team wanted you to remove the field from the table. # Instructions Page 1 of 4## Scenario and Database Model: InstantRide**InstantRide** is the new ride-sharing application in the city and has just started its operations. Through the InstantRide mobile application, users can request a ride by providing their location. Drivers and cars are then assigned to fulfill the request, allowing the driver to pick up the user and transport them to their desired location. The database stores information about users, drivers, cars, and travel transactions.### USERS TableIn the **USERS** table, information such as the first name, last name, and email of each user is stored. Below is a representation of this table:| USER_ID | USER_FIRST_NAME | USER_LAST_NAME | USER_EMAIL ||---------|-----------------|----------------|--------------------|| 3001 | Jack | Hill | j.hill@xmail.com || 3002 | Ryan | Collins | r.collins@xmail.com|| 3003 | Nursin | Yilmaz | n.atak@gmail.com || 3004 | Sarah | Price | s.price@xmail.com || 3005 | Bobby | Griffin | b.griffin@xmail.com|| 3006 | Randy | Clark | r.clark@xmail.com || 3007 | Jose | Thomas | j.thomas@xmail.com || 3008 | Nursin | Yilmaz | n.yilmaz@xmail.com |### DRIVERS TableIn the **DRIVERS** table, all drivers in the InstantRide system have their names, driving license number, verification status, and rating information recorded:| DRIVER_ID | DRIVER_FIRST_NAME | DRIVER_LAST_NAME | DRIVER_DRIVING_LICENSE_ID | DRIVER_START_DATE | DRIVER_DRIVING_LICENSE_CHECKED | DRIVER_RATING ||-----------|-------------------|------------------|---------------------------|-------------------|-------------------------------|---------------|| 2001 | Willie | Butler | 1874501 | 2019-09-12 | 1 | 4.4 || 2002 | Justin | Howard | 1953853 | 2019-09-09 | 1 | 4.8 || 2003 Finally, the transactions of the rides are stored in the **TRAVELS** table. For each travel, start and end time with location are stored. In addition, the involved driver, car, and user are listed for each drive. Price and discount information are also available in the database:**TRAVELS Table**| TRAVEL_ID | TRAVEL_START_TIME | TRAVEL_END_TIME | TRAVEL_START_LOCATION | TRAVEL_END_LOCATION | TRAVEL_PRICE | DRIVER_ID | CAR_ID | USER_ID | TRAVEL_DISCOUNT ||-----------|-------------------|-------------------|-----------------------|---------------------|--------------|-----------|--------|---------|-----------------|| 5001 | 2019-10-01 04:04:55 | 2019-10-01 04:14:19 | 9614 York Road | 84 Church Lane | 15.44 | 2001 | 1003 | 3005 | NULL || 5002 | 2019-10-01 05:57:33 | 2019-10-01 06:12:33 | 47 Church Street | 68 High Street | 20.56 | 2001 | 1003 | 3006 | NULL || 5003 | 2019-10-01 13:35:20 | 2019-10-01 13:45:10 | 2 Windsor Road | 95 West Street | 12.32 | 2002 | 1001 | 3002 | NULL || 5004 | 2019-10-02 08:44:48 | 2019-10-02 09:15:28 | 9060 Mill Lane | 27 Main Road | 30.49 | 2003 | 1002 | 3001 | 0.13 || 5005 | 2019-10-02 16:38:54 | 2019-10-02 16:48:10 | 2 Queensway | 24 Mill Lane | 11.15 | 2001 | 1003 | 3007 | NULL || 5006 | 2019-

Structured Query Language : SQL is a space explicit language utilized in programming and intended for overseeing information held in a relational database management system (RDBMS), or for stream preparing in a relational data stream management system (RDSMS). It is especially valuable in dealing with organized information, for example information joining relations among substances and factors.Solution : select Driver_ID, count( distinct Car_id) as Cars /*find the distinct car_id to get list of unique cars*/from Travelsgroup by Driver_IDorder by 3 desc select Driver_ID, Car_id, Count(Cid) cars /*find the distinct Driver_ID, car_id to get list of unique cars*/from Travelsgroup by Driver_ID, Car_idhaving Count(car_id) > 1 /*check for more than one car*/order by 3 desc select distinct Travel_start_location /*get distinct location */from Travels select avg(TravelCount), max(TravelCount), sum(TravelCount) //use aggregate functionfrom(select user_id , count(Travel_id) TravelCount /*Based on user_id get the TravelCount*/from Travelsgroup by user_id)A select Driver_ID, DAY(Travel_start_time) as DAYS, count(Travel_Id) as RIDESfrom Travelswhere Month(Travel_start_time) = 10 /*october*/group by Driver_ID, DAY(Travel_start_time) /*for each driver and Day get the ride count*/ select Travel_id,Travel_start_time, Travel_end_time, Travel_start_location, Travel_end_location,Travel_Price,Driver_ID,Car_id,user_id,Travel_discountfrom Travelswhere Car_id in ( /*subQuery*/select Car_id from Carswhere upper(substr(Car_Plate,1,6)) = 'BB-883' /*check for the Car_Plate*/)