PAM Group interview question

Presented with some Sql questions and asked to write sql statement for them