Write in SQL: Provide a list of artists who authored the albums checked out by c
ID: 3600620 • Letter: W
Question
Write in SQL: Provide a list of artists who authored the albums checked out by customers who have checked out more albums than the average customer.
User (Library_Card_No, First_name, Last_name, Email, Address, Phone)
Album (Album_ID, Artist_IDFK, Album_Name, Album_year, Genre, Total_copies)
Checks_out (Library_Card_NoFK, Album_IDFK, Date)
Artist (Artist_ID, Bio, Artist_Name)
Track (Track_ID, Album_IDFK, Track_Length, Track_Name)
Music_Video (MV_ID, Track_IDFK, MV_Length, MV_Producer)
Movie (Movie_ID, Movie_Name)
In_Movie (Track_IDFK,Movie_IDFK)
Explanation / Answer
QUERY:
select Artist_Name from Artist where Artist_ID
(select Artist_IDFK from Album where Album_ID in
(select Album_IDFK from Checks_out where Library_card_NoFK in
(select Library_card_NoFK from
(select Library_card_NoFK, count(Album_IDFK) Album_IDFK from Checks_out group by Library_card_NoFK where Album_IDFK >
(select avg(Album_IDFK) from (select Library_card_NoFK, count(Album_IDFK) Album_IDFK from Checks_out group by Library_card_NoFK))))));
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.