CREATE TABLE Trains (
TrainName VARCHAR(255),
TrainNo INT PRIMARY KEY,
NoOfSeats INT,
CostPerSeat1stAC DECIMAL(10, 2),
CostPerSeat2ndAC DECIMAL(10, 2),
CostPerSeat3rdAC DECIMAL(10, 2),
CostPerSeatSleeper DECIMAL(10, 2),
TrainType VARCHAR(50),
StartingStation VARCHAR(255),
Destination VARCHAR(255),
StartingTime TIME,
ReachingTime TIME
);
INSERT INTO Trains (TrainName, TrainNo, NoOfSeats, CostPerSeat1stAC,
CostPerSeat2ndAC, CostPerSeat3rdAC, CostPerSeatSleeper, TrainType, StartingStation,
Destination, StartingTime, ReachingTime)
VALUES
('Chennai Express', 22663, 800, 2500.00, 1800.00, 1200.00, 800.00, 'Express',
'Chennai', 'Abu Road', '08:00:00', '16:00:00'),
('Ahmedabad Express', 12656, 850, 2600.00, 1900.00, 1300.00, 850.00, 'Express',
'Chennai', 'Ahmedabad', '09:00:00', '18:00:00'),
('Alappuzha Express', 13351, 750, 2400.00, 1700.00, 1100.00, 750.00, 'Express',
'Chennai', 'Alappuzha', '10:00:00', '20:00:00'),
('Andaman Express', 16031, 900, 2700.00, 2000.00, 1400.00, 900.00, 'Express',
'Chennai', 'Jammu Tawi', '11:00:00', '22:00:00'),
('Anuvrat Express', 22632, 800, 2500.00, 1800.00, 1200.00, 800.00, 'Express',
'Madurai', 'Bikaner', '12:00:00', '23:00:00'),
('Bagmati Express', 12577, 850, 2600.00, 1900.00, 1300.00, 850.00, 'Express',
'Darbhanga', 'Mysuru', '13:00:00', '21:00:00'),
('Banaswadi Express', 22602, 750, 2400.00, 1700.00, 1100.00, 750.00, 'Express',
'Sainagar Shirdi', 'Chennai', '14:00:00', '22:00:00'),
('Bangalore Express', 12609, 900, 2700.00, 2000.00, 1400.00, 900.00, 'Express',
'Chennai', 'Bangalore', '15:00:00', '23:30:00'),
('Bhubaneswar Express', 12830, 800, 2500.00, 1800.00, 1200.00, 800.00, 'Express',
'Chennai', 'Bhubaneswar', '16:00:00', '06:00:00'),
('Bilaspur Express', 12852, 850, 2600.00, 1900.00, 1300.00, 850.00, 'Express',
'Chennai', 'Bilaspur', '17:00:00', '04:00:00'),
('Cauvery Express', 16021, 750, 2400.00, 1700.00, 1100.00, 750.00, 'Express',
'Chennai', 'Mysore', '18:00:00', '07:00:00'),
('Cheran Express', 12673, 900, 2700.00, 2000.00, 1400.00, 900.00, 'Express',
'Chennai', 'Coimbatore', '19:00:00', '08:00:00'),
('Coimbatore Express', 12679, 800, 2500.00, 1800.00, 1200.00, 800.00, 'Express',
'Chennai', 'Coimbatore', '20:00:00', '09:00:00'),
('Dadar Express', 11006, 850, 2600.00, 1900.00, 1300.00, 850.00, 'Express',
'Chennai', 'Dadar', '21:00:00', '10:00:00'),
('Dhanbad Express', 13352, 750, 2400.00, 1700.00, 1100.00, 750.00, 'Express',
'Alappuzha', 'Dhanbad', '22:00:00', '11:00:00'),
('Ernakulam Express', 12684, 900, 2700.00, 2000.00, 1400.00, 900.00, 'Express',
'Chennai', 'Ernakulam', '23:00:00', '12:00:00'),
('Ganga Kaveri Express', 12670, 800, 2500.00, 1800.00, 1200.00, 800.00, 'Express',
'Chennai', 'Chhapra', '00:00:00', '13:00:00'),
('Guruvayur Express', 16127, 850, 2600.00, 1900.00, 1300.00, 850.00, 'Express',
'Chennai', 'Guruvayur', '01:00:00', '14:00:00'),
('Hazrat Nizamuddin Express', 12611, 750, 2400.00, 1700.00, 1100.00, 750.00,
'Express', 'Chennai', 'Hazrat Nizamuddin', '02:00:00', '15:00:00'),
('Himsagar Express', 16318, 900, 2700.00, 2000.00, 1400.00, 900.00, 'Express',
'Kanyakumari', 'Shri Mata Vaishno Devi Katra', '03:00:00', '16:00:00'),
('Howrah Express', 12665, 800, 2500.00, 1800.00, 1200.00, 800.00, 'Express',
'Kanniyakumari', 'Howrah', '04:00:00', '17:00:00'),
('Hyderabad Express', 12604, 850, 2600.00, 1900.00, 1300.00, 850.00, 'Express',
'Chennai', 'Hyderabad', '05:00:00', '18:00:00'),
('Indore Express', 19302, 750, 2400.00, 1700.00, 1100.00, 750.00, 'Express',
'Chennai', 'Indore', '06:00:00', '19:00:00'),
('Jabalpur Express', 12192, 900, 2700.00, 2000.00, 1400.00, 900.00, 'Express',
'Chennai', 'Jabalpur', '07:00:00', '20:00:00'),
('Jaipur Express', 12967, 800, 2500.00, 1800.00, 1200.00, 800.00, 'Express',
'Chennai', 'Jaipur', '08:00:00', '21:00:00'),
('Jodhpur Express', 16125, 850, 2600.00, 1900.00, 1300.00, 850.00, 'Express',
'Chennai', 'Jodhpur', '09:00:00', '22:00:00'),
('Kacheguda Express', 12761, 750, 2400.00, 1700.00, 1100.00, 750.00, 'Express',
'Chennai', 'Kacheguda', '10:00:00', '23:00:00'),
('Karaikal Express', 12617, 900, 2700.00, 2000.00, 1400.00, 900.00, 'Express',
'Chennai', 'Karaikal', '11:00:00', '00:00:00');
