Thanks for the solution. I'm wondering why it doesn't work if I change "where exists" to "where (x,y) in";

the second one the subquery doesn't seem to return anything...