mysql::SQLでcase文を初めて使った記念日。

SELECT
 CASE
  WHEN MONTH(rdate)<4 THEN YEAR(rdate)-1 
  WHEN MONTH(rdate)>3 THEN YEAR(rdate)
 END as `年度`


 FROM `dates` WHERE 1