create table Rentals(rental_id varchar(10), customer_id varchar(10), car_id varchar(10), pickup_date date, return_date date, km_driven int, fare_amount double(10,2));

insert into Rentals values('R100', 'CD10', 'BM12', '12-FEB-2020', '30-MAR-2020', 20, 5500000.00);
insert into Rentals values('R101', 'EF20', 'SW72', '19-JAN-2021', '28-APR-2021', 18, 3500000.00);
insert into Rentals values('R102', 'GH30', 'SZ01', '30-NOV-2020', '03-AUG-2021', 25, 4800000.00);
insert into Rentals values('R103', 'IJ40', 'BL45', '09-SEP-2019', '10-OCT 2020', 16, 7500000.00);
insert into Rentals values('R104', 'KL50', 'AD50', '15-JUL-2004', '26-MAY-2008', 22, 6000000.00);
insert into Rentals values('R105', 'MN60', 'TS23', '20-AUG-2018', '31-DEC-2021', 19, 4000000.00);

select * from Rentals;