Oracle Interview Question

Write some SQL query.