Question: what is the difference between in and exists?
Answer: The Exists keyword evaluates true or false, but IN keyword compare all value in the corresponding sub query column.