LeetCode SQL Medium

Currently Playing: Leetcode MEDIUM 3166 - Parking Fees & Duration - Solved & Explained by Everyday Data Science

Question: https://leetcode.com/problems/calculate-parking-fees-and-duration/description/ SQL schema: CREATE TABLE If not exists ParkingTransactions ( lot_id INT, car_id INT, entry_time DATETIME, exit_time DATETIME, fee_paid DECIMAL(10, 2) ) Truncate table ParkingTransactions insert into ParkingTransactions (lot_id, car_id, entry_time, exit_time, fee_paid) values ('1', '1001', '2023-06-01 08:00:00', '2023-06-01 10:30:00', '5.0') insert into ParkingTransactions (lot_id, car_id, entry_time, exit_time, fee_paid) values ('1', '1001', '2023-06-02 11:00:00', '2023-06-02 12:45:00', '3.0') insert into ParkingTransactions (lot_id, car_id, entry_time, exit_time, fee_paid) values ('2', '1001', '2023-06-01 10:45:00', '2023-06-01 12:00:00', '6.0') insert into ParkingTransactions (lot_id, car_id, entry_time, exit_time, fee_paid) values ('2', '1002', '2023-06-01 09:00:00', '2023-06-01 11:30:00', '4.0') insert into ParkingTransactions (lot_id, car_id, entry_time, exit_time, fee_paid) values ('3', '1001', '2023-06-03 07:00:00', '2023-06-03 09:00:00', '4.0') insert into ParkingTransactions (lot_id, car_id, entry_time, exit_time, fee_paid) values ('3', '1002', '2023-06-02 12:00:00', '2023-06-02 14:00:00', '2.0') Pandas Schema: data = [[1, 1001, '2023-06-01 08:00:00', '2023-06-01 10:30:00', 5.0], [1, 1001, '2023-06-02 11:00:00', '2023-06-02 12:45:00', 3.0], [2, 1001, '2023-06-01 10:45:00', '2023-06-01 12:00:00', 6.0], [2, 1002, '2023-06-01 09:00:00', '2023-06-01 11:30:00', 4.0], [3, 1001, '2023-06-03 07:00:00', '2023-06-03 09:00:00', 4.0], [3, 1002, '2023-06-02 12:00:00', '2023-06-02 14:00:00', 2.0]] parking_transactions = pd.DataFrame(data, columns=['lot_id', 'car_id', 'entry_time', 'exit_time', 'fee_paid']).astype({ 'lot_id': 'Int64', 'car_id': 'Int64', 'entry_time': 'datetime64[ns]', 'exit_time': 'datetime64[ns]', 'fee_paid': 'float64' }) #leetcodesolutions #leetcode #datascience