SQL - 对特定条件重复的行

We have a table like this:

我们有一个这样的表:

 +----+-------+-----------------+----------------+-----------------+----------------+-----------------+
| ID |  Name | RecievedService | FirstZoneTeeth | SecondZoneTeeth | ThirdZoneTeeth | FourthZoneTeeth |
+----+-------+-----------------+----------------+-----------------+----------------+-----------------+
|  1 |  John |   SomeService1  |       13       |                 |        4       |                 |
+----+-------+-----------------+----------------+-----------------+----------------+-----------------+
|  2 |  John |   SomeService1  |       34       |                 |                |                 |
+----+-------+-----------------+----------------+-----------------+----------------+-----------------+
|  3 | Steve |   SomeService3  |                |                 |                |        2        |
+----+-------+-----------------+----------------+-----------------+----------------+-----------------+
|  4 | Steve |   SomeService4  |                |                 |                |        12       |
+----+-------+-----------------+----------------+-----------------+----------------+-----------------+
 +---