2. SQL (30 Pts) Based on the following DB: Performers (name, genre) Nominations

Question

2. SQL (30 Pts) Based on the following DB: Performers (name, genre) Nominations Cname, category, year, is winner) Grammy Nominations is_winner category New Artist Rock Performance genre Rock Arizona Shakes Arizona Shakes Frank Ocean Frank Ocean 2013 201 2013 2013 201 Amy Winehouse E Arizona Shakes Frank Ocean The Black Keys Rock R&B; Rock of the Year Rock Albun yes of the Year Rock Performance 2012 The Black Keys Rock Performance 201 yes 1) Write a SQL query to list Performers' name and category who didn't wirn in 2013. (4 Pts) NAME CATEGORY 1 Arizona Shakes New Artist 2 Arizona Shakes Rock Performance 3 Frank Ocean Album of the Year 4 Coldplay Rock Performance

Explanation / Answer

Query :

SELECT g.name, g.category FROM Grammy_Nominations g JOIN Performers p

ON p.name = g.name WHERE g.year = 2013 AND g.is_winner = 'no'

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

---

---

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