Watch this video on YouTube
Which of the following best describes a situation where a LEFT SEMI JOIN would be used in Databricks SQL?