slice interview question

Asked execution order in SQL showing a query, output based on diff joins, an easy group by query, windows function, union and union all output, diff between delete and truncate. Asked to write a case based query