Question: How can we get given output with using recursion (other solutions will not be accepted!). Table codes: WITH EXPERIMENT(ExperimentId,Code) AS( SELECT * FROM(VALUES(1,'A10'), (2,'A20'), (3,'C40'),
How can we get given output with using recursion (other solutions will not be accepted!).

Table codes:
WITH EXPERIMENT(ExperimentId,Code) AS( SELECT * FROM(VALUES(1,'A10'), (2,'A20'), (3,'C40'), (4,'B00'), (5,'B99') )EXPERIMENT (ExperimentId,Code)),
MEASUREMENT(ExperimentId,Value) AS ( SELECT * FROM(VALUES(1,30.0), (1,3.0), (1,0.5), (2,5.0), (2,7.0), (3,0.1), (4,1.0), (4,2.0), (4,3.0), (4,5.0), (5,2.0), (5,0.1), (5,3.0) )MEASUREMENT(ExperimentId,Value)),
EXPERIMENT Experimentld Code 1 A10 2 A20 3 C40 4 BOO 5 B99 MEASUREMENT Experimentld Value 1 30.0 1 3.0 1 0.5 2 5.0 2 7.0 3 0.1 Desired output ExperimentCode ValueCount Value Multiplication A10 3 45 A20 2 35 BOO 4 30 899 3 0.6 C40 1 0.1 30.0 x 3.0 x 0.5 45 5.0 x 7.0 35 1.0 x 2.0 x 3.0 x 5.0 30 2.0 x 0.1 x 3.0 0.6 0.1 0.1 5 1.0 4 4 2.0 3.0 5.0 2.0 0.1 3.0 un 5 5 5
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
