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