!!!! Finally figured it out!!

I took the Schools table out of the equation to simplify things. I also added a BuildingID index to the BuildingChars table (didn't require any major...

Ah it executed but it isn't giving me the correct results. I'm not 100% on what it's actually calculating now. Curse whoever designed this database. It is still giving me...

thanks so much for your quick responses. cjeremy, i think your solution is very close. the only problem is i get an error message that says "The multi-part identifier M.SchoolID...

I don't want to GROUP BY year though, I'd like to group by corresponding buildingchars. Notice how some of the results may be utility bills starting in May and ending...

The query I have written only retrieves the most recent 12 months of utility data. Many schools have years of utility data. I'm trying to create a view that contains...