You need to remove
'
, if a field stores numeric data or function (month, year) returns numeric values.
Plase, have a look at this:
SELECT distinct r.rate as Rate,
f.bthid as Batchid,
CASE WHEN r.rate = 1 THEN 100
WHEN r.rate = 2 THEN 75
WHEN r.rate = 3 THEN 50
WHEN r.rate = 4 THEN 25
ELSE 0
END AS Translated_Rate
FROM bthfac AS f,batch AS b, faculty AS fa,facfeedback AS r
WHERE month(b.examdate)= 9 and year(b.examdate)= 2011 and b.bthid=f.bthid
and r.bfid = f.bfid and f.facid = fa.facid and fa.facname = 'C';