MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Customers(
birth_day date,
first_name varchar(20),
last_name varchar(20),
c_id int,
CONSTRAINT PK_Customers PRIMARY KEY (c_id) );

CREATE TABLE Employees(
birth_day date,
first_name varchar(20),
last_name varchar(20),
e_id int,
CONSTRAINT PK_Employees PRIMARY KEY (e_id) );

CREATE TABLE BusType(
capacity int,
type varchar(20),
CONSTRAINT PK_BusType PRIMARY KEY (type) );

CREATE TABLE BusTrip(
start_time datetime,
route_no int,
type varchar(20),
e_id int,
b_id int,
CONSTRAINT PK_BusTrip PRIMARY KEY (b_id),
CONSTRAINT FK_BusTripType FOREIGN KEY (type) REFERENCES BusType (type),
CONSTRAINT FK_BusTripEmployeeID FOREIGN KEY (e_id) REFERENCES Employees (e_id) );

CREATE TABLE TicketCosts(
cost int,
duration varchar(20),
CONSTRAINT PK_TicketCosts PRIMARY KEY (duration) );

CREATE TABLE CustomerTrip(
from_stop_no int,
to_stop_no int,
b_id int,
c_id int,
PRIMARY KEY CLUSTERED (b_id, c_id),
CONSTRAINT FK_CustomerTripBus FOREIGN KEY (b_id) REFERENCES BusTrip (b_id),
CONSTRAINT FK_CustomerTripCustomers FOREIGN KEY (c_id) REFERENCES Customers (c_id) );
INSERT INTO Customers (birth_day, first_name, last_name, c_id)
VALUES
    ('1990-01-15', 'John', 'Smith', 1),
    ('1995-03-20', 'Alice', 'Smith', 2),
    ('1987-06-10', 'Michael', 'Williams', 3),
    ('1992-09-05', 'Emily', 'Brown', 4),
    ('1985-11-25', 'David', 'Jones', 5),
    ('1991-02-18', 'Sarah', 'Davis', 6),
    ('1988-04-30', 'Matthew', 'Miller', 7),
    ('1997-07-22', 'Olivia', 'Wilson', 8),
    ('1989-10-12', 'Daniel', 'Moore', 9),
    ('1994-12-08', 'Sophia', 'Taylor', 10),
    ('1986-03-15', 'Christopher', 'Anderson', 11),
    ('1993-05-28', 'Emma', 'Thomas', 12),
    ('1996-08-17', 'Andrew', 'Harris', 13),
    ('1984-09-02', 'Ava', 'Clark', 14),
    ('1990-11-11', 'William', 'Lewis', 15),
    ('1987-01-04', 'Mia', 'Robinson', 16),
    ('1995-02-25', 'James', 'Walker', 17),
    ('1988-06-19', 'Lily', 'Hall', 18),
    ('1991-08-14', 'Benjamin', 'Young', 19),
    ('1989-12-31', 'Chloe', 'Allen', 20),
    ('1993-04-06', 'Jacob', 'King', 21),
    ('1986-07-07', 'Grace', 'Scott', 22),
    ('1994-09-29', 'Ethan', 'Green', 23),
    ('1985-10-23', 'Avery', 'Baker', 24),
    ('1992-12-17', 'Sofia', 'Adams', 25);
    
INSERT INTO Employees (birth_day, first_name, last_name, e_id)
VALUES
    ('1990-05-15', 'John', 'Doe', 1),
    ('1985-08-20', 'Jane', 'Smith', 2),
    ('1995-04-10', 'Alice', 'Johnson', 3),
    ('1992-11-10', 'Louise', 'Davies', 4),
    ('1988-12-22', 'Emily', 'Doe', 5);
    
INSERT INTO BusType (capacity,type)
VALUES
    (5,'Small'),
    (6,'Standard'),
    (7,'Doubledecker');

