2 Assume Following Query Select Isbn Title Sum Quantity Average Price Author B0ok B Writes Q37022412

2. Assume the following query: SELECT isbn, title, sum (quantity), average (price) FROM AUTHOR A, B0OK B, WRITES W, SALES S WHERE A.author-id W.author-id and B.isbn – W.isbn and B.isbn- s.isbn and B.publisher = “Penguin” and A.country’UK’and S.store-location -“Louisville” GROUP BY isbn, title (a) Build a canonical

OR

 

OR