Which of the following statements is NOT true about semi$-$joins, anti$-$joins, and nested queries in SQL$?$ Select all that applies.

Group of answer choices

$($A$)$ Nested queries can always be used to achieve the same results as semi$-$joins and anti$-$joins.

$($B$)$ Semi$-$joins return rows from the inner table that have matching rows in the inner table based on a join condition.

$($C$)$ Anti$-$joins return all rows from both tables, regardless of the join condition.

$($D$)$ Relational algebra expressions using semi$-$join and anti$-$join operators can sometimes provide a clearer representation of the query logic compared to nested queries.

$($E$)$ Depending on the database system, using semi$-$join or anti$-$join might lead to a more efficient execution plan than nested queries.