Oracle Interview Question

Write a query that you used in your project