Which answer is TRUE about the following SQL statement?

select $*$ from dreamhome. Staff

It selects all male staff with a position that contains $"$s$"$ and all female staff with a salary less than $10,000.$

It selects all female staff regardless of salary and male staff with a position that exactly matches $"$s$".$

It selects all male staff with a salary less than $10,000$ and female staff with a position that contains $"5".$

It selects only female staff with a salary greater than $10,000$ and male staff with any position.