Sql Salesforce, How to know the list of email that clicked and URL

Question

select c.SubscriberKey as 'Subscriber Key', o.SubscriberKey as 'Email Address'
from _Click c
join _Open o
  on o.SubscriberID = c.SubscriberID
where c.URL like '%%unsub_center_url%%'
group by c.SubscriberKey, o.SubscriberKey, c.EventDate, o.EventDate

I want to know the list of emails with their suscriber keys of the clients who has clicked the links for the unsuscribe option, im trying with this logic but i get no results

Answer 1

等待大神答复