Question: what is semi join in sql?
Answer: A semi-join between two tables returns rows that match an EXISTS subquery without duplicating rows from the left side of the predicate when multiple rows on the right side satisfy the criteria of the subquery. Semi-joins are written using EXISTS or IN.