Untitled

SELECT CASE WHEN COALESCE('','0T') IN ('AT', '2')  THEN 0.9 WHEN COALESCE('','0T') IN ('T','T0','T1','T2') THEN 0.93 WHEN COALESCE('','0T') IN ('ST') THEN 0.8 WHEN '' = '1' THEN 1 ELSE (1 -(0.1 /  CAST( '2' - 1 AS NUMERIC ) * CAST('' AS NUMERIC )-1)) END AS KPIANO FROM IC_UI WHERE C_IMMOB = '70010127' AND C_UI ='0105'