Посчитать сумму по неделям

WITH cycles AS (
                SELECT c.first_date, SUM(c.total_price) AS cycle_sum
                FROM school_year sy
                LEFT JOIN annex a ON sy.id = a.school_year_id
                LEFT JOIN cycle c ON a.id = c.annex_id
                WHERE sy.name='16-17'
                GROUP BY c.first_date
                ORDER BY c.first_date)
                , cycle_items AS (
                SELECT w.start_date, SUM(ci.total_price) AS cycle_item_sum
                FROM school_year sy
                LEFT JOIN annex a ON sy.id = a.school_year_id
                LEFT JOIN cycle c ON a.id = c.annex_id
                LEFT JOIN cycle_item ci ON c.id = ci.cycle_id
                LEFT JOIN week w ON ci.week_id = w.id
                WHERE sy.name='16-17' AND w.start_date IS NOT NULL
                GROUP BY w.start_date
                ORDER BY w.start_date
                )
                SELECT cycle_items.start_date, cycles.cycle_sum, cycle_items.cycle_item_sum
                FROM cycle_items LEFT JOIN cycles ON cycle_items.start_date = cycles.first_date
                ORDER BY cycle_items.start_date

SELECT SUM(payment.payment_value), week.start_date
FROM payment, week
WHERE week.school_year_id=51 AND payment.payment_date>=week.start_date AND payment.payment_date<=week.end_date
GROUP BY week.start_date
ORDER BY week.start_date