Anonymous interview question

Explain sorting algorithms Left joon and right join in sql