INSERT INTO BusTrip (start_time, route_no, type, e_id, b_id)
VALUES
    ('2020-09-15 08:00:00', 101, 'Small', 1, 1),
    ('2020-11-20 10:30:00', 102, 'Standard', 2, 2),
    ('2020-12-05 11:15:00', 103, 'Doubledecker', 3, 3),
    ('2021-02-10 13:30:00', 104, 'Small', 1, 4),
    ('2021-04-22 08:45:00', 105, 'Standard', 5, 5),
    ('2021-06-15 10:00:00', 101, 'Small', 1, 6),
    ('2021-08-30 11:30:00', 102, 'Doubledecker', 2, 7),
    ('2021-10-10 12:45:00', 103, 'Standard', 3, 8),
    ('2022-01-09 14:00:00', 104, 'Small', 3, 9),
    ('2022-03-18 15:15:00', 105, 'Standard', 5, 10),
    ('2022-05-22 07:30:00', 101, 'Doubledecker', 1, 11),
    ('2022-09-05 09:45:00', 102, 'Small', 4, 12),
    ('2022-10-15 10:15:00', 103, 'Standard', 3, 13),
    ('2022-12-20 12:30:00', 104, 'Doubledecker', 2, 14),
    ('2023-02-25 13:00:00', 105, 'Small', 5, 15),
    ('2023-04-10 14:15:00', 101, 'Standard', 1, 16),
    ('2023-06-15 09:30:00', 102, 'Small', 2, 17),
    ('2023-08-20 11:45:00', 103, 'Doubledecker', 4, 18),
    ('2023-09-03 08:00:00', 101, 'Small', 1, 19),
    ('2023-09-03 09:30:00', 102, 'Standard', 2, 20),
    ('2023-09-03 11:15:00', 103, 'Doubledecker', 3, 21),
    ('2023-09-04 13:30:00', 104, 'Small', 4, 22),
    ('2023-09-05 07:00:00', 101, 'Small', 1, 23),
    ('2023-09-05 15:45:00', 105, 'Standard', 5, 24),
    ('2023-09-07 08:30:00', 102, 'Doubledecker', 2, 25),
    ('2023-09-08 10:15:00', 103, 'Standard', 3, 26),
    ('2023-09-08 12:30:00', 104, 'Small', 4, 27),
    ('2023-09-08 14:45:00', 105, 'Doubledecker', 5, 28),
    ('2023-09-09 09:00:00', 101, 'Standard', 1, 29),
    ('2023-09-09 10:30:00', 102, 'Small', 2, 30),
    ('2023-09-09 12:00:00', 103, 'Doubledecker', 3, 31),
    ('2023-09-09 14:15:00', 104, 'Standard', 4, 32),
    ('2023-09-09 16:30:00', 105, 'Small', 5, 33),
    ('2023-09-11 07:45:00', 101, 'Doubledecker', 1, 34),
    ('2023-09-11 09:15:00', 102, 'Standard', 2, 35),
    ('2023-09-11 11:00:00', 103, 'Small', 3, 36),
    ('2023-09-11 13:15:00', 104, 'Doubledecker', 4, 37),
    ('2023-09-11 15:30:00', 105, 'Standard', 5, 38),
    ('2023-09-12 08:45:00', 101, 'Small', 1, 39),
    ('2023-09-12 10:15:00', 102, 'Doubledecker', 2, 40),
    ('2023-09-12 11:45:00', 103, 'Standard', 3, 41),
    ('2023-09-12 14:00:00', 104, 'Small', 4, 42),
    ('2023-09-12 16:15:00', 105, 'Doubledecker', 5, 43),
    ('2023-09-13 10:30:00', 102, 'Small', 2, 44),
    ('2023-09-13 12:00:00', 103, 'Doubledecker', 3, 45),
    ('2023-09-13 14:15:00', 104, 'Standard', 4, 46),    
    ('2023-09-14 07:00:00', 101, 'Small', 1, 47),
    ('2023-09-14 15:45:00', 105, 'Standard', 5, 48),
    ('2023-09-15 09:00:00', 101, 'Standard', 1, 49),
    ('2023-09-15 10:30:00', 102, 'Small', 2, 50),
    ('2023-09-15 12:00:00', 103, 'Doubledecker', 3, 51),
    ('2023-09-15 14:15:00', 104, 'Standard', 4, 52),
    ('2023-09-15 16:30:00', 105, 'Small', 5, 53),
    ('2023-09-16 13:30:00', 104, 'Small', 4, 54),
    ('2023-09-17 07:00:00', 101, 'Small', 1, 55),
    ('2023-09-18 15:45:00', 105, 'Standard', 5, 56),
    ('2023-09-20 08:30:00', 102, 'Doubledecker', 2, 57),
    ('2023-10-05 14:30:00', 105, 'Small', 4, 58);

INSERT INTO TicketCosts (cost,duration)
VALUES
    (200,'Single'),
    (500,'Day'),
    (1600,'Week');

