Question: Suppose we have a table r(a, b, c) with the tuples {(1,2,3), (2,3,4), (3,4,5)} and the views v1, v2, v3 defined as follows: create view
Suppose we have a table r(a, b, c) with the tuples {(1,2,3), (2,3,4), (3,4,5)} and the views v1, v2, v3 defined as follows: create view v1 as select a*b as d, c as e from r; create view v2 as select d as f, sum(e) as g from v1 group by d; create view v3 as select avg(f) as a, g as b from v2 group by g; What is the result of: select sum(a+b) from v3; 17 22 32 10
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
