DumbSample.sql

begin transaction

create table DumbSample (
	Expired bit default 0,
	Name varchar(max)
)

insert into DumbSample (Expired, Name) values (0, 'Milk');
insert into DumbSample (Expired, Name) values (0, 'Milk');
insert into DumbSample (Expired, Name) values (0, 'Milk');
insert into DumbSample (Expired, Name) values (1, 'Cheese');
insert into DumbSample (Expired, Name) values (1, 'Cheese');
insert into DumbSample (Expired, Name) values (1, 'Cheese');
insert into DumbSample (Expired, Name) values (0, 'Eggs');
insert into DumbSample (Expired, Name) values (0, 'Eggs');
insert into DumbSample (Expired, Name) values (1, 'Eggs');

select * from DumbSample

select	MAX(0 + Expired) [HasExpiredItems]  -- ANY
	,	MIN(1 - Expired) [AllAreFresh]		-- ALL
	,	Name
from DumbSample
group by Name

drop table DumbSample

rollback transaction

results1.tsv

results2.tsv