In order for the query to finish, it will have to first accumulate the name and dimensions columns in the outer question. Then, it compares Each and every row from that end result established against the results with the inner query, which decides the average amount of wins for people with identical shoe sizes. The AVG purpose returns the average