I have a database of names, some of the names haven't been insert in the correct fashion. SecondName has sometimes been entered as FirstName.

```
+-----------------+--------------+
|    FirstName    |  SecondName  |
+-----------------+--------------+
| Bob             | Smith        |
| Gary            | Rose         |
| John            | Jones        |
| Smith           | Bob          |
| Gary            | Oberstein    |
| Adam            | Sorbet       |
| Jones           | John         |
+-----------------+--------------+

```

I've tried different grouping queries 

```
select `FirstName`
     , `SecondName`
  from `names`
 where ( `FirstName` 
       , `SecondName` ) 
    in ( select `FirstName`
              , `SecondName`
           from `names`
         group
             by `FirstName`
              , `SecondName`
         having count(*) > 1 
       )

```

But I can't get anything to produce

```
+-----------------+--------------+---------+
|    FirstName    |  SecondName  |  Count  |
+-----------------+--------------+---------+
| Bob             | Smith        | 2       |
| John            | Jones        | 2       |
+-----------------+--------------+---------+

```