Amazon Interview Question

merchant and orders tables ,,,window function ,CASE statement