correlated subquery example in oracle

join shbcf.ru