select count(*) as sendCount, min( emailDate ) firstSend, max( emailDate ) lastSend from tbl_WRK_Emails with (nolock) where emailTo like and lastSendMethod = 'SendGrid' select fspro_userId from tbl_fspro_members with (nolock) where email = select * from qmd_bounces where fsproMemberRecords > 0 or sendCount > 0 select status, count(*) instances from qmd_bounces group by status order by instances desc