总想left join 将后面两个表连起来,半天劲都没写出来 select d1.course_id, t.course_name, round((d2.ten/d1.nums)*100,2) from ( select &nb...