小弟 正在进行中 未出茅庐 但知道自己的不足 代码的单一没有技术亮点 求大神指点一二

select *from dates

select  years,
  case 
   when ams='1.1' and years='1991' then '1.1'
   when ams='2.1' and years='1992' then '2.1'
  end as m1,
   case 
   when ams='1.1'and years='1991' then '1.2'
   when ams='2.1' and years='1992' then '2.2'
  end as m2,
     case 
   when ams='1.1'and years='1991' then '1.3'
     when ams='2.1' and years='1992' then '2.3'
  end as m3,
      case 
   when ams='1.1'and years='1991' then '1.4'
     when ams='2.1' and years='1992' then '2.4'
  end as m4


from dates where ams='1.1'or ams='2.1'