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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!