Find all albums that feature more than 1 artist


  • 0
    A

    3 tables: Artist, Album and Song. The rules are:

    • Each album must have 1 or more songs.
    • Each song can only appear in 1 album.
    • Each song can be performed by 1 or more artists
    • Each album can contain songs from different artists.
    • Each album can contain songs performed by 2 or more artists.

    Draw the ER diagram. Write a SQL query to find all albums that feature more than 1 artist.


Log in to reply
 

Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.