Zolo Interview Question

SQL was Case when Questions, CTE questions using three tables