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!