Rakuten interview question

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