It’s been a long time since someone helped me with the following query portion and I can’t remember what it actually does.
Does this make sense to anyone?
Thanks!
having sum(case when com.type=‘Conversation’
then 1 else 0 end) = 0
and sum(case when com.type in ( ‘Voicemail Sent’
, ‘Email Sent’)
then 1 else 0 end) = 0