UPDATE bb_team_finances f
SET league_today_revenue = league_today_revenue + (
    SELECT  CASE
        WHEN m.playoff_status = 'SIX PLACE' THEN s.league_revenue_of_6th_team
                WHEN m.playoff_status = 'WILD CARD GAME' THEN s.league_revenue_of_wild_card
        WHEN m.playoff_status = 'DIVISION SERIES' THEN s.league_revenue_of_division_series
        WHEN m.playoff_status = 'SEMI-FINAL' THEN s.league_revenue_of_semi_final
        WHEN m.playoff_status = 'CHAMPION' THEN s.league_revenue_of_champion
        WHEN m.playoff_status = 'FINAL' THEN s.league_final_revenue
                ELSE s.league_revenue_of_the_rest
        END
    FROM bb_level_settings s
        JOIN bb_manager m ON s.level = m.level
    WHERE m.bb_team_info_id = f.bb_team_info_id)