Anyone can help me with this SQL question?

For future reference, please follow the guidelines here:

If this is for a class or exam, we don't answer those questions on At the very minimum you would need to post what you have attempted so far, and examples of data that demonstrate why it's not working as intended.