TEKsystems Interview Question

Normal query in SQL ,basic of api