harisankarh · March 12, 2018 15:28
diff --git a/2.sql b/2.sql
 SELECT *,
       (CASE
            WHEN ((x1*w_00 + x2*w_10) + b_0) > 0.0 THEN ((x1*w_00 + x2*w_10) + b_0)
            ELSE 0.0
        END) AS d0,
       (CASE
            WHEN ((x1*w_01 + x2*w_11) + b_0) > 0.0 THEN ((x1*w_01 + x2*w_11) + b_1)
            ELSE 0.0
        END) AS d1
 FROM {inner subquery}
	SELECT *,
	(CASE
	WHEN ((x1w_00 + x2w_10) + b_0) > 0.0 THEN ((x1w_00 + x2w_10) + b_0)
	ELSE 0.0
	END) AS d0,
	(CASE
	WHEN ((x1w_01 + x2w_11) + b_0) > 0.0 THEN ((x1w_01 + x2w_11) + b_1)
	ELSE 0.0
	END) AS d1
	FROM {inner subquery}