I have this table

```
| date       | id | number |
|------------|----|--------|
| 2021/05/01 | 1  | 10     |
| 2021/05/02 | 2  | 20     |
| 2021/05/03 | 3  | 30     |
| 2021/05/04 | 1  | 20     |

```

I am trying to write a query to have this other table

```
| date       | id | number |
|------------|----|--------|
| 2021/05/01 | 1  | 10     |
| 2021/05/02 | 1  | 10     |
| 2021/05/02 | 2  | 20     |
| 2021/05/03 | 1  | 10     |
| 2021/05/03 | 2  | 20     |
| 2021/05/03 | 3  | 30     |
| 2021/05/04 | 1  | 20     |
| 2021/05/04 | 2  | 20     |
| 2021/05/04 | 3  | 30     |

```

The idea is that each date should have all the previus different ids with its number, and if an id is repeated then only the last value should be considered.