金额合计怎么添加语句

Question

我想做一个门诊，住院，体检的金额合计怎么添加语句麻烦各位看一下

Answer 1

该回答引用ChatGPT
请测试后没问题再使用

SELECT 
    d.group_name AS 小组名称,
    SUM(CASE WHEN d.patienttype = '住院' THEN d.price ELSE 0 END) AS 住院收入,
    SUM(CASE WHEN d.patienttype = '门诊' THEN d.price ELSE 0 END) AS 门诊收入,
    SUM(CASE WHEN d.patienttype = '体检' THEN d.price ELSE 0 END) AS 体检收入
FROM 
    lis_test_reg a, lis_group c, lis_patienttyped b, lis_doctor e, lis_test d 
WHERE 
    a.groupcode = c.group_id 
    AND a.doctorid = e.doctor_id 
    AND a.testid = d.test_id 
    AND d.patienttypeid = b.patienttype_id 
    AND a.getsampledate >= to_date('2023/2/1 00:00:00', 'yyyy-mm-dd hh24:mi:ss') 
    AND a.getsampledate <= to_date('2023/2/17 23:59:59', 'yyyy-mm-dd hh24:mi:ss') 
GROUP BY 
    d.group_name;