Amazon Interview Question

Advanced SQL- consecutive numbers, segregating absent and present dates