fork download
copy 
  1.  
  2.  
  3. CREATE TABLE Table1
  4. 	(`ID` int, `FullDateTime` date, `Flag` int)
  5. ;
  6.  
  7. INSERT INTO Table1
  8. 	(`ID`, `FullDateTime`, `Flag`)
  9. VALUES
  10. 	(88, '2015-02-26 04:30:00', 0),
  11. 	(22, '2015-02-26 04:00:00', 0),
  12. 	(45, '2015-02-26 03:30:00', 1),
  13. 	(25, '2015-02-26 03:00:00', 1),
  14. 	(11, '2015-02-26 02:30:00', 1),
  15. 	(57, '2015-02-26 02:00:00', 1),
  16. 	(15, '2015-02-26 01:30:00', 0),
  17. 	(36, '2015-02-26 01:00:00', 0),
  18. 	(00, '2015-02-26 00:30:00', 0),
  19. 	(47, '2015-02-26 00:00:00', 1),
  20. 	(56, '2015-02-25 23:30:00', 1),
  21. 	(66, '2015-02-25 23:00:00', 1),
  22. 	(27, '2015-02-25 22:30:00', 1),
  23. 	(55, '2015-02-25 22:00:00', 1)
  24. ;
  25.  
  26. select ( count(*) * 30.0 ) / 60.0
  27. from table1 as e
  28. left join table1 as s on time(e.FullDateTime, '-30 MINUTE') = time(s.FullDateTime)
  29. where s.flag = 1 and e.flag = 1
  30. ;
  31.  
  32.  
Success #stdin #stdout 0s 3360KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
3.5
https://ideone.com/bkabOv
language:
SQLite (sqlite 3.27.2)
created:
9 years 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!