Is your feature request related to a problem or challenge?

Sort Merge Join currently supports LeftSemi join however it would be nice to have RightSemi support as well

https://github.com/apache/datafusion/blob/main/datafusion/physical-plan/src/joins/sort_merge_join.rs

Describe the solution you'd like

Add support unit tests and fuzz tests

Describe alternatives you've considered

No response

Additional context

No response