fork(1) download
copy 
  1. >各支店ごとの部
  2. select
  3. 	支店,
  4. 	部,
  5. 	sum(基本給),
  6. 	sum(役職手当),
  7. 	sum((基本給+役職手当)/160*1.2),
  8. 	sum(基本給+役職手当+((基本給+役職手当)/160*1.2))
  9. from
  10. 	給与の支給
  11. group by
  12. 	支店,
  13. 	部
  14. ;
  15.  
  16. >各支店ごとの課
  17. select
  18. 	支店,
  19. 	課,
  20. 	(sum,from省略)
  21. group by
  22. 	支店,
  23. 	課
  24. ;
  25.  
  26. >支店合計
  27. select
  28. 	支店,
  29. 	(sum,from省略)
  30. group by
  31. 	支店
  32. ;
  33.  
  34. >総合計
  35. select
  36. 	(sum,from省略)
  37. ;
Not running #stdin #stdout 0s 0KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
https://ideone.com/TaKMa
language:
SQLite (sqlite 3.27.2)
created:
12 years ago
visibility:
secret

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!