I am new to IA and I want to convert the below query logic into IA data rule.Please help me out
select pos_nbr , count( * )
where trunc( sysdate ) between pa.start_date and pa.end_date
and pos_nbr not in( '99999999', '0' )
group by pos_nbr
having count( * ) > 1
here sysdate in the query is cutternt date in oracle database.