Here is what I have so far....
Still missing the retires, Final Success Ratio, and the pivot to make a single row for each, but this would at least get you some temporary data untill I can finish it up....
SELECT dj.clientName
, (SELECT COUNT(*) FROM domain_Job j WHERE DATEDIFF(day, UtcBigIntToNomTime(j.endTime), GETDATE()) <= 30 AND dj.clientName = j.clientName AND j.statusCode = 0) AS 'Successful Jobs'
, (SELECT COUNT(*) FROM domain_Job j WHERE DATEDIFF(day, UtcBigIntToNomTime(j.endTime), GETDATE()) <= 30 AND dj.clientName = j.clientName AND j.statusCode <> 0) AS 'Failed Jobs'
, (SELECT COUNT(*) FROM domain_Job j WHERE DATEDIFF(day, UtcBigIntToNomTime(j.endTime), GETDATE()) <= 30 AND dj.clientName = j.clientName) AS 'Total Jobs'
, '' AS 'Retries'
, '' AS 'Final Success Rate'
, rl.label AS 'RetentionLevel'
FROM domain_Job dj
INNER JOIN domain_image di
ON dj.id = di.jobId
INNER JOIN domain_ImageCopy ic
ON di.id = ic.imageId
INNER JOIN nb_RetentionLevel rl
ON ic.retentionLevel = rl.iD
WHERE DATEDIFF(day, UtcBigIntToNomTime(dj.endTime), GETDATE()) <= 30
GROUP BY dj.clientName, rl.label
ORDER BY dj.clientName, rl.label