You can also use exists in a nested subquery. The following is the same as the previous query
#Oracle
#Nested_Subqueries_2