WSC Sports interview question

Self join in sql test