$sql="SELECT
d.driver_id,
(SELECT SUM(point) FROM zw_exam_log l WHERE l.member_id =d.driver_id AND l.month =11 AND l.year = 2019 AND l.is_pre_train =0 GROUP BY l.member_id) as cargo_score
FROM
zw_branch_driver AS d";

如何写成TP 的方式