Answers for "write an sql query that summarizes each group of tests codility"

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;