Is it possible to rank the following table:
+-------------------++-------------------+
| date | user |
+-------------------++-------------------+
| 2018-12-30 | User 1 |
| 2018-12-31 | User 1 |
| 2019-01-01 | User 2 |
| 2019-01-02 | User 2 |
| 2019-01-03 | User 1 |
| 2019-01-06 | User 1 |
| 2019-01-07 | User 2 |
| 2019-01-08 | User 2 |
+-------------------++-------------------+
in this way?
+-------------------++-------------------+++------+
| date | user | Rank |
+-------------------++-------------------+++------+
| 2018-12-30 | User 1 | 1 |
| 2018-12-31 | User 1 | 1 |
| 2019-01-01 | User 2 | 2 |
| 2019-01-02 | User 2 | 2 |
| 2019-01-03 | User 1 | 3 |
| 2019-01-06 | User 1 | 3 |
| 2019-01-07 | User 2 | 4 |
| 2019-01-08 | User 2 | 4 |
+-------------------++-------------------+++------+
select version()
show? - ysth