I have to find the same firstname+ lastname combo in my db and see which name appears the most so I basically need to do the following:
select name, count(name) from people group by name having count(name)>1 The problem is name is not one column but made up of firstname, lastname...how do I do this? Thanks!
