I am working on an SQL query that involves a LEFT JOIN and an EXISTS subquery, but I am encountering an