Shapley Value Functions Example 2 Step 3 - Teradata Vantage

Step 3 computes the Shapley value for each player (CVS).

CREATE MULTISET TABLE attrib_cvs AS (
  SELECT * FROM ShapleyGenerateCombination (
    ON (
      SELECT attrconv.ind, (attrconv.num_conv/(1.0*attrtot.num_tot))
      FROM attrconv INNER JOIN attrtot ON attrconv.ind = attrtot.ind
    )
  ) AS dt
) WITH DATA;

This query returns the following table:

SELECT comb, size, CAST("value" AS NUMERIC(3,2)) FROM attrib_cvs ORDER BY size,comb;