select
	res.*,
	res.week_current + res.week_1 + res.week_2 + res.week_3 + res.week_4 total_minutes
from (
	select
		dg.id dg_id,
		dg.title dg_title,
		rca.id rca_id,
		rca.title rca_title,
		sum(case when week(report.report_date) = week(current_date) then report.total_minutes else 0 end) week_current,
		sum(case when week(report.report_date) = week(current_date - interval 1 week) then report.total_minutes else 0 end) week_1,
		sum(case when week(report.report_date) = week(current_date - interval 2 week) then report.total_minutes else 0 end) week_2,
		sum(case when week(report.report_date) = week(current_date - interval 3 week) then report.total_minutes else 0 end) week_3,
		sum(case when week(report.report_date) = week(current_date - interval 4 week) then report.total_minutes else 0 end) week_4
	from report_total_minutes_by_day report
		inner join data_gateway dg on report.gateway_id = dg.id
		inner join data_group_rca rca on dg.rca_id = rca.id
	where dg.title is not null
		and dg.is_deleted = 0
		and rca.is_deleted = 0
		and rca.title is not null
		and week(report.report_date) >= week(current_date - interval 4 week)
	group by rca.id
) res
order by total_minutes desc, rca_title asc