sergix

Q&A about the site for enthusiasts and power users of the Android operating system

select
COUNT(*) AS consecutiveDates,
MIN(date) AS minDate,
MAX(date) AS maxDate
from
(
SELECT DISTINCT
CAST(CreationDate AS DATE) date,
dateadd(day,
-DENSE_RANK() OVER (ORDER BY CAST(CreationDate AS DATE)),
CAST(CreationDate AS DATE)) AS grp
FROM Posts
WHERE OwnerUserId = 5969627
) x
group by grp