SELECT a.loginid as logid,
sum(IF(a.courseid = 30, a.watchtime, 0)) AS '公共基础',
sum(IF(a.courseid = 31, a.watchtime, 0)) AS '道路工程',
sum(IF(a.courseid = 32, a.watchtime, 0)) AS '交通工程',
sum(IF(a.courseid = 33, a.watchtime, 0)) AS '桥隧工程',
sum(IF(a.courseid = 34, a.watchtime, 0)) AS '水运材料'
FROM line_on a GROUP BY loginid
表1 :根据上面的SQL得出的结果。
现在有一个表2 :
表2的course与表1的courseid对应,需要表1的watchtime结果除以表2的classhour,求占比。
怎么实现呢?