SELECT Organ.OrganName, SOSAlarm.TermName,COUNT(*)as counts
from Organ,Users,SOSAlarm
WHERE Users.UserName=SOSAlarm.TermName and Users.UserOrgan_ID=Organ.ID group by SOSAlarm.TermName,Organ.OrganName
from Organ,Users,SOSAlarm
WHERE Users.UserName=SOSAlarm.TermName and Users.UserOrgan_ID=Organ.ID group by SOSAlarm.TermName,Organ.OrganName