Is there a way to get count based on multiple columns but still have it be distinct in SQL?
Not sure I understand the problem, but if you first pick distinct rows, and then count number of rows per date

select dt, count(1)
from (
    select distinct dt, job, title, name
    from t
) as x
group by dt


I used dt instead of date since it is a reserved word