Pregunta de entrevista de Amazon

Advanced SQL- consecutive numbers, segregating absent and present dates