Deloitte interview question

SQL related use cases and queries