Home > database >  Statistics a time period for 10 consecutive days didn't punch to the user
Statistics a time period for 10 consecutive days didn't punch to the user

Time:12-11

Table userlog

Userid login_date
10001 the 2020-07-01
10001 the 2020-07-02
10001 the 2020-07-03
10002 the 2020-07-01
10003 the 2020-07-05
.
Now I don't think the statistics for 10 days record of users, how should be calculated?
  • Related