質問編集履歴
1
変更
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -34,7 +34,7 @@
|
|
|
34
34
|
|
|
35
35
|
(select SUM(price) from student_payments where area_id = 4) as "京都",
|
|
36
36
|
|
|
37
|
-
ROUND((select SUM(price) from student_payments where area_id = 1) + (select SUM(price) from student_payments where area_id = 2) + (select SUM(price) from student_payments where area_id = 3) + (select SUM(price) from student_payments where area_id = 4)) as "全
|
|
37
|
+
ROUND((select SUM(price) from student_payments where area_id = 1) + (select SUM(price) from student_payments where area_id = 2) + (select SUM(price) from student_payments where area_id = 3) + (select SUM(price) from student_payments where area_id = 4)) as "全支社合計"
|
|
38
38
|
|
|
39
39
|
from
|
|
40
40
|
|