For the most part, you have to include in your group by list every column that is in the select list that is outside of an aggregate expression. So,SELECT fn_chairs.bl_id,
bl.name,
SUM(fn_chairs.frs_score) AS frs_score
FROM fn_chairs
INNER JOIN fl
ON (fl.bl_id = fn_chairs.bl_id AND fl.fl_id = fn_chairs.fl_id)
INNER JOIN bl
ON fn_chairs.bl_id = bl.bl_id
WHERE fl.is_active = 1
GROUP BY
fn_chairs.bl_id,
bl.name