This idea will be to count the number of project by each name (group by), sort them by the count in descending order (order by desc), then pick the top 1, try this:
select top 1 name, count(project) from projecttable group by name order by count(project) desc