I want to know how to count all Visits values between selected dates. i want to count all visits values betwwen two dates where uid is =2. Below is my mysql db structure.
ID | uid | visits| Date
1 | 1 |10 |02/07/23
2 | 2 |85 |01/07/23
3 | 1 |56 |29/06/23
4 | 2 |06 |28/06/23
5 | 2 |12 |27/06/23