INSERT INTO CustomerTrip (from_stop_no, to_stop_no, b_id, c_id)
VALUES
    (7, 8, 7, 1),
    (6, 9, 11, 1),
    (3, 4, 14, 1),
    (3, 4, 20, 1),
    (1, 6, 28, 1),
    (4, 9, 35, 1),
    (5, 6, 36, 1),
    (3, 6, 37, 1),
    (3, 6, 42, 1),
    (1, 7, 45, 1),
    (5, 9, 50, 1),
    (6, 8, 55, 1),
    (4, 8, 57, 1),
    (3, 8, 9, 2),
    (5, 8, 13, 2),
    (3, 9, 18, 2),
    (1, 6, 24, 2),
    (5, 9, 26, 2),
    (3, 7, 31, 2),
    (1, 6, 32, 2),
    (3, 6, 33, 2),
    (5, 6, 37, 2),
    (5, 7, 55, 2),
    (2, 3, 58, 2),
    (1, 4, 5, 3),
    (4, 9, 7, 3),
    (4, 9, 15, 3),
    (2, 8, 18, 3),
    (1, 6, 33, 3),
    (3, 6, 34, 3),
    (5, 7, 38, 3),
    (1, 5, 43, 3),
    (4, 6, 45, 3),
    (5, 8, 49, 3),
    (6, 9, 50, 3),
    (4, 6, 51, 3),
    (1, 2, 53, 3),
    (3, 6, 55, 3),
    (2, 5, 6, 4),
    (5, 9, 8, 4),
    (3, 7, 14, 4),
    (2, 9, 29, 4),
    (1, 4, 37, 4),
    (1, 3, 43, 4),
    (3, 9, 44, 4),
    (7, 9, 46, 4),
    (2, 3, 56, 4),
    (3, 4, 57, 4),
    (2, 7, 2, 5),
    (5, 7, 3, 5),
    (1, 9, 5, 5),
    (4, 7, 12, 5),
    (3, 9, 18, 5),
    (6, 8, 32, 5),
    (1, 8, 38, 5),
    (1, 3, 42, 5),
    (2, 5, 3, 6),
    (1, 5, 4, 6),
    (2, 4, 6, 6),
    (2, 3, 12, 6),
    (1, 2, 16, 6),
    (7, 8, 18, 6),
    (1, 2, 23, 6),
    (2, 3, 30, 6),
    (6, 7, 34, 6),
    (2, 8, 36, 6),
    (2, 4, 49, 6),
    (5, 8, 51, 6),
    (1, 5, 58, 6),
    (6, 9, 3, 7),
    (3, 8, 5, 7),
    (3, 4, 8, 7),
    (1, 7, 11, 7),
    (2, 9, 12, 7),
    (2, 5, 21, 7),
    (1, 2, 23, 7),
    (1, 8, 27, 7),
    (1, 3, 40, 7),
    (4, 7, 44, 7),
    (6, 8, 46, 7),
    (2, 7, 52, 7),
    (4, 7, 8, 8),
    (6, 7, 11, 8),
    (1, 2, 25, 8),
    (3, 5, 27, 8),
    (2, 7, 28, 8),
    (4, 9, 32, 8),
    (1, 7, 44, 8),
    (1, 3, 52, 8),
    (2, 3, 2, 9),
    (3, 4, 5, 9),
    (8, 9, 11, 9),
    (1, 2, 12, 9),
    (2, 4, 14, 9),
    (5, 6, 18, 9),
    (5, 9, 25, 9),
    (1, 5, 27, 9),
    (6, 7, 30, 9),
    (3, 9, 42, 9),
    (3, 8, 47, 9),
    (5, 6, 58, 9),
    (1, 3, 1, 10),
    (6, 8, 4, 10),
    (6, 8, 13, 10),
    (1, 7, 14, 10),
    (5, 8, 25, 10),
    (1, 5, 30, 10),
    (2, 8, 33, 10),
    (1, 2, 44, 10),
    (4, 7, 50, 10),
    (2, 9, 55, 10),
    (6, 7, 1, 11),
    (4, 5, 2, 11),
    (3, 7, 3, 11),
    (1, 5, 7, 11),
    (1, 3, 10, 11),
    (4, 8, 12, 11),
    (1, 3, 22, 11),
    (2, 5, 25, 11),
    (3, 9, 26, 11),
    (2, 4, 27, 11),
    (2, 8, 28, 11),
    (1, 5, 29, 11),
    (2, 9, 30, 11),
    (1, 3, 34, 11),
    (1, 4, 36, 11),
    (8, 9, 40, 11),
    (5, 6, 42, 11),
    (6, 9, 44, 11),
    (5, 8, 47, 11),
    (3, 5, 48, 11),
    (5, 6, 55, 11),
    (5, 8, 57, 11),
    (3, 7, 4, 12),
    (5, 6, 6, 12),
    (4, 8, 11, 12),
    (5, 6, 12, 12),
    (1, 6, 15, 12),
    (3, 9, 16, 12),
    (1, 4, 21, 12),
    (5, 7, 28, 12),
    (3, 8, 37, 12),
    (6, 9, 43, 12),
    (3, 6, 44, 12),
    (6, 8, 50, 12),
    (8, 9, 58, 12),
    (3, 6, 3, 13),
    (4, 6, 17, 13),
    (1, 9, 24, 13),
    (6, 8, 27, 13),
    (5, 6, 36, 13),
    (6, 8, 49, 13),
    (7, 8, 55, 13),
    (6, 8, 57, 13),
    (3, 8, 1, 14),
    (4, 9, 3, 14),
    (5, 7, 4, 14),
    (2, 9, 10, 14),
    (8, 9, 14, 14),
    (1, 6, 15, 14),
    (5, 7, 18, 14),
    (1, 8, 19, 14),
    (3, 6, 20, 14),
    (7, 9, 23, 14),
    (7, 8, 27, 14),
    (5, 9, 28, 14),
    (2, 9, 29, 14),
    (3, 8, 30, 14),
    (1, 3, 33, 14),
    (2, 4, 34, 14),
    (7, 8, 39, 14),
    (2, 4, 41, 14),
    (3, 6, 42, 14),
    (3, 8, 43, 14),
    (5, 7, 49, 14),
    (2, 9, 51, 14),
    (3, 6, 54, 14),
    (1, 4, 56, 14),
    (3, 5, 57, 14),
    (2, 6, 2, 15),
    (5, 9, 3, 15),
    (4, 5, 7, 15),
    (1, 3, 8, 15),
    (1, 7, 9, 15),
    (4, 9, 12, 15),
    (6, 8, 14, 15),
    (2, 6, 16, 15),
    (1, 4, 21, 15),
    (1, 4, 23, 15),
    (7, 9, 24, 15),
    (5, 7, 26, 15),
    (6, 8, 28, 15),
    (4, 5, 41, 15),
    (4, 9, 45, 15),
    (4, 7, 47, 15),
    (4, 7, 54, 15),
    (3, 4, 55, 15),
    (3, 4, 56, 15),
    (1, 3, 3, 16),
    (2, 9, 10, 16),
    (6, 7, 17, 16),
    (4, 5, 44, 16),
    (5, 9, 55, 16),
    (2, 6, 4, 17),
    (2, 7, 5, 17),
    (5, 6, 9, 17),
    (3, 7, 10, 17),
    (6, 7, 12, 17),
    (4, 9, 14, 17),
    (3, 6, 17, 17),
    (5, 8, 19, 17),
    (2, 4, 20, 17),
    (1, 8, 21, 17),
    (1, 6, 22, 17),
    (4, 8, 24, 17),
    (1, 3, 26, 17),
    (5, 8, 27, 17),
    (6, 8, 28, 17),
    (3, 9, 29, 17),
    (2, 3, 30, 17),
    (4, 8, 31, 17),
    (7, 8, 36, 17),
    (4, 7, 38, 17),
    (2, 8, 39, 17),
    (3, 7, 42, 17),
    (7, 9, 43, 17),
    (2, 7, 44, 17),
    (1, 4, 47, 17),
    (3, 8, 50, 17),
    (1, 2, 55, 17),
    (1, 7, 57, 17),
    (1, 4, 14, 18),
    (3, 7, 20, 18),
    (2, 9, 33, 18),
    (5, 9, 34, 18),
    (3, 7, 38, 18),
    (3, 6, 41, 18),
    (3, 4, 44, 18),
    (4, 5, 47, 18),
    (2, 9, 50, 18),
    (2, 6, 52, 18),
    (1, 5, 54, 18),
    (6, 9, 3, 19),
    (6, 9, 18, 19),
    (7, 8, 25, 19),
    (3, 6, 34, 19),
    (5, 8, 49, 19),
    (6, 7, 50, 19),
    (5, 9, 7, 20),
    (2, 3, 9, 20),
    (1, 5, 11, 20),
    (2, 4, 13, 20),
    (1, 5, 25, 20),
    (4, 7, 26, 20),
    (2, 4, 27, 20),
    (3, 7, 28, 20),
    (6, 9, 29, 20),
    (2, 5, 32, 20),
    (1, 4, 33, 20),
    (2, 7, 36, 20),
    (2, 6, 37, 20),
    (2, 9, 38, 20),
    (2, 9, 41, 20),
    (3, 9, 43, 20),
    (2, 3, 44, 20),
    (2, 9, 49, 20),
    (3, 5, 51, 20),
    (1, 7, 53, 20),
    (1, 9, 54, 20),
    (6, 9, 56, 20),
    (3, 5, 58, 20),
    (7, 8, 7, 21),
    (2, 8, 8, 21),
    (1, 7, 27, 21),
    (2, 5, 35, 21),
    (2, 7, 40, 21),
    (3, 7, 43, 21),
    (3, 7, 49, 21),
    (5, 9, 54, 21),
    (1, 7, 56, 21),
    (1, 9, 57, 21),
    (2, 5, 58, 21),
    (2, 4, 2, 22),
    (7, 9, 14, 22),
    (1, 3, 17, 22),
    (7, 9, 18, 22),
    (6, 7, 19, 22),
    (1, 7, 24, 22),
    (3, 5, 25, 22),
    (4, 5, 27, 22),
    (2, 8, 28, 22),
    (6, 8, 29, 22),
    (4, 5, 33, 22),
    (2, 6, 35, 22),
    (5, 9, 42, 22),
    (2, 6, 44, 22),
    (4, 6, 45, 22),
    (4, 9, 49, 22),
    (4, 5, 51, 22),
    (1, 6, 53, 22),
    (3, 9, 1, 23),
    (6, 7, 7, 23),
    (2, 9, 10, 23),
    (2, 8, 13, 23),
    (2, 5, 18, 23),
    (3, 7, 24, 23),
    (2, 8, 27, 23),
    (5, 7, 31, 23),
    (5, 8, 46, 23),
    (1, 6, 48, 23),
    (4, 9, 50, 23),
    (6, 9, 6, 24),
    (3, 6, 7, 24),
    (1, 4, 8, 24),
    (2, 3, 9, 24),
    (2, 7, 10, 24),
    (1, 9, 11, 24),
    (5, 9, 13, 24),
    (5, 9, 15, 24),
    (6, 8, 20, 24),
    (5, 9, 31, 24),
    (4, 5, 32, 24),
    (5, 6, 33, 24),
    (7, 9, 34, 24),
    (1, 3, 35, 24),
    (1, 3, 39, 24),
    (3, 9, 48, 24),
    (6, 7, 56, 24),
    (5, 6, 57, 24),
    (5, 9, 4, 25),
    (4, 6, 6, 25),
    (4, 6, 7, 25),
    (4, 7, 10, 25),
    (2, 6, 14, 25),
    (8, 9, 21, 25),
    (2, 7, 22, 25),
    (1, 6, 24, 25),
    (1, 2, 25, 25),
    (2, 6, 26, 25),
    (3, 9, 27, 25),
    (2, 3, 28, 25),
    (7, 8, 29, 25),
    (1, 5, 30, 25),
    (6, 7, 34, 25),
    (6, 7, 35, 25),
    (7, 8, 36, 25),
    (5, 9, 37, 25),
    (2, 8, 43, 25),
    (2, 9, 46, 25),
    (6, 8, 47, 25),
    (3, 7, 48, 25),
    (5, 7, 50, 25),
    (1, 6, 51, 25),
    (6, 7, 58, 25);

