GIC Interview Question

For SQL they show you Employees and Department table. So question based on COALESCE, filtering, CASE WHEN statement. Lastly, they ask you interpret an ORCL SQL statement which is rather difficult and lengthy and determine the outcome.