select rootRequestId, max( endDate ) endDate from qmd_contractChains where status = 'APPROVED' group by rootRequestId having max( endDate ) >= select 1 sectionSort, 'Current Agreements' sectionname, * from qmd_contractChains where rootRequestId in ( ) order by rootRequestId, chainSequence desc, sequence desc select rootRequestId, max( endDate ) endDate from qmd_contractChains where status = 'APPROVED' group by rootRequestId having max( endDate ) < select 2 sectionSort, 'Expired Agreements' sectionname, * from qmd_contractChains where rootRequestId in ( ) order by rootRequestId, chainSequence desc, sequence desc select * from qmd_requestChains_active union select * from qmd_requestChains_expired order by sectionSort, rootRequestId, chainSequence desc, sequence desc for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER