Amazon Interview Question

select statements, case statements joins etc