How to Solve Find Drivers with Improved Fuel Efficiency Problem

Table: drivers +-------------+---------+ | Column Name | Type | +-------------+---------+ | driver_id | int | | driver_name | varchar | +-------------+---------+ driver_id is the unique identifier for this table. Each row contains information about a driver. Table: trips +---------------+---------+ | Column Name | Type | +---------------+---------+ | trip_id | int | | driver_id | int | | trip_date | date | | distance_km | decimal | | fuel_consumed | decimal | +---------------+---------+ trip_id is the unique identifier for this table. Each row represents a trip made by a driver, including the distance traveled and fuel consumed for that trip. Write a solution to find drivers whose fuel efficiency has improved by comparing their average fuel efficiency in the first half of the year with the second half of the year. Calculate fuel efficiency as distance_km / fuel_consumed for each trip First half: January to June, Second half: July to December Only include drivers who have trips in both halves of the year Calculate the efficiency improvement as (second_half_avg - first_half_avg) Round all results to 2 decimal places Return the result table ordered by efficiency improvement in descending order, then by driver name in ascending order. The result format is in the following example.