conversion of nested queries into semi-joins

listen to the pronunciation of conversion of nested queries into semi-joins