1
select `v_patch`.`ClientID` AS `ClientID`,`v_patch`.`LocationID` AS `LocationID`,sum(`v_patch`.`Installed`) AS `Installed`,sum(`v_patch`.`NoneMissing`) AS `Fully Patched`,sum(`v_patch`.`Missing1to2`) AS `Missing 1-2 Patches`,sum(`v_patch`.`Missing3to5`) AS `Missing 3-5 Patches`,sum(`v_patch`.`Missing5`) AS `Missing 6+ Patches`,sum(`v_patch`.`TotalPatches`) AS `PTotal` from `labtech`.`v_patch` group by `v_patch`.`LocationID`