Leetcode MEDIUM 3601 - COMMON TABLE EXPRESSIONS in SQL - Find Drivers Improved Fuel Efficiency | EDS скачать в хорошем качестве

Leetcode MEDIUM 3601 - COMMON TABLE EXPRESSIONS in SQL - Find Drivers Improved Fuel Efficiency | EDS

Question: https://leetcode.com/problems/find-dr... SQL Schema: CREATE TABLE drivers ( driver_id INT, driver_name VARCHAR(255) ) CREATE TABLE trips ( trip_id INT, driver_id INT, trip_date DATE, distance_km DECIMAL(8, 2), fuel_consumed DECIMAL(6, 2) ) Truncate table drivers insert into drivers (driver_id, driver_name) values ('1', 'Alice Johnson') insert into drivers (driver_id, driver_name) values ('2', 'Bob Smith') insert into drivers (driver_id, driver_name) values ('3', 'Carol Davis') insert into drivers (driver_id, driver_name) values ('4', 'David Wilson') insert into drivers (driver_id, driver_name) values ('5', 'Emma Brown') Truncate table trips insert into trips (trip_id, driver_id, trip_date, distance_km, fuel_consumed) values ('1', '1', '2023-02-15', '120.5', '10.2') insert into trips (trip_id, driver_id, trip_date, distance_km, fuel_consumed) values ('2', '1', '2023-03-20', '200.0', '16.5') insert into trips (trip_id, driver_id, trip_date, distance_km, fuel_consumed) values ('3', '1', '2023-08-10', '150.0', '11.0') insert into trips (trip_id, driver_id, trip_date, distance_km, fuel_consumed) values ('4', '1', '2023-09-25', '180.0', '12.5') insert into trips (trip_id, driver_id, trip_date, distance_km, fuel_consumed) values ('5', '2', '2023-01-10', '100.0', '9.0') insert into trips (trip_id, driver_id, trip_date, distance_km, fuel_consumed) values ('6', '2', '2023-04-15', '250.0', '22.0') insert into trips (trip_id, driver_id, trip_date, distance_km, fuel_consumed) values ('7', '2', '2023-10-05', '200.0', '15.0') insert into trips (trip_id, driver_id, trip_date, distance_km, fuel_consumed) values ('8', '3', '2023-03-12', '80.0', '8.5') insert into trips (trip_id, driver_id, trip_date, distance_km, fuel_consumed) values ('9', '3', '2023-05-18', '90.0', '9.2') insert into trips (trip_id, driver_id, trip_date, distance_km, fuel_consumed) values ('10', '4', '2023-07-22', '160.0', '12.8') insert into trips (trip_id, driver_id, trip_date, distance_km, fuel_consumed) values ('11', '4', '2023-11-30', '140.0', '11.0') insert into trips (trip_id, driver_id, trip_date, distance_km, fuel_consumed) values ('12', '5', '2023-02-28', '110.0', '11.5') Pandas Schema: data = [[1, 'Alice Johnson'], [2, 'Bob Smith'], [3, 'Carol Davis'], [4, 'David Wilson'], [5, 'Emma Brown']] drivers = pd.DataFrame({ 'driver_id': pd.Series(dtype='int'), 'driver_name': pd.Series(dtype='str') }) data = [[1, 1, '2023-02-15', 120.5, 10.2], [2, 1, '2023-03-20', 200.0, 16.5], [3, 1, '2023-08-10', 150.0, 11.0], [4, 1, '2023-09-25', 180.0, 12.5], [5, 2, '2023-01-10', 100.0, 9.0], [6, 2, '2023-04-15', 250.0, 22.0], [7, 2, '2023-10-05', 200.0, 15.0], [8, 3, '2023-03-12', 80.0, 8.5], [9, 3, '2023-05-18', 90.0, 9.2], [10, 4, '2023-07-22', 160.0, 12.8], [11, 4, '2023-11-30', 140.0, 11.0], [12, 5, '2023-02-28', 110.0, 11.5]] trips = pd.DataFrame({ 'trip_id': pd.Series(dtype='int'), 'driver_id': pd.Series(dtype='int'), 'trip_date': pd.Series(dtype='datetime64[ns]'), 'distance_km': pd.Series(dtype='float'), 'fuel_consumed': pd.Series(dtype='float') }) #leetcode #datascience #tutorial