Records: 25  Duplicates: 0  Warnings: 0



Records: 5  Duplicates: 0  Warnings: 0



Records: 3  Duplicates: 0  Warnings: 0



Records: 58  Duplicates: 0  Warnings: 0



Records: 3  Duplicates: 0  Warnings: 0



Records: 354  Duplicates: 0  Warnings: 0


SELECT ct.c_id, DATE(bt.start_time) AS date,
   tc.duration , trip_count, tc.cost
      
  
FROM CustomerTrip ct JOIN BusTrip bt ON ct.b_id = bt.b_id
JOIN TicketCosts tc ON tc.duration IN ('Single', 'Day')
JOIN(
	SELECT
		b_id,
		DATE(start_time) AS trip_date,
		COUNT(*) AS trip_count
	FROM BusTrip GROUP BY b_id, DATE(start_time)) 
	trip_counts ON ct.b_id = trip_counts.b_id AND DATE(bt.start_time) = trip_counts.trip_date

  WHERE c_id = 1
and  DATE(bt.start_time)  = '2023-09-11'


c_id
date
duration
trip_count
cost


1
2023-09-11
Day
1
500

1
2023-09-11
Day
1
500

1
2023-09-11
Day
1
500

1
2023-09-11
Single
1
200

1
2023-09-11
Single
1
200

