Question: Consider the following view that has been created: CREATE VIEW album _ cost AS SELECT album.album _ id , album.title, SUM ( unit _ price
Consider the following view that has been created:
CREATE VIEW albumcost
AS
SELECT album.albumid album.title, SUMunitprice as albumcost
FROM track
INNER JOIN album
ON album.albumid track.albumid
GROUP BY album.albumid album.title;
How would you query it to get the albums that cost more than $
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
