Google Cloud interview question

Write sql queries for the following