Belt count and true security status for Solar Systems in the same constellation

From EVEDev

MySQL version:

 
SELECT m.solarsystemName, m.`security`, count(*) AS belts
FROM mapDenormalize d, mapSolarSystems m, mapConstellations c
WHERE d.typeID=15
AND m.solarSystemID=d.solarSystemID
AND c.constellationID=m.constellationID
AND c.constellationName='XPBM-F'
GROUP BY d.solarSystemID;
 

solarsystemName	security	belts
C-4ZOS	-0.647997173062294	7
K-8SQS	-0.74963872585895	6
C-VGYO	-0.562932986403721	7
O94U-A	-0.691109718938869	4
XW-JHT	-0.562682531191424	6
NEH-CS	-0.62690758555007	9

MS SQL:

 
SELECT m.solarSystemName, m."security", count(*) AS belts
FROM mapDenormalize d, mapSolarSystems m, mapConstellations c
WHERE d.typeID=15
AND m.solarSystemID=d.solarSystemID
AND c.constellationID=m.constellationID
AND c.constellationName='XPBM-F'
GROUP BY d.solarSystemID, m.solarSystemName, m."security";