text: -- This SQL code was generated by sklearn2sql (development version).
  -- Copyright 2018
  
  -- Model : CaretClassifier_ctree
  -- Dataset : digits
  -- Database : teradata
  
  
  -- This SQL code can contain one or more statements, to be executed in the order they appear in this file.
  
  
  
  -- Model deployment code
  
  WITH "DT_node_lookup" AS 
  (SELECT "ADS"."KEY" AS "KEY", CASE WHEN ("ADS"."Feature_33" <= CAST(8.0 AS DOUBLE PRECISION)) THEN CASE WHEN ("ADS"."Feature_26" <= CAST(0.0 AS DOUBLE PRECISION)) THEN CASE WHEN ("ADS"."Feature_43" <= CAST(2.0 AS DOUBLE PRECISION)) THEN 4 ELSE CASE WHEN ("ADS"."Feature_38" <= CAST(0.0 AS DOUBLE PRECISION)) THEN 6 ELSE 7 END END ELSE CASE WHEN ("ADS"."Feature_21" <= CAST(0.0 AS DOUBLE PRECISION)) THEN CASE WHEN ("ADS"."Feature_42" <= CAST(9.0 AS DOUBLE PRECISION)) THEN CASE WHEN ("ADS"."Feature_5" <= CAST(2.0 AS DOUBLE PRECISION)) THEN CASE WHEN ("ADS"."Feature_37" <= CAST(1.0 AS DOUBLE PRECISION)) THEN CASE WHEN ("ADS"."Feature_13" <= CAST(0.0 AS DOUBLE PRECISION)) THEN CASE WHEN ("ADS"."Feature_9" <= CAST(2.0 AS DOUBLE PRECISION)) THEN 14 ELSE 15 END ELSE 16 END ELSE CASE WHEN ("ADS"."Feature_43" <= CAST(15.0 AS DOUBLE PRECISION)) THEN CASE WHEN ("ADS"."Feature_62" <= CAST(13.0 AS DOUBLE PRECISION)) THEN 19 ELSE 20 END ELSE 21 END END ELSE CASE WHEN ("ADS"."Feature_18" <= CAST(11.0 AS DOUBLE PRECISION)) THEN 23 ELSE 24 END END ELSE CASE WHEN ("ADS"."Feature_9" <= CAST(1.0 AS DOUBLE PRECISION)) THEN CASE WHEN ("ADS"."Feature_30" <= CAST(2.0 AS DOUBLE PRECISION)) THEN CASE WHEN ("ADS"."Feature_20" <= CAST(8.0 AS DOUBLE PRECISION)) THEN CASE WHEN ("ADS"."Feature_30" <= CAST(0.0 AS DOUBLE PRECISION)) THEN 29 ELSE 30 END ELSE 31 END ELSE 32 END ELSE 33 END END ELSE CASE WHEN ("ADS"."Feature_28" <= CAST(0.0 AS DOUBLE PRECISION)) THEN CASE WHEN ("ADS"."Feature_6" <= CAST(0.0 AS DOUBLE PRECISION)) THEN CASE WHEN ("ADS"."Feature_36" <= CAST(0.0 AS DOUBLE PRECISION)) THEN CASE WHEN ("ADS"."Feature_59" <= CAST(10.0 AS DOUBLE PRECISION)) THEN 38 ELSE 39 END ELSE 40 END ELSE 41 END ELSE CASE WHEN ("ADS"."Feature_36" <= CAST(8.0 AS DOUBLE PRECISION)) THEN CASE WHEN ("ADS"."Feature_42" <= CAST(5.0 AS DOUBLE PRECISION)) THEN CASE WHEN ("ADS"."Feature_21" <= CAST(5.0 AS DOUBLE PRECISION)) THEN 45 ELSE CASE WHEN ("ADS"."Feature_43" <= CAST(1.0 AS DOUBLE PRECISION)) THEN CASE WHEN ("ADS"."Feature_29" <= CAST(10.0 AS DOUBLE PRECISION)) THEN 48 ELSE CASE WHEN ("ADS"."Feature_10" <= CAST(5.0 AS DOUBLE PRECISION)) THEN 50 ELSE CASE WHEN ("ADS"."Feature_21" <= CAST(11.0 AS DOUBLE PRECISION)) THEN 52 ELSE 53 END END END ELSE 54 END END ELSE CASE WHEN ("ADS"."Feature_29" <= CAST(9.0 AS DOUBLE PRECISION)) THEN CASE WHEN ("ADS"."Feature_54" <= CAST(0.0 AS DOUBLE PRECISION)) THEN 57 ELSE 58 END ELSE 59 END END ELSE CASE WHEN ("ADS"."Feature_60" <= CAST(7.0 AS DOUBLE PRECISION)) THEN CASE WHEN ("ADS"."Feature_53" <= CAST(5.0 AS DOUBLE PRECISION)) THEN CASE WHEN ("ADS"."Feature_1" <= CAST(0.0 AS DOUBLE PRECISION)) THEN CASE WHEN ("ADS"."Feature_4" <= CAST(7.0 AS DOUBLE PRECISION)) THEN 64 ELSE CASE WHEN ("ADS"."Feature_17" <= CAST(5.0 AS DOUBLE PRECISION)) THEN CASE WHEN ("ADS"."Feature_19" <= CAST(10.0 AS DOUBLE PRECISION)) THEN CASE WHEN ("ADS"."Feature_25" <= CAST(4.0 AS DOUBLE PRECISION)) THEN CASE WHEN ("ADS"."Feature_17" <= CAST(1.0 AS DOUBLE PRECISION)) THEN 69 ELSE 70 END ELSE 71 END ELSE 72 END ELSE 73 END END ELSE 74 END ELSE 75 END ELSE CASE WHEN ("ADS"."Feature_10" <= CAST(8.0 AS DOUBLE PRECISION)) THEN CASE WHEN ("ADS"."Feature_20" <= CAST(14.0 AS DOUBLE PRECISION)) THEN CASE WHEN ("ADS"."Feature_50" <= CAST(4.0 AS DOUBLE PRECISION)) THEN CASE WHEN ("ADS"."Feature_5" <= CAST(11.0 AS DOUBLE PRECISION)) THEN CASE WHEN ("ADS"."Feature_37" <= CAST(13.0 AS DOUBLE PRECISION)) THEN 81 ELSE 82 END ELSE 83 END ELSE 84 END ELSE CASE WHEN ("ADS"."Feature_41" <= CAST(2.0 AS DOUBLE PRECISION)) THEN CASE WHEN ("ADS"."Feature_30" <= CAST(0.0 AS DOUBLE PRECISION)) THEN 87 ELSE 88 END ELSE 89 END END ELSE CASE WHEN ("ADS"."Feature_43" <= CAST(15.0 AS DOUBLE PRECISION)) THEN CASE WHEN ("ADS"."Feature_62" <= CAST(9.0 AS DOUBLE PRECISION)) THEN CASE WHEN ("ADS"."Feature_33" <= CAST(0.0 AS DOUBLE PRECISION)) THEN CASE WHEN ("ADS"."Feature_43" <= CAST(3.0 AS DOUBLE PRECISION)) THEN CASE WHEN ("ADS"."Feature_42" <= CAST(5.0 AS DOUBLE PRECISION)) THEN CASE WHEN ("ADS"."Feature_26" <= CAST(8.0 AS DOUBLE PRECISION)) THEN 96 ELSE 97 END ELSE 98 END ELSE CASE WHEN ("ADS"."Feature_38" <= CAST(0.0 AS DOUBLE PRECISION)) THEN CASE WHEN ("ADS"."Feature_18" <= CAST(9.0 AS DOUBLE PRECISION)) THEN 101 ELSE CASE WHEN ("ADS"."Feature_27" <= CAST(7.0 AS DOUBLE PRECISION)) THEN 103 ELSE 104 END END ELSE 105 END END ELSE 106 END ELSE 107 END ELSE CASE WHEN ("ADS"."Feature_44" <= CAST(9.0 AS DOUBLE PRECISION)) THEN 109 ELSE 110 END END END END END END END END ELSE CASE WHEN ("ADS"."Feature_54" <= CAST(2.0 AS DOUBLE PRECISION)) THEN CASE WHEN ("ADS"."Feature_26" <= CAST(11.0 AS DOUBLE PRECISION)) THEN 113 ELSE CASE WHEN ("ADS"."Feature_2" <= CAST(1.0 AS DOUBLE PRECISION)) THEN 115 ELSE 116 END END ELSE 117 END END AS node_id_2 
  FROM digits AS "ADS"), 
  dummy_cte AS 
  (SELECT CAST(0.0 AS DOUBLE PRECISION) AS "X"), 
  "DT_node_data" AS 
  (SELECT "Values".nid AS nid, "Values"."P_0" AS "P_0", "Values"."P_1" AS "P_1", "Values"."P_2" AS "P_2", "Values"."P_3" AS "P_3", "Values"."P_4" AS "P_4", "Values"."P_5" AS "P_5", "Values"."P_6" AS "P_6", "Values"."P_7" AS "P_7", "Values"."P_8" AS "P_8", "Values"."P_9" AS "P_9", "Values"."D" AS "D", "Values"."DP" AS "DP" 
  FROM (SELECT 4 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.018691588785047 AS DOUBLE PRECISION) AS "P_1", CAST(0.046728971962617 AS DOUBLE PRECISION) AS "P_2", CAST(0.878504672897196 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.009345794392523 AS DOUBLE PRECISION) AS "P_7", CAST(0.009345794392523 AS DOUBLE PRECISION) AS "P_8", CAST(0.037383177570094 AS DOUBLE PRECISION) AS "P_9", 3 AS "D", CAST(0.878504672897196 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 6 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.144067796610169 AS DOUBLE PRECISION) AS "P_1", CAST(0.694915254237289 AS DOUBLE PRECISION) AS "P_2", CAST(0.042372881355932 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.008474576271186 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.008474576271186 AS DOUBLE PRECISION) AS "P_7", CAST(0.101694915254237 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 2 AS "D", CAST(0.694915254237289 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 7 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.052631578947368 AS DOUBLE PRECISION) AS "P_2", CAST(0.026315789473684 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.026315789473684 AS DOUBLE PRECISION) AS "P_6", CAST(0.894736842105263 AS DOUBLE PRECISION) AS "P_7", CAST(0.0 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 7 AS "D", CAST(0.894736842105263 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 14 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.928571428571429 AS DOUBLE PRECISION) AS "P_1", CAST(0.071428571428571 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.0 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 1 AS "D", CAST(0.928571428571429 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 15 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(1.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.0 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 2 AS "D", CAST(1.0 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 16 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.428571428571429 AS DOUBLE PRECISION) AS "P_1", CAST(0.285714285714286 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.285714285714286 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 1 AS "D", CAST(0.428571428571429 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 19 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.5 AS DOUBLE PRECISION) AS "P_3", CAST(0.25 AS DOUBLE PRECISION) AS "P_4", CAST(0.1875 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.0 AS DOUBLE PRECISION) AS "P_8", CAST(0.0625 AS DOUBLE PRECISION) AS "P_9", 3 AS "D", CAST(0.5 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 20 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(1.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.0 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 1 AS "D", CAST(1.0 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 21 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.444444444444444 AS DOUBLE PRECISION) AS "P_6", CAST(0.444444444444444 AS DOUBLE PRECISION) AS "P_7", CAST(0.111111111111111 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 6 AS "D", CAST(0.444444444444444 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 23 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.111111111111111 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.888888888888889 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.0 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 5 AS "D", CAST(0.888888888888889 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 24 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.009090909090909 AS DOUBLE PRECISION) AS "P_4", CAST(0.990909090909091 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.0 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 5 AS "D", CAST(0.990909090909091 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 29 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(1.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.0 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 6 AS "D", CAST(1.0 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 30 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.125 AS DOUBLE PRECISION) AS "P_5", CAST(0.875 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.0 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 6 AS "D", CAST(0.875 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 31 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.875 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.125 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.0 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 1 AS "D", CAST(0.875 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 32 AS nid, CAST(0.125 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.875 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.0 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 4 AS "D", CAST(0.875 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 33 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.888888888888889 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.111111111111111 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.0 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 2 AS "D", CAST(0.888888888888889 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 38 AS nid, CAST(0.909090909090909 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.090909090909091 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.0 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 0 AS "D", CAST(0.909090909090909 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 39 AS nid, CAST(1.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.0 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 0 AS "D", CAST(1.0 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 40 AS nid, CAST(0.5 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.125 AS DOUBLE PRECISION) AS "P_3", CAST(0.25 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.0 AS DOUBLE PRECISION) AS "P_8", CAST(0.125 AS DOUBLE PRECISION) AS "P_9", 0 AS "D", CAST(0.5 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 41 AS nid, CAST(0.571428571428571 AS DOUBLE PRECISION) AS "P_0", CAST(0.142857142857143 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.285714285714286 AS DOUBLE PRECISION) AS "P_7", CAST(0.0 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 0 AS "D", CAST(0.571428571428571 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 45 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.076923076923077 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.846153846153846 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.0 AS DOUBLE PRECISION) AS "P_8", CAST(0.076923076923077 AS DOUBLE PRECISION) AS "P_9", 5 AS "D", CAST(0.846153846153846 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 48 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.2 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.1 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.0 AS DOUBLE PRECISION) AS "P_8", CAST(0.7 AS DOUBLE PRECISION) AS "P_9", 9 AS "D", CAST(0.7 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 50 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.466666666666667 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.0 AS DOUBLE PRECISION) AS "P_8", CAST(0.533333333333333 AS DOUBLE PRECISION) AS "P_9", 9 AS "D", CAST(0.533333333333333 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 52 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.076923076923077 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.0 AS DOUBLE PRECISION) AS "P_8", CAST(0.923076923076923 AS DOUBLE PRECISION) AS "P_9", 9 AS "D", CAST(0.923076923076923 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 53 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.0 AS DOUBLE PRECISION) AS "P_8", CAST(1.0 AS DOUBLE PRECISION) AS "P_9", 9 AS "D", CAST(1.0 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 54 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.111111111111111 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.333333333333333 AS DOUBLE PRECISION) AS "P_7", CAST(0.222222222222222 AS DOUBLE PRECISION) AS "P_8", CAST(0.333333333333333 AS DOUBLE PRECISION) AS "P_9", 7 AS "D", CAST(0.333333333333333 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 57 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.210526315789474 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.052631578947368 AS DOUBLE PRECISION) AS "P_7", CAST(0.736842105263158 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 8 AS "D", CAST(0.736842105263158 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 58 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.625 AS DOUBLE PRECISION) AS "P_2", CAST(0.25 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.125 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 2 AS "D", CAST(0.625 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 59 AS nid, CAST(0.555555555555556 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.111111111111111 AS DOUBLE PRECISION) AS "P_4", CAST(0.055555555555556 AS DOUBLE PRECISION) AS "P_5", CAST(0.166666666666667 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.0 AS DOUBLE PRECISION) AS "P_8", CAST(0.111111111111111 AS DOUBLE PRECISION) AS "P_9", 0 AS "D", CAST(0.555555555555556 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 64 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.7 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.1 AS DOUBLE PRECISION) AS "P_7", CAST(0.0 AS DOUBLE PRECISION) AS "P_8", CAST(0.2 AS DOUBLE PRECISION) AS "P_9", 4 AS "D", CAST(0.7 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 69 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.984126984126984 AS DOUBLE PRECISION) AS "P_7", CAST(0.015873015873016 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 7 AS "D", CAST(0.984126984126984 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 70 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.714285714285714 AS DOUBLE PRECISION) AS "P_7", CAST(0.0 AS DOUBLE PRECISION) AS "P_8", CAST(0.285714285714286 AS DOUBLE PRECISION) AS "P_9", 7 AS "D", CAST(0.714285714285714 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 71 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.285714285714286 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.714285714285714 AS DOUBLE PRECISION) AS "P_7", CAST(0.0 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 7 AS "D", CAST(0.714285714285714 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 72 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.428571428571429 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.285714285714286 AS DOUBLE PRECISION) AS "P_7", CAST(0.285714285714286 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 1 AS "D", CAST(0.428571428571429 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 73 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.285714285714286 AS DOUBLE PRECISION) AS "P_7", CAST(0.0 AS DOUBLE PRECISION) AS "P_8", CAST(0.714285714285714 AS DOUBLE PRECISION) AS "P_9", 9 AS "D", CAST(0.714285714285714 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 74 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.142857142857143 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.714285714285714 AS DOUBLE PRECISION) AS "P_7", CAST(0.142857142857143 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 7 AS "D", CAST(0.714285714285714 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 75 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.125 AS DOUBLE PRECISION) AS "P_1", CAST(0.5 AS DOUBLE PRECISION) AS "P_2", CAST(0.125 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.25 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 2 AS "D", CAST(0.5 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 81 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.875 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.125 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 4 AS "D", CAST(0.875 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 82 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(1.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.0 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 4 AS "D", CAST(1.0 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 83 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.2 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.4 AS DOUBLE PRECISION) AS "P_7", CAST(0.1 AS DOUBLE PRECISION) AS "P_8", CAST(0.3 AS DOUBLE PRECISION) AS "P_9", 7 AS "D", CAST(0.4 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 84 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.125 AS DOUBLE PRECISION) AS "P_2", CAST(0.0625 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0625 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.75 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 8 AS "D", CAST(0.75 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 87 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.982758620689655 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.017241379310345 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 1 AS "D", CAST(0.982758620689655 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 88 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.875 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.125 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.0 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 1 AS "D", CAST(0.875 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 89 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.2 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.8 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.0 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 4 AS "D", CAST(0.8 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 96 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.954545454545455 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.0 AS DOUBLE PRECISION) AS "P_8", CAST(0.045454545454545 AS DOUBLE PRECISION) AS "P_9", 3 AS "D", CAST(0.954545454545455 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 97 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.055555555555556 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.055555555555556 AS DOUBLE PRECISION) AS "P_7", CAST(0.0 AS DOUBLE PRECISION) AS "P_8", CAST(0.888888888888889 AS DOUBLE PRECISION) AS "P_9", 9 AS "D", CAST(0.888888888888889 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 98 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.111111111111111 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.777777777777778 AS DOUBLE PRECISION) AS "P_8", CAST(0.111111111111111 AS DOUBLE PRECISION) AS "P_9", 8 AS "D", CAST(0.777777777777778 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 101 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.125 AS DOUBLE PRECISION) AS "P_2", CAST(0.5 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.375 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 3 AS "D", CAST(0.5 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 103 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.125 AS DOUBLE PRECISION) AS "P_1", CAST(0.375 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.5 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 8 AS "D", CAST(0.5 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 104 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(1.0 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 8 AS "D", CAST(1.0 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 105 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.1 AS DOUBLE PRECISION) AS "P_7", CAST(0.9 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 8 AS "D", CAST(0.9 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 106 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.125 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.5 AS DOUBLE PRECISION) AS "P_8", CAST(0.375 AS DOUBLE PRECISION) AS "P_9", 8 AS "D", CAST(0.5 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 107 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.833333333333333 AS DOUBLE PRECISION) AS "P_2", CAST(0.111111111111111 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.055555555555556 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 2 AS "D", CAST(0.833333333333333 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 109 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.285714285714286 AS DOUBLE PRECISION) AS "P_1", CAST(0.714285714285714 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.0 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 2 AS "D", CAST(0.714285714285714 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 110 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.769230769230769 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.230769230769231 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 1 AS "D", CAST(0.769230769230769 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 113 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.3 AS DOUBLE PRECISION) AS "P_4", CAST(0.1 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.6 AS DOUBLE PRECISION) AS "P_7", CAST(0.0 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 7 AS "D", CAST(0.6 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 115 AS nid, CAST(0.0 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(1.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.0 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 4 AS "D", CAST(1.0 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 116 AS nid, CAST(0.142857142857143 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.571428571428571 AS DOUBLE PRECISION) AS "P_4", CAST(0.285714285714286 AS DOUBLE PRECISION) AS "P_5", CAST(0.0 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.0 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 4 AS "D", CAST(0.571428571428571 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte UNION ALL SELECT 117 AS nid, CAST(0.7 AS DOUBLE PRECISION) AS "P_0", CAST(0.0 AS DOUBLE PRECISION) AS "P_1", CAST(0.0 AS DOUBLE PRECISION) AS "P_2", CAST(0.0 AS DOUBLE PRECISION) AS "P_3", CAST(0.0 AS DOUBLE PRECISION) AS "P_4", CAST(0.0 AS DOUBLE PRECISION) AS "P_5", CAST(0.3 AS DOUBLE PRECISION) AS "P_6", CAST(0.0 AS DOUBLE PRECISION) AS "P_7", CAST(0.0 AS DOUBLE PRECISION) AS "P_8", CAST(0.0 AS DOUBLE PRECISION) AS "P_9", 0 AS "D", CAST(0.7 AS DOUBLE PRECISION) AS "DP" 
  FROM dummy_cte) AS "Values"), 
  "DT_Output" AS 
  (SELECT "DT_node_lookup"."KEY" AS "KEY", "DT_node_lookup".node_id_2 AS node_id_2, "DT_node_data".nid AS nid, "DT_node_data"."P_0" AS "P_0", "DT_node_data"."P_1" AS "P_1", "DT_node_data"."P_2" AS "P_2", "DT_node_data"."P_3" AS "P_3", "DT_node_data"."P_4" AS "P_4", "DT_node_data"."P_5" AS "P_5", "DT_node_data"."P_6" AS "P_6", "DT_node_data"."P_7" AS "P_7", "DT_node_data"."P_8" AS "P_8", "DT_node_data"."P_9" AS "P_9", "DT_node_data"."D" AS "D", "DT_node_data"."DP" AS "DP" 
  FROM "DT_node_lookup" LEFT OUTER JOIN "DT_node_data" ON "DT_node_lookup".node_id_2 = "DT_node_data".nid)
   SELECT "DT_Output"."KEY" AS "KEY", CAST(NULL AS DOUBLE PRECISION) AS "Score_0", CAST(NULL AS DOUBLE PRECISION) AS "Score_1", CAST(NULL AS DOUBLE PRECISION) AS "Score_2", CAST(NULL AS DOUBLE PRECISION) AS "Score_3", CAST(NULL AS DOUBLE PRECISION) AS "Score_4", CAST(NULL AS DOUBLE PRECISION) AS "Score_5", CAST(NULL AS DOUBLE PRECISION) AS "Score_6", CAST(NULL AS DOUBLE PRECISION) AS "Score_7", CAST(NULL AS DOUBLE PRECISION) AS "Score_8", CAST(NULL AS DOUBLE PRECISION) AS "Score_9", "DT_Output"."P_0" AS "Proba_0", "DT_Output"."P_1" AS "Proba_1", "DT_Output"."P_2" AS "Proba_2", "DT_Output"."P_3" AS "Proba_3", "DT_Output"."P_4" AS "Proba_4", "DT_Output"."P_5" AS "Proba_5", "DT_Output"."P_6" AS "Proba_6", "DT_Output"."P_7" AS "Proba_7", "DT_Output"."P_8" AS "Proba_8", "DT_Output"."P_9" AS "Proba_9", CASE WHEN ("DT_Output"."P_0" IS NULL OR "DT_Output"."P_0" > CAST(0.0 AS DOUBLE PRECISION)) THEN ln("DT_Output"."P_0") ELSE -1.79769313486231e+308 END AS "LogProba_0", CASE WHEN ("DT_Output"."P_1" IS NULL OR "DT_Output"."P_1" > CAST(0.0 AS DOUBLE PRECISION)) THEN ln("DT_Output"."P_1") ELSE -1.79769313486231e+308 END AS "LogProba_1", CASE WHEN ("DT_Output"."P_2" IS NULL OR "DT_Output"."P_2" > CAST(0.0 AS DOUBLE PRECISION)) THEN ln("DT_Output"."P_2") ELSE -1.79769313486231e+308 END AS "LogProba_2", CASE WHEN ("DT_Output"."P_3" IS NULL OR "DT_Output"."P_3" > CAST(0.0 AS DOUBLE PRECISION)) THEN ln("DT_Output"."P_3") ELSE -1.79769313486231e+308 END AS "LogProba_3", CASE WHEN ("DT_Output"."P_4" IS NULL OR "DT_Output"."P_4" > CAST(0.0 AS DOUBLE PRECISION)) THEN ln("DT_Output"."P_4") ELSE -1.79769313486231e+308 END AS "LogProba_4", CASE WHEN ("DT_Output"."P_5" IS NULL OR "DT_Output"."P_5" > CAST(0.0 AS DOUBLE PRECISION)) THEN ln("DT_Output"."P_5") ELSE -1.79769313486231e+308 END AS "LogProba_5", CASE WHEN ("DT_Output"."P_6" IS NULL OR "DT_Output"."P_6" > CAST(0.0 AS DOUBLE PRECISION)) THEN ln("DT_Output"."P_6") ELSE -1.79769313486231e+308 END AS "LogProba_6", CASE WHEN ("DT_Output"."P_7" IS NULL OR "DT_Output"."P_7" > CAST(0.0 AS DOUBLE PRECISION)) THEN ln("DT_Output"."P_7") ELSE -1.79769313486231e+308 END AS "LogProba_7", CASE WHEN ("DT_Output"."P_8" IS NULL OR "DT_Output"."P_8" > CAST(0.0 AS DOUBLE PRECISION)) THEN ln("DT_Output"."P_8") ELSE -1.79769313486231e+308 END AS "LogProba_8", CASE WHEN ("DT_Output"."P_9" IS NULL OR "DT_Output"."P_9" > CAST(0.0 AS DOUBLE PRECISION)) THEN ln("DT_Output"."P_9") ELSE -1.79769313486231e+308 END AS "LogProba_9", "DT_Output"."D" AS "Decision", "DT_Output"."DP" AS "DecisionProba" 
  FROM "DT_Output"