I have written a query in oraclesql as follows. But the sql query brings the result for a long time.