Sterilite Interview Question

Mostly just asking to write specific statements in SQL