Based on the following DB: Performers (name, genre) Nominations (name, category,

Question

Based on the following DB: Performers (name, genre) Nominations (name, category, year, is_winner) Performers Grammy Nominations genre Rock R&B; Rock R&B; Rock category New Artist Rock Performance Album of the Year Rap/Sung Collaboration Rock Performance Rock Album Album of the Year Rock Performance Rock Performance name year is_winner no no no name Coldplay Arizona Shakes Arizona Shakes Frank Ocean Frank Ocean Coldplay Coldplay Coldplay Coldplay The Black Keys 2013 2013 2013 2013 2013 2009 Arizona Shakes Frank Ocean The Black Keys no no 2012 no 2013

Explanation / Answer

SELECT N.name as Name, Count(N.name) as [Nomination Count]

FROM E_Grammy_Nominations N

GROUP BY N.name

ORDER BY N.name DESC

Question 2

name

genre

Frank Ocean

R&B

The Black Keys

Rock

Question 3

year

2013

2012

Question 2

name

genre

Frank Ocean

R&B

The Black Keys

Rock

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

---

---

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