SQL:SELECT autono,cate1,charge,ctitle,zip,cdateA,on_date,training_type FROM tb_course WHERE cate1 IN (1,5) AND cate2 IN ('58','5,58','57','5,57','59','5,59','60','5,60','61','5,61','232','5,232','381','5,381','46','5,46','47','5,47','185','5,185','395','5,395','5') AND charge = 0 AND ((on_date <= '2019-03-19' AND off_date > '2019-03-19' AND cdateA >= '2019-03-19') OR cdateA = '0000-00-00') ORDER BY (CASE WHEN cdateA = '0000-00-00' THEN 0 ELSE 1 END) DESC,cdateA ASC,autono DESC LIMIT 20
他只用了短短七天下班的時間，學會製做個人網頁以及精準行銷，連續第二、第三月領取獎金。