1
2023-09-11
Single
1
200


SELECT ct.c_id, DATE(bt.start_time) AS date, 
  CASE
    WHEN count(*) = 1 THEN (SELECT cost FROM TicketCosts WHERE duration = 'Single')
    WHEN count(*) = 2 THEN (SELECT cost FROM TicketCosts WHERE duration = 'Single') * 2
    ELSE (SELECT cost FROM TicketCosts WHERE duration = 'Day')
  END AS cost
FROM CustomerTrip ct
JOIN BusTrip bt ON ct.b_id = bt.b_id
GROUP BY ct.c_id, DATE(bt.start_time) order by c_id;


c_id
date
cost


1
2021-08-30
200

1
2022-05-22
200

1
2022-12-20
200

1
2023-09-03
200

1
2023-09-08
200

1
2023-09-11
500

1
2023-09-12
200

1
2023-09-13
200

1
2023-09-15
200

1
2023-09-17
200

1
2023-09-20
200

2
2022-01-09
200

2
2022-10-15
200

2
2023-08-20
200

2
2023-09-05
200

2
2023-09-08
200

2
2023-09-09
500

2
2023-09-11
200

2
2023-09-17
200

2
2023-10-05
200

3
2021-04-22
200

3
2021-08-30
200

3
2023-02-25
200

3
2023-08-20
200

3
2023-09-09
200

3
2023-09-11
400

3
2023-09-12
200

3
2023-09-13
200

3
2023-09-15
500

3
2023-09-17
200

4
2021-06-15
200

4
2021-10-10
200

4
2022-12-20
200

4
2023-09-09
200

4
2023-09-11
200

4
2023-09-12
200

4
2023-09-13
400

4
2023-09-18
200

4
2023-09-20
200

5
2020-11-20
200

5
2020-12-05
200

5
2021-04-22
200

5
2022-09-05
200

5
2023-08-20
200

5
2023-09-09
200

5
2023-09-11
200

5
2023-09-12
200

6
2020-12-05
200

