GoFundMe interview question

SQL questions on left join sum(case when), window function