Question d’entretien chez Amazon

Advanced SQL- consecutive numbers, segregating absent and present dates