6
2021-02-10
200

6
2021-06-15
200

6
2022-09-05
200

6
2023-04-10
200

6
2023-08-20
200

6
2023-09-05
200

6
2023-09-09
200

6
2023-09-11
400

6
2023-09-15
400

6
2023-10-05
200

7
2020-12-05
200

7
2021-04-22
200

7
2021-10-10
200

7
2022-05-22
200

7
2022-09-05
200

7
2023-09-03
200

7
2023-09-05
200

7
2023-09-08
200

7
2023-09-12
200

7
2023-09-13
400

7
2023-09-15
200

8
2021-10-10
200

8
2022-05-22
200

8
2023-09-07
200

8
2023-09-08
400

8
2023-09-09
200

8
2023-09-13
200

8
2023-09-15
200

9
2020-11-20
200

9
2021-04-22
200

9
2022-05-22
200

9
2022-09-05
200

9
2022-12-20
200

9
2023-08-20
200

9
2023-09-07
200

9
2023-09-08
200

9
2023-09-09
200

9
2023-09-12
200

9
2023-09-14
200

9
2023-10-05
200

10
2020-09-15
200

10
2021-02-10
200

10
2022-10-15
200

10
2022-12-20
200

10
2023-09-07
200

10
2023-09-09
400

10
2023-09-13
200

10
2023-09-15
200

10
2023-09-17
200

11
2020-09-15
200

11
2020-11-20
200

11
2020-12-05
200

11
2021-08-30
200

11
2022-03-18
200

11
2022-09-05
200

11
2023-09-04
200

11
2023-09-07
200

11
2023-09-08
500

11
2023-09-09
400

11
2023-09-11
400

11
2023-09-12
400

11
2023-09-13
200

11
2023-09-14
400

11
2023-09-17
200

11
2023-09-20
200

12
2021-02-10
200

12
2021-06-15
200

12
2022-05-22
200

12
2022-09-05
200

12
2023-02-25
200

12
2023-04-10
200

12
2023-09-03
200

12
2023-09-08
200

12
2023-09-11
200

12
2023-09-12
200

12
2023-09-13
200

12
2023-09-15
200

12
2023-10-05
200

13
2020-12-05
200

13
2023-06-15
200

13
2023-09-05
200

13
2023-09-08
200

13
2023-09-11
200

13
2023-09-15
200

13
2023-09-17
200

13
2023-09-20
200

14
2020-09-15
200

14
2020-12-05
200

14
2021-02-10
200

14
2022-03-18
200

14
2022-12-20
200

14
2023-02-25
200

14
2023-08-20
200

14
2023-09-03
400

14
2023-09-05
200

14
2023-09-08
400

14
2023-09-09
500

14
2023-09-11
200

14
2023-09-12
500

14
2023-09-15
400

14
2023-09-16
200

14
2023-09-18
200

14
2023-09-20
200

15
2020-11-20
200

15
2020-12-05
200

15
2021-08-30
200

15
2021-10-10
200

15
2022-01-09
200

15
2022-09-05
200

15
2022-12-20
200

15
2023-04-10
200

15
2023-09-03
200

15
2023-09-05
400

15
2023-09-08
400

15
2023-09-12
200

15
2023-09-13
200

15
2023-09-14
200

15
2023-09-16
200

15
2023-09-17
200

15
2023-09-18
200

16
2020-12-05
200

16
2022-03-18
200

16
2023-06-15
200

16
2023-09-13
200

16
2023-09-17
200

17
2021-02-10
200

17
2021-04-22
200

17
2022-01-09
200

17
2022-03-18
200

17
2022-09-05
200

17
2022-12-20
200

17
2023-06-15
200

17
2023-09-03
500

17
2023-09-04
200

17
2023-09-05
200

17
2023-09-08
500

17
2023-09-09
500

17
2023-09-11
400

17
2023-09-12
500

17
2023-09-13
200

17
2023-09-14
200

17
2023-09-15
200

17
2023-09-17
200

17
2023-09-20
200

18
2022-12-20
200

18
2023-09-03
200

18
2023-09-09
200

18
2023-09-11
400

18
2023-09-12
200

18
2023-09-13
200

18
2023-09-14
200

18
2023-09-15
400

18
2023-09-16
200

19
2020-12-05
200

19
2023-08-20
200

19
2023-09-07
200

19
2023-09-11
200

19
2023-09-15
400

20
2021-08-30
200

20
2022-01-09
200

20
2022-05-22
200

20
2022-10-15
200

20
2023-09-07
200

20
2023-09-08
500

20
2023-09-09
500

20
2023-09-11
500

20
2023-09-12
400

20
2023-09-13
200

20
2023-09-15
500

20
2023-09-16
200

20
2023-09-18
200

20
2023-10-05
200

21
2021-08-30
200

21
2021-10-10
200

21
2023-09-08
200

21
2023-09-11
200

21
2023-09-12
400

21
2023-09-15
200

21
2023-09-16
200

21
2023-09-18
200

21
2023-09-20
200

21
2023-10-05
200

22
2020-11-20
200

22
2022-12-20
200

22
2023-06-15
200

22
2023-08-20
200

22
2023-09-03
200

22
2023-09-05
200

22
2023-09-07
200

22
2023-09-08
400

22
2023-09-09
400

22
2023-09-11
200

22
2023-09-12
200

22
2023-09-13
400

22
2023-09-15
500

23
2020-09-15
200

23
2021-08-30
200

23
2022-03-18
200

23
2022-10-15
200

23
2023-08-20
200

23
2023-09-05
200

23
2023-09-08
200

23
2023-09-09
200

23
2023-09-13
200

23
2023-09-14
200

23
2023-09-15
200

24
2021-06-15
200

24
2021-08-30
200

24
2021-10-10
200

24
2022-01-09
200

24
2022-03-18
200

24
2022-05-22
200

24
2022-10-15
200

24
2023-02-25
200

24
2023-09-03
200

24
2023-09-09
500

24
2023-09-11
400

24
2023-09-12
200

24
2023-09-14
200

24
2023-09-18
200

24
2023-09-20
200

25
2021-02-10
200

25
2021-06-15
200

25
2021-08-30
200

25
2022-03-18
200

25
2022-12-20
200

25
2023-09-03
200

25
2023-09-04
200

25
2023-09-05
200

25
2023-09-07
200

25
2023-09-08
500

25
2023-09-09
400

25
2023-09-11
500

25
2023-09-12
200

25
2023-09-13
200

25
2023-09-14
400

25
2023-09-15
400

25
2023-10-05
200

c_id	date	duration	trip_count	cost
1	2023-09-11	Day	1	500
1	2023-09-11	Day	1	500
1	2023-09-11	Day	1	500
1	2023-09-11	Single	1	200
1	2023-09-11	Single	1	200
1	2023-09-11	Single	1	200

c_id	date	cost
1	2021-08-30	200
1	2022-05-22	200
1	2022-12-20	200
1	2023-09-03	200
1	2023-09-08	200
1	2023-09-11	500
1	2023-09-12	200
1	2023-09-13	200
1	2023-09-15	200
1	2023-09-17	200
1	2023-09-20	200
2	2022-01-09	200
2	2022-10-15	200
2	2023-08-20	200
2	2023-09-05	200
2	2023-09-08	200
2	2023-09-09	500
2	2023-09-11	200
2	2023-09-17	200
2	2023-10-05	200
3	2021-04-22	200
3	2021-08-30	200
3	2023-02-25	200
3	2023-08-20	200
3	2023-09-09	200
3	2023-09-11	400
3	2023-09-12	200
3	2023-09-13	200
3	2023-09-15	500
3	2023-09-17	200
4	2021-06-15	200
4	2021-10-10	200
4	2022-12-20	200
4	2023-09-09	200
4	2023-09-11	200
4	2023-09-12	200
4	2023-09-13	400
4	2023-09-18	200
4	2023-09-20	200
5	2020-11-20	200
5	2020-12-05	200
5	2021-04-22	200
5	2022-09-05	200
5	2023-08-20	200
5	2023-09-09	200
5	2023-09-11	200
5	2023-09-12	200
6	2020-12-05	200
6	2021-02-10	200
6	2021-06-15	200
6	2022-09-05	200
6	2023-04-10	200
6	2023-08-20	200
6	2023-09-05	200
6	2023-09-09	200
6	2023-09-11	400
6	2023-09-15	400
6	2023-10-05	200
7	2020-12-05	200
7	2021-04-22	200
7	2021-10-10	200
7	2022-05-22	200
7	2022-09-05	200
7	2023-09-03	200
7	2023-09-05	200
7	2023-09-08	200
7	2023-09-12	200
7	2023-09-13	400
7	2023-09-15	200
8	2021-10-10	200
8	2022-05-22	200
8	2023-09-07	200
8	2023-09-08	400
8	2023-09-09	200
8	2023-09-13	200
8	2023-09-15	200
9	2020-11-20	200
9	2021-04-22	200
9	2022-05-22	200
9	2022-09-05	200
9	2022-12-20	200
9	2023-08-20	200
9	2023-09-07	200
9	2023-09-08	200
9	2023-09-09	200
9	2023-09-12	200
9	2023-09-14	200
9	2023-10-05	200
10	2020-09-15	200
10	2021-02-10	200
10	2022-10-15	200
10	2022-12-20	200
10	2023-09-07	200
10	2023-09-09	400
10	2023-09-13	200
10	2023-09-15	200
10	2023-09-17	200
11	2020-09-15	200
11	2020-11-20	200
11	2020-12-05	200
11	2021-08-30	200
11	2022-03-18	200
11	2022-09-05	200
11	2023-09-04	200
11	2023-09-07	200
11	2023-09-08	500
11	2023-09-09	400
11	2023-09-11	400
11	2023-09-12	400
11	2023-09-13	200
11	2023-09-14	400
11	2023-09-17	200
11	2023-09-20	200
12	2021-02-10	200
12	2021-06-15	200
12	2022-05-22	200
12	2022-09-05	200
12	2023-02-25	200
12	2023-04-10	200
12	2023-09-03	200
12	2023-09-08	200
12	2023-09-11	200
12	2023-09-12	200
12	2023-09-13	200
12	2023-09-15	200
12	2023-10-05	200
13	2020-12-05	200
13	2023-06-15	200
13	2023-09-05	200
13	2023-09-08	200
13	2023-09-11	200
13	2023-09-15	200
13	2023-09-17	200
13	2023-09-20	200
14	2020-09-15	200
14	2020-12-05	200
14	2021-02-10	200
14	2022-03-18	200
14	2022-12-20	200
14	2023-02-25	200
14	2023-08-20	200
14	2023-09-03	400
14	2023-09-05	200
14	2023-09-08	400
14	2023-09-09	500
14	2023-09-11	200
14	2023-09-12	500
14	2023-09-15	400
14	2023-09-16	200
14	2023-09-18	200
14	2023-09-20	200
15	2020-11-20	200
15	2020-12-05	200
15	2021-08-30	200
15	2021-10-10	200
15	2022-01-09	200
15	2022-09-05	200
15	2022-12-20	200
15	2023-04-10	200
15	2023-09-03	200
15	2023-09-05	400
15	2023-09-08	400
15	2023-09-12	200
15	2023-09-13	200
15	2023-09-14	200
15	2023-09-16	200
15	2023-09-17	200
15	2023-09-18	200
16	2020-12-05	200
16	2022-03-18	200
16	2023-06-15	200
16	2023-09-13	200
16	2023-09-17	200
17	2021-02-10	200
17	2021-04-22	200
17	2022-01-09	200
17	2022-03-18	200
17	2022-09-05	200
17	2022-12-20	200
17	2023-06-15	200
17	2023-09-03	500
17	2023-09-04	200
17	2023-09-05	200
17	2023-09-08	500
17	2023-09-09	500
17	2023-09-11	400
17	2023-09-12	500
17	2023-09-13	200
17	2023-09-14	200
17	2023-09-15	200
17	2023-09-17	200
17	2023-09-20	200
18	2022-12-20	200
18	2023-09-03	200
18	2023-09-09	200
18	2023-09-11	400
18	2023-09-12	200
18	2023-09-13	200
18	2023-09-14	200
18	2023-09-15	400
18	2023-09-16	200
19	2020-12-05	200
19	2023-08-20	200
19	2023-09-07	200
19	2023-09-11	200
19	2023-09-15	400
20	2021-08-30	200
20	2022-01-09	200
20	2022-05-22	200
20	2022-10-15	200
20	2023-09-07	200
20	2023-09-08	500
20	2023-09-09	500
20	2023-09-11	500
20	2023-09-12	400
20	2023-09-13	200
20	2023-09-15	500
20	2023-09-16	200
20	2023-09-18	200
20	2023-10-05	200
21	2021-08-30	200
21	2021-10-10	200
21	2023-09-08	200
21	2023-09-11	200
21	2023-09-12	400
21	2023-09-15	200
21	2023-09-16	200
21	2023-09-18	200
21	2023-09-20	200
21	2023-10-05	200
22	2020-11-20	200
22	2022-12-20	200
22	2023-06-15	200
22	2023-08-20	200
22	2023-09-03	200
22	2023-09-05	200
22	2023-09-07	200
22	2023-09-08	400
22	2023-09-09	400
22	2023-09-11	200
22	2023-09-12	200
22	2023-09-13	400
22	2023-09-15	500
23	2020-09-15	200
23	2021-08-30	200
23	2022-03-18	200
23	2022-10-15	200
23	2023-08-20	200
23	2023-09-05	200
23	2023-09-08	200
23	2023-09-09	200
23	2023-09-13	200
23	2023-09-14	200
23	2023-09-15	200
24	2021-06-15	200
24	2021-08-30	200
24	2021-10-10	200
24	2022-01-09	200
24	2022-03-18	200
24	2022-05-22	200
24	2022-10-15	200
24	2023-02-25	200
24	2023-09-03	200
24	2023-09-09	500
24	2023-09-11	400
24	2023-09-12	200
24	2023-09-14	200
24	2023-09-18	200
24	2023-09-20	200
25	2021-02-10	200
25	2021-06-15	200
25	2021-08-30	200
25	2022-03-18	200
25	2022-12-20	200
25	2023-09-03	200
25	2023-09-04	200
25	2023-09-05	200
25	2023-09-07	200
25	2023-09-08	500
25	2023-09-09	400
25	2023-09-11	500
25	2023-09-12	200
25	2023-09-13	200
25	2023-09-14	400
25	2023-09-15	400
25	2023-10-05	200