Oracle interview question

DSA Questions and also SQL queries for a given scenario