Quiero encontrar el último número de días consecutivos máximos para la identificación del usuario.

 userId(string) active_date(string) Note: Today (2022-02-20) ------------------------------------------ { "userId": "DbdBve", "day": "2022-02-20" } { "userId": "DbdBve", "day": "2022-02-19" } { "userId": "DbdBve", "day": "2022-02-18" } { "userId": "DbdBve", "day": "2022-02-17" } <- Gap here | so user's been active for the last 3 days { "userId": "DbdBve", "day": "2022-02-15" } userId(string) active_date(string) ------------------------------------------ { "userId": "Gj6WEth", "day": "2022-02-20" } { "userId": "Gj6WEth", "day": "2022-02-15" } <- Gap here | so user's been active for the last 1 days { "userId": "Gj6WEth", "day": "2022-02-14" } { "userId": "Gj6WEth", "day": "2022-02-13" }