I want a clean, lightweight way to display average company-rating scores for each stock exchange on my WordPress home page. All rating data already lives inside the wpForo plugin, so your code must pull directly from those tables—no external APIs or extra databases. Here’s the flow I picture: • Query wpForo to gather every company that belongs to a given stock exchange (I’ll give you the final exchange list; plan for NYSE, NASDAQ and FTSE for now). • Calculate the average of their stored rating value. • Render one vertical bar per exchange, each in its own graph block, exactly like the mock-up I attached. Values update automatically whenever ratings inside wpForo change. Technical notes – I’m happy with a small custom plugin or shortcode; whichever integrates best with our already busy theme. – The bars must be responsive and inherit our site fonts/colours; a library such as Chart.js or ApexCharts is fine. – Please write efficient SQL that respects heavy traffic, with sensible caching so the chart doesn’t hit the database on every page view. Acceptance criteria 1. Page loads with three vertical bars labelled by exchange, each showing the correct averaged number right above the bar. 2. Changing a rating in wpForo and clearing cache immediately reflects in the graph on refresh. 3. Code is self-contained, documented, and passes a quick security review (no direct user input, prepared statements). 4. I receive installation instructions and a brief note on how to add or remove exchanges in the future. If this matches your expertise in WordPress, wpForo and data-driven visuals, let’s get started.