write an sql query that summarizes each group of tests codility
select g.name,
count(c.group_name) as all_test_cases,
count(case when c.status = 'OK' then 1 end) as passed_test_cases,
sum(case when c.status = 'OK' then g.test_value else 0 end) as total_value
from test_groups g left join test_cases c
on c.group_name = g.name
group by g.name
order by all_test_cases desc, g.name desc;