List the musical group s who have a CD that contains at least one song that was

Question

List the musical group s who have a CD that contains at least one song that was ranked 1 topSongs.rating-1 between the year 2000 and 2003 2000 and 2003 inclusive (attributes to retrieve: groupCode, groupName, and songTitle) Composed of Member WrittenBy artistlD/char groupCode/char fromDatelnumeric toDate/numeric 1970 1991 1970 1992 1971 1995 1997 1995 1985 1985 cdCode/char songCode/char trackNumbernum A1 1990 songCode/char artistiD/cha 1990 G2 Group G2 groupCode/cha groupNamelchar 1999 A7 A7 utsch Moss eet Symphony hundering Typhoons 1985 1991 1990 1980 1998 1990 1998 1980 G3 Great Snakes Keith Urban' 2003 eyond Artist topSongs songCode/char yearinumerid rating/numeric artistiD/chanfirstName/char lastName/char yearBorn/num 1987 1987 1990 1998 1998 Bjorn Heidi John Michael Michelle Francis Steve Lisa Janet Hen Friedman 1945 Helmut Stark Agnelo Agnelo McDermott 1960 Nash' Raymond 1973 Brown Brown Urban' Hopkins 1945 1971 1975 1975 S4" S5 S6' 1993 1993 1998 1998 1999 1999 A7 1965 S11 1972 1970 1970 1960 C17 S15 S16 John

Explanation / Answer

Answer)
List musical groups who have a CD contains at least one song that was ranked 1, between 2000 and 2003 inclusive.

I am able to see and find the groupCode and groupName, but unable to find the songTitle in the provided images screenshots. Here's the below query as per the requirement displaying groupCode and groupName from Group.

select * from Group where groupCode in (
select distinct groupCode from Member where artistID in (
select artistID from WrittenBy where songCode in (
select songCode from topSongs where rating=1 and year between 2000 and 2003
)
)
);

Related Questions

Navigate

• Browse (All)
• Browse L
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.