+----+-------+----------+
| ID | State |   Type   |
+----+-------+----------+
|  1 | GA    | Building |
|  1 | GA    | Outdoor  |
|  2 | GA    | Outdoor  |
|  3 | GA    | Building |
+----+-------+----------+

+----+-------+
| ID | State |
+----+-------+
|  1 | GA    |
|  2 | GA    |
|  3 | GA    |
+----+-------+