Teams with just one member:SELECT count(*) as MemberCount, ESCGROUP, TeamID FROM MMESCALATIONS WHERE AdminLevel=0 GROUP BY TeamID, ESCGROUP HAVING count(*)=1
Users with an empty mobile phone entry:SELECT * FROM MMPROFILES WHERE ADRMOBILE IS NULL OR ADRMOBILE=''