EXIST
• The EXISTS operator is utilized to determine whether any records exist in a subquery, returning TRUE if the subquery yields one or more records.
SELECT column_name(s)
FROM table_name
WHERE EXISTS
(SELECT column_name FROM table_name WHERE condition);