SELECT
    hgr.NODE,hgr.TAG,
    (SELECT iif(abs(MIN(fz))>MAX(fz),MIN(fz),MAX(fz)) FROM OUTPUT_RESTRAINTS_SUMMARY WHERE node=hgr.NODE AND LCASE_NUM IN (8)) AS workFz,
    (SELECT iif(abs(MIN(fz))>MAX(fz),MIN(fz),MAX(fz)) FROM OUTPUT_RESTRAINTS_SUMMARY WHERE node=hgr.NODE AND LCASE_NUM IN (4)) AS coldFz,
    (SELECT iif(abs(MIN(fz))>MAX(fz),MIN(fz),MAX(fz)) FROM OUTPUT_RESTRAINTS_SUMMARY WHERE node=hgr.NODE AND LCASE_NUM IN (28)) AS hydroFz,
    (SELECT iif(abs(MIN(fz))>MAX(fz),MIN(fz),MAX(fz)) FROM OUTPUT_RESTRAINTS_SUMMARY WHERE node=hgr.NODE AND LCASE_NUM IN (12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27)) AS occFz,
    iif(outhgr.NODE IS NULL,'Rigid',iif(SPRING_RATE > 0,ROUND(SPRING_RATE*NUMREQ,1),'Constant')) AS RATE,
    (SELECT iif(abs(MIN(dx))>MAX(dx),MIN(dx),MAX(dx)) FROM OUTPUT_DISPLACEMENTS WHERE node=hgr.node AND LCASE_NUM IN (8)) AS workDX,
    (SELECT iif(abs(MIN(dy))>MAX(dy),MIN(dy),MAX(dy)) FROM OUTPUT_DISPLACEMENTS WHERE node=hgr.node AND LCASE_NUM IN (8)) AS workDY,
    (SELECT iif(abs(MIN(dz))>MAX(dz),MIN(dz),MAX(dz)) FROM OUTPUT_DISPLACEMENTS WHERE node=hgr.node AND LCASE_NUM IN (8)) AS workDZ,
    (SELECT iif(abs(MIN(dz))>MAX(dz),MIN(dz),MAX(dz)) FROM OUTPUT_DISPLACEMENTS WHERE node=hgr.node AND LCASE_NUM IN (12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27)) AS maxOccDZ,
    (SELECT iif(abs(MIN(dz))>MAX(dz),MIN(dz),MAX(dz)) FROM OUTPUT_DISPLACEMENTS WHERE node=hgr.node AND LCASE_NUM IN (4)) AS CZ
    FROM
    (SELECT
        node , tag
    FROM
        (SELECT  NODE_NUM AS NODE, RES_TAG AS TAG FROM INPUT_RESTRAINTS WHERE RES_TAG LIKE '55*-0*'
        UNION
        SELECT NODE,HGR_TAG AS TAG FROM INPUT_HANGERS
        ) AS TMP
    GROUP BY NODE,TAG
    ) AS hgr
    LEFT JOIN OUTPUT_HANGERS outhgr ON outhgr.NODE=hgr.NODE
    ORDER BY hgr.NODE;