Allegra Term / Sold Herds                                           As of:  2020.01.08  22:38

Reported Termination Date - when termination was done

 COUNT(1) PR TDATE        Status
--------- -- ------------ -----------
        8 04 01-DEC-19    Sold
        9 05 01-DEC-19    Sold
        2 09 01-DEC-19    Sold

 COUNT(1) PR TDATE        Status
--------- -- ------------ -----------
       14 04 01-DEC-19    Term
       23 05 01-DEC-19    Term
        2 08 01-DEC-19    Term
        3 09 01-DEC-19    Term
group by hrd.prv_cd,
*
ERROR at line 15:
ORA-01787: only one clause allowed per query block