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

Question

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

Accepted Answer

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