Rakuten Interview Question

1. Explain the SQL code (including WITH clause, left join...)