SELECT a.NAME as 'NAME_X', b.NAME as 'NAME_Y' ,count(*) as '장바구니 수' FROM 

(SELECT DISTINCT CART_ID, NAME FROM CART_PRODUCTS) a JOIN (SELECT DISTINCT CART_ID, NAME FROM CART_PRODUCTS) b

ON a.CART_ID = b.CART_ID and a.name!=b.name group by a.NAME,b.NAME order by a.NAME,b.NAME ASC;


SQL 보고 점수도매김?