Cacher is the code snippet organizer for pro developers

SELECT j.EmailName, fs.jobid, COUNT(DISTINCT SubscriberKey) as Unsubscribes
FROM [FS Unsubscribe] fs
LEFT JOIN _Job j on fs.jobid = j.JobID
GROUP BY j.EmailName, fs.jobid