徐李帅

摘要： SELECT bd.device_no AS 设备编号, SUM(IFNULL(bu.amount,0)) as 总营收, SUM(CASE WHEN bu.is_online = 0 THEN bu.amount ELSE 0 END) as 线上, SUM(CASE WHEN bu.is_online = 1 THEN bu.amount ELSE 0 END) as 线下 FROM... 阅读全文