SELECT A.ITEM_CODE as 'ITEMA', B.ITEM_CODE as 'ITEMB',

CAST(COUNT(*) as REAL) /  (SELECT CAST(COUNT(*) as REAL) FROM  (SELECT MEMBER_CODE FROM   PURCHASE_HISTORY GROUP BY  MEMBER_CODE)) * 100  AS 'SUPPORT',
CAST(COUNT(*) as REAL) /  (SELECT CAST(COUNT(*) as REAL) FROM  (SELECT MEMBER_CODE FROM   PURCHASE_HISTORY WHERE ITEM_CODE = A.ITEM_CODE GROUP BY  MEMBER_CODE)) * 100  AS 'CONFIDENCE',
CAST(COUNT(*) as REAL) /  (SELECT CAST(COUNT(*) as REAL) FROM  (SELECT MEMBER_CODE FROM   PURCHASE_HISTORY WHERE ITEM_CODE = A.ITEM_CODE GROUP BY  MEMBER_CODE)) / ((SELECT CAST(COUNT(*) as REAL) FROM  (SELECT MEMBER_CODE FROM   PURCHASE_HISTORY WHERE ITEM_CODE = B.ITEM_CODE GROUP BY  MEMBER_CODE)) / (SELECT CAST(COUNT(*) as REAL) FROM  (SELECT MEMBER_CODE FROM   PURCHASE_HISTORY GROUP BY  MEMBER_CODE))) as 'LIFT'

FROM 
 (select  SESSION_ID, ITEM_CODE , MEMBER_CODE
  FROM    PURCHASE_HISTORY
 ) A
LEFT JOIN
 (select  SESSION_ID, ITEM_CODE , MEMBER_CODE
  FROM    PURCHASE_HISTORY
 ) B
ON A.SESSION_ID = B.SESSION_ID AND A.MEMBER_CODE = B.MEMBER_CODE AND
      A.ITEM_CODE <> B.ITEM_CODE
WHERE B.ITEM_CODE IS NOT NULL
GROUP BY A.ITEM_CODE, B.ITEM_CODE;