SELECT (multiple) CASE query doesn't work

SELECT (multiple) CASE query doesn't work

Hi,

I'm really satisfied with Zoho services, finally i've found what i need!, but now, i have got the current problem.

Just imagine Formula 1 scores. When a driver ends in 1st position then scores 10 points. 2nd = 8, 3th = 6... etc

My query only returns the first case, and ignore the other ones.

In my table, column 'Pos' is a Lookup Column.

SELECT Driver, CASE Pos
WHEN Pos = 1 THEN 10
WHEN Pos = 2 THEN 8
WHEN Pos = 3 THEN 6
WHEN Pos = 4 THEN 5
WHEN Pos = 5 THEN 4
WHEN Pos = 6 THEN 3
WHEN Pos = 7 THEN 2
WHEN Pos = 8 THEN 1
END Points FROM GPBahrein

Any idea?

Thanks!