Tectoro Interview Question

given table and asked to write queries