drop table if exists t1;
create table t1(a decimal(10,3))engine=myisam;
select t1.a,


 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,0)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,
 if((round(t1.a,2)=1), 2,0))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
as r1 from t1;