
(一)、根据teacher_no统计星期的上课数
— 解法一 SELECT t1.teacher_no, (CASE WEEK WHEN ‘1’ THEN keshu ELSE 0 END ) 礼拜一, &...
— 解法一 SELECT t1.teacher_no, (CASE WEEK WHEN ‘1’ THEN keshu ELSE 0 END ) 礼拜一, &...
— 解法一 SELECT t1.teacher_no, (CASE WEEK WHEN ’1’ THEN keshu ELSE 0 END ) 礼拜一, &...