Re:문제451. ( SQL 마지막 문제) 연관 분석된 결과를 출력할 때 아래와 같이 제품명도 같이 나오게 하시오 ~

[11기_김서준]

SELECT DISTINCT A.ATTRIBUTE_SUBNAME as ANTECEDENT,

       m1.stock_name as ATTSTOCK_NAME,

       C.ATTRIBUTE_SUBNAME as CONSEQUENT,

       m2.stock_name as CONSTOCK_NAME,

       ROUND(RULE_SUPPORT,3) as SUPPORT,

       ROUND(RULE_CONFIDENCE,3) as CONFIDENCE,

       ROUND(RULE_LIFT,3) as LIFT

  FROM  TABLE(DBMS_DATA_MINING.GET_ASSOCIATION_RULES('MD_ASSOC_ANLYSIS',10)) T,

            TABLE(T.CONSEQUENT) C,

            TABLE(T.ANTECEDENT) A,

            market_table m1,

            market_table m2

  where a.attribute_subname=m1.stock_code and c.attribute_subname=m2.stock_code

  ORDER BY SUPPORT DESC,LIFT  DESC;