How does this SQL question work? Can someone give me an example and explanation?

Related Book For  answer-question
Posted Date: