SELECT COALESCE(total.total_turnover_current_month, 0) as all_turnover, CASE WHEN COALES…