with semi_final_table as (
    select
        submission_date,
        (select count(distinct hacker_id)
            from submissions as s2
            where s2.submission_date=s1.submission_date and
                (select count(distinct s3.submission_date)
                    from submissions as s3
                    where s3.hacker_id=s2.hacker_id
                        and s3.submission_date <= s2.submission_date)=datediff(day,'2016-03-01',s1.submission_date)+1) as num_hackers_that_sub,
        (select top 1 hacker_id
            from submissions as s4
            where s4.submission_date=s1.submission_date
            group by hacker_id
            order by count(s4.submission_id) desc, HACKER_ID asc
            ) as top_hacker
    from submissions as s1
    group by submission_date
)
select semi_final_table.*, hackers.name
from semi_final_table
inner join hackers on hackers.hacker_id=semi_final_table.top_hacker
order by submission_date