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