total-number-clicks.sql

select 
    jobid,
    ListID,
    BatchID,
    subscriberid, 
    count(subscriberid) AS Clicks
from _click
group by subscriberid, jobid, ListID, BatchID