Leetcode Problem - 1635. Hopper Company Queries I | SQL | Hard Question

Case 1
Create table If Not Exists Drivers (driver_id int, join_date date)
Create table If Not Exists Rides (ride_id int, user_id int, requested_at date)
Create table If Not Exists AcceptedRides (ride_id int, driver_id int, ride_distance int, ride_duration int)
Truncate table Drivers
insert into Drivers (driver_id, join_date) values ('10', '2019-12-10')
insert into Drivers (driver_id, join_date) values ('8', '2020-1-13')
insert into Drivers (driver_id, join_date) values ('5', '2020-2-16')
insert into Drivers (driver_id, join_date) values ('7', '2020-3-8')
insert into Drivers (driver_id, join_date) values ('4', '2020-5-17')
insert into Drivers (driver_id, join_date) values ('1', '2020-10-24')
insert into Drivers (driver_id, join_date) values ('6', '2021-1-5')
Truncate table Rides
insert into Rides (ride_id, user_id, requested_at) values ('6', '75', '2019-12-9')
insert into Rides (ride_id, user_id, requested_at) values ('1', '54', '2020-2-9')
insert into Rides (ride_id, user_id, requested_at) values ('10', '63', '2020-3-4')
insert into Rides (ride_id, user_id, requested_at) values ('19', '39', '2020-4-6')
insert into Rides (ride_id, user_id, requested_at) values ('3', '41', '2020-6-3')
insert into Rides (ride_id, user_id, requested_at) values ('13', '52', '2020-6-22')
insert into Rides (ride_id, user_id, requested_at) values ('7', '69', '2020-7-16')
insert into Rides (ride_id, user_id, requested_at) values ('17', '70', '2020-8-25')
insert into Rides (ride_id, user_id, requested_at) values ('20', '81', '2020-11-2')
insert into Rides (ride_id, user_id, requested_at) values ('5', '57', '2020-11-9')
insert into Rides (ride_id, user_id, requested_at) values ('2', '42', '2020-12-9')
insert into Rides (ride_id, user_id, requested_at) values ('11', '68', '2021-1-11')
insert into Rides (ride_id, user_id, requested_at) values ('15', '32', '2021-1-17')
insert into Rides (ride_id, user_id, requested_at) values ('12', '11', '2021-1-19')
insert into Rides (ride_id, user_id, requested_at) values ('14', '18', '2021-1-27')
Truncate table AcceptedRides
insert into AcceptedRides (ride_id, driver_id, ride_distance, ride_duration) values ('10', '10', '63', '38')
insert into AcceptedRides (ride_id, driver_id, ride_distance, ride_duration) values ('13', '10', '73', '96')
insert into AcceptedRides (ride_id, driver_id, ride_distance, ride_duration) values ('7', '8', '100', '28')
insert into AcceptedRides (ride_id, driver_id, ride_distance, ride_duration) values ('17', '7', '119', '68')
insert into AcceptedRides (ride_id, driver_id, ride_distance, ride_duration) values ('20', '1', '121', '92')
insert into AcceptedRides (ride_id, driver_id, ride_distance, ride_duration) values ('5', '7', '42', '101')
insert into AcceptedRides (ride_id, driver_id, ride_distance, ride_duration) values ('2', '4', '6', '38')
insert into AcceptedRides (ride_id, driver_id, ride_distance, ride_duration) values ('11', '8', '37', '43')
insert into AcceptedRides (ride_id, driver_id, ride_distance, ride_duration) values ('15', '8', '108', '82')
insert into AcceptedRides (ride_id, driver_id, ride_distance, ride_duration) values ('12', '8', '38', '34')
insert into AcceptedRides (ride_id, driver_id, ride_distance, ride_duration) values ('14', '1', '90', '74')

Case 2
INSERT INTO Drivers (driver_id, join_date) VALUES
(594, '2020-03-03'),
(671, '2020-08-29'),
(785, '2020-02-11'),
(540, '2020-12-14'),
(83, '2020-05-30'),
(714, '2020-06-13'),
(742, '2020-08-18'),
(857, '2020-04-23'),
(743, '2020-06-11'),
(835, '2020-05-11');

-- Insert data into Rides
INSERT INTO Rides (ride_id, user_id, requested_at) VALUES
(290, 137, '2020-11-17'),
(940, 85, '2020-12-21'),
(611, 40, '2020-12-29'),
(119, 126, '2020-10-06'),
(934, 76, '2020-09-16'),
(844, 117, '2020-07-17'),
(629, 42, '2020-08-24'),
(914, 104, '2020-09-28'),
(312, 136, '2020-05-30'),
(630, 60, '2020-12-19'),
(170, 188, '2020-06-26'),
(486, 145, '2020-12-10'),
(852, 157, '2020-12-13'),
(830, 6, '2020-05-04'),
(17, 99, '2020-02-14'),
(749, 36, '2020-09-27'),
(279, 133, '2020-08-28'),
(135, 161, '2020-12-18'),
(154, 181, '2020-10-07'),
(467, 3, '2020-10-21'),
(905, 58, '2020-11-03'),
(430, 9, '2020-12-22');

-- Insert data into AcceptedRides
INSERT INTO AcceptedRides (ride_id, driver_id, ride_distance, ride_duration) VALUES
(279, 743, 82, 99),
(934, 785, 81, 6),
(749, 835, 22, 74),
(654, 742, 8, 17),
(914, 671, 97, 93),
(170, 594, 82, 41),
(629, 83, 39, 79),
(154, 83, 60, 57),
(630, 540, 20, 38),
(467, 742, 34, 63),
(486, 83, 60, 76),
(830, 785, 59, 60),
(312, 83, 17, 46),
(611, 671, 119, 24),
(135, 540, 73, 109),
(430, 857, 110, 12),
(17, 785, 62, 77),
(905, 835, 129, 28),
(852, 594, 3, 76),
(940, 714, 20, 24),
(119, 742, 16, 39);

Hash Tags -
#leetcode
#leetcodesolutions
#leetcodequestionandanswers
#leetcodesql
#sql
#postgres
#postgresql
#leetcodethehardway
#hardquestion
#1635
#Hopper_Compan_Queries_I
#tutorial