SELECT AVG(Rate), Bfid FROM tablename GROUP BY Bfid
Edit: in case Rate is int, and not decimal, you will have to cast all values to decimal first, in order to be able to return decimal value. Like bellow:
CREATE TABLE #Test (Rate int, Bfid int)
INSERT INTO #Test (Rate, Bfid) VALUES (1, 72)
INSERT INTO #Test (Rate, Bfid) VALUES (2, 72)
INSERT INTO #Test (Rate, Bfid) VALUES (3, 72)
INSERT INTO #Test (Rate, Bfid) VALUES (4, 72)
SELECT AVG(CAST(Rate as decimal)), Bfid
FROM #Test
GROUP BY Bfid
ORDER BY Bfid
DROP TABLE #Test