create table if not exists tickets(id integer primary key, team text, status text);
insert into tickets(team, status) values ('Ops', 'Open');
insert into tickets(team, status) values ('Infra', 'Closed');
insert into tickets(team, status) values ('Ops', 'Closed');
select team, count(*) as total from tickets group by team;
