Amazon interview question

Advanced SQL- consecutive numbers, segregating absent and present dates