Is there a way to get count based on multiple columns but still have it be distinct in SQL? I have included two pictures that are in Excel just for ease of viewing but I am doing the queries in SQL. 





Hopefully, this is possible as the algorithm I have is not giving me the correct results.
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