Bulletin 1014
SELECT DistrictCode, District, MunName, AvgSalaries, SadSalaryTeacherAvg FROM aa_atest JOIN m_municipalities ON MunDOECode = DistrictCode JOIN m_schoolannualdata ON MunID = SadScdID WHERE MunState = 'MI' AND MunModID = 2 AND SadYear = 2019
UPDATE m_schoolannualdata JOIN m_municipalities ON MunID = SadScdID JOIN aa_atest ON MunDOECode = DistrictCode SET SadSalaryTeacherAvg = AvgSalaries WHERE MunState = 'MI' AND MunModID = 2 AND SadYear = 2019