SQL Interview Question - Solution (Part - XVI) |

#sql #education #sqlfunctions #dataanalyst
#sqlinterview #datascience #interview

Here are My profiles that will definitely help your preparation for data analyst or data engineer roles.
Medium:   / mahendraee204  
Github: https://github.com/mahendra204


Here are table create and insert statements:
----------------------------------------------------------------------
create table drivers (driver_id int, name varchar(20))
insert into drivers values (201, 'venkey'), (202, 'mahendra'), (210, 'mahi'),(203, 'maha')

create table riders (rider_id int, name varchar(20))
insert into riders values(10, 'sardar'), (11, 'kishore'),(12, 'dev')

create table trips (trip_id int, rider_id int, driver_id int,pickup_time time, dropoff_time time,fare_amount money, distance int);

insert into trips values
(1, 10, 201, '05:00', '06:30', 240.00, 15),
(2, 11, 202, '06:00', '07:30', 210.00, 12),
(3, 11, 201, '07:00', '08:30', 200.00, 10),
(4, 12, 202, '08:00', '09:30', 500.00, 20),
(5, 12, 203, '10:00', '12:30', 1000.00, 25),
(6, 11, 210, '09:00', '12:30', 750.00, 21);