Learn how the SQL EXISTS operator works and why you should use it when it comes to filtering a given table based on a condition defined by a subquery.