Improve MySQL queries that aggregate MDM profile statuses for Apple hosts #16309

Job	Run time
test-go (integration, ubuntu-latest, mysql:8.0.36)	11m 31s
test-go (integration, ubuntu-latest, mysql:8.0.36)	12m 2s
test-go (integration, ubuntu-latest, mysql:8.0.36)	12m 2s
test-go (integration, ubuntu-latest, mysql:8.0.36)	12m 2s
test-go (integration, ubuntu-latest, mysql:8.4.2)	12m 35s
test-go (integration, ubuntu-latest, mysql:8.4.2)	12m 35s
test-go (integration, ubuntu-latest, mysql:8.4.2)	12m 35s
test-go (integration, ubuntu-latest, mysql:8.4.2)	12m 35s
test-go (core, ubuntu-latest, mysql:8.0.36)	14m 15s
test-go (core, ubuntu-latest, mysql:8.0.36)	13m 51s
test-go (core, ubuntu-latest, mysql:8.0.36)	14m 22s
test-go (core, ubuntu-latest, mysql:8.0.36)	14m 7s
test-go (core, ubuntu-latest, mysql:8.4.2)	14m 35s
test-go (core, ubuntu-latest, mysql:8.4.2)	14m 9s
test-go (core, ubuntu-latest, mysql:8.4.2)	14m 9s
test-go (core, ubuntu-latest, mysql:8.4.2)	14m 3s
upload-coverage	0s
upload-coverage	0s
upload-coverage	0s
upload-coverage	0s
	3h 31m 28s

Provide feedback