fork download 
  1. create table EventTable
  2. (
  3. 	id int,
  4. 	dayofweek int,
  5. 	numevents int
  6. );
  7.  
  8. insert into EventTable values(1, 1, 100);
  9. insert into EventTable values(1, 2, 200);
  10. insert into EventTable values(1, 3, 300);
  11. insert into EventTable values(1, 4, 400);
  12. insert into EventTable values(1, 5, 500);
  13. insert into EventTable values(1, 6, 600);
  14. insert into EventTable values(1, 6, 700);
  15.  
  16. insert into EventTable values(2, 1, 100);
  17. insert into EventTable values(2, 2, 200);
  18. insert into EventTable values(2, 3, 300);
  19. insert into EventTable values(2, 4, 400);
  20. insert into EventTable values(2, 5, 500);
  21. insert into EventTable values(2, 6, 600);
  22. insert into EventTable values(2, 6, 700);
  23.  
  24. select id, 
  25. 	   SUM(case when dayofweek = 1 then numevents else 0 end) as Day1Events,
  26. 	   SUM(case when dayofweek = 2 then numevents else 0 end) as Day2Events,
  27. 	   SUM(case when dayofweek = 3 then numevents else 0 end) as Day3Events
  28. FROM EventTable
  29. GROUP BY ID;
  30.  
Success #stdin #stdout 0s 2964KB
comments (?)
stdin 
Standard input is empty
stdout 
1|100|200|300
2|100|200|300
https://ideone.com/Oca4G9
language:
SQLite (sqlite 3.27.2)
created:
11 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!