Data Manipulation Homework 3
Queries
1.Find the average album item price for all album items by The Beatles.
2.List all the albums items that have a price greater than the average price for an album item.
3.Update the price of all album items for Jay Zs The Blueprint album with a 20% discount on price.
4.Delete all album items for the artist The Smiths, who have two albums in the database, Meat is Murder and The Queen is Dead. (Hint: You need to use IN with the WHERE clause).
5.List the album artist, album name, album year, and album item price for all albums for years between 1980 and 1990.
6.List the album artist, album name, album year, and the average price of album items grouped by the album name.
7.First, delete all album items between 1990 and 2000 (this will create some holes in the data). Then, list the album name, album year, album item price, and album item quality for all albums and album items, even if the album has no album items. (Hint: A left or right outer join is necessary)