alter table test add constraint PK_TEST primary key (FIELD1, FIELD2, FIELD3, FIELD4, FIELD5);

select count(*)
from TEST
where FIELD1 = '01'
and cast(FIELD6 as date) between '2001/01/01' and '2001/12/31'
and FIELD4 = '0001'
order by FIELD1, FIELD6, FIELD4;