Hi caseyo,

please provide the table definition (CREATE TABLE ...) for the table in question (overall_avgs and tblResults). One way to do it is by Right-clicking at the table in Management Studio -> Script table as -> Create To -> New Query window.

It would also help if you could provide some sample date so we can see what the actual data look like. Based on those sample data we'd need to see your expected result so we can test our solution.

Please note that I'm offering a "I got thrust in here because someone left." discount 😉

Usually we'd expect to get ready to use sample data as described in the first link in my signature. But I think this situation calls for an exception....