I want to know what is the easiest way to extract number from character which representing percentage. For example, I have

```
name, rate
Google, 10%
Google, 20%
Uber, 25%
...

```

I want a query that return the average rate group by name

```
Google, 15%
Uber, 25%

```