SQL Exercise

I need help doing the following attached SQL Exercise

Tags: No tags