10000 pass
2018/2/5 GM290140 10000 pass
2018/2/5 GM290144 10000 pass
2018/3/1 GM290923 10000 reject...判断result = 'pass'则为通过,相等则为1,不等则为0,运用求和函数sum()即可求出通过总数。申请总数可以直接运用计数函数count()即可。...② 放款笔数、放款金额 -- 分别使用计数函数count()和求和函数sum()即可。...-5-11","GM310938",6000,"pass"),
("2018-5-25","GM327400",15000,"reject"),
("2018-6-18","GM350939",1000...","GM290140",10000,"pass"),
("2018-3-1","GM290938",10000,"pass"),
("2018-4-17","GM296843",8000,"pass"