Greensky interview question

Question about the SQL query