[Solved] How to calculate with multiple value in SQL [closed]

SELECT fname,CASE WHEN fname="A" THEN budget/2
                  WHEN fname="B" THEN budget/4
                  WHEN fname="C" THEN budget/6
             END
FROM tableName