fork download
copy 
  1. -- Create the Railways table
  2. CREATE TABLE Railways (
  3.     TrainID INTEGER PRIMARY KEY,
  4.     TrainName TEXT,
  5.     SourceStation TEXT,
  6.     DestinationStation TEXT,
  7.     DepartureTime TIME,
  8.     ArrivalTime TIME,
  9.     TravelDays TEXT,
  10.     DistanceKM INTEGER,
  11.     Fare DECIMAL(10,2)
  12. );
  13.  
  14. -- Insert sample data
  15. INSERT INTO Railways (TrainID, TrainName, SourceStation, DestinationStation, DepartureTime, ArrivalTime, TravelDays, DistanceKM, Fare) VALUES 
  16. (101, 'Rajdhani Express', 'Delhi', 'Mumbai', '18:00', '08:00', 'Monday, Wednesday, Friday', 1384, 2500.00),
  17. (102, 'Garib Rath', 'Kolkata', 'Bangalore', '20:30', '10:45', 'Monday, Thursday, Saturday', 1950, 1800.00),
  18. (103, 'Shatabdi Express', 'Chennai', 'Hyderabad', '07:00', '14:30', 'Tuesday, Sunday', 650, 1200.00),
  19. (104, 'Duronto Express', 'Mumbai', 'Kolkata', '22:15', '13:20', 'Monday, Friday', 1965, 2700.00);
  20.  
  21. -- Query to find trains running on Monday
  22. SELECT TrainID, TrainName, SourceStation, DestinationStation, DepartureTime, ArrivalTime, TravelDays, DistanceKM, Fare
  23. FROM Railways 
  24. WHERE TravelDays LIKE '%Monday%';
  25.  
Success #stdin #stdout 0.01s 5304KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
101|Rajdhani Express|Delhi|Mumbai|18:00|08:00|Monday, Wednesday, Friday|1384|2500
102|Garib Rath|Kolkata|Bangalore|20:30|10:45|Monday, Thursday, Saturday|1950|1800
104|Duronto Express|Mumbai|Kolkata|22:15|13:20|Monday, Friday|1965|2700
https://ideone.com/5Ng2XR
language:
SQLite (sqlite 3.27.2)
created:
11 days ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!