duplicate count

I want to count the number of requests for duplicate ip
| client_ip |
|----------------|---------------|
| 10.10.11.11 |
| 10.10.11.11 |
| 10.10.11.11 |
| 10.10.13.12 |
| 10.10.13.12 |
| 10.10.13.12 |
| 10.20.13.15 |
| 10.20.13.16 |
| 10.20.13.18 |
| 10.20.13.18 |

Assuming the original table looks like this, I would like to count it as
| client_ip | _value |
|----------------|---------------|
| 10.10.11.11 | 3 |
| 10.10.11.12 | 3 |
| 10.20.13.15 | 1 |
| 10.20.13.16 | 1 |
| 10.20.13.18 | 2 |
With this output, how do you write the statement，Tried many times without success Please help me.

Start from the example table and the requested grouped output, then identify the InfluxDB query entry point or documentation that covers counting duplicate client_ip values. Done means the documented statement produces one row per client_ip with its request count; no file or test is named in the issue.

Written by the indexing model from the issue text.