fork download
  1. -- Create the Railways table
  2. CREATE TABLE Railways (
  3. TrainID INTEGER PRIMARY KEY,
  4. TrainName TEXT,
  5. DaysRunning TEXT
  6. );
  7.  
  8. -- Insert sample data
  9. INSERT INTO Railways (TrainName, DaysRunning) VALUES
  10. ('Rajdhani Express', 'Monday, Wednesday, Friday'),
  11. ('Garib Rath', 'Monday, Thursday, Saturday'),
  12. ('Shatabdi Express', 'Tuesday, Sunday'),
  13. ('Duronto Express', 'Monday, Friday');
  14.  
  15. -- Query to find trains running on Monday
  16. SELECT TrainName
  17. FROM Railways
  18. WHERE DaysRunning LIKE '%Monday%';
  19.  
Success #stdin #stdout 0s 5320KB
stdin
Standard input is empty
stdout
Rajdhani Express
Garib Rath
Duronto Express