ZS Associates Interview Question

What do you understood from case study? (Expect just approach or algorithm don't expect exact SQL queries )