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

Question

2. SQL (30 Pts) Based on the following DB: Performers Cname, genre) Nominations Cname, category, year, is winner) Performers Grammy Nominations is winner Rock Arizona Shakes Arizona Shakes Frank Ocean Frank Ocean 2013 2013 2013 2013 201 Artist Amy WinehouseRE Arizona Shakes Frank Ocean The Black Keys lock Performance Rock R&B; Rock ot the Year yes Rock Alburn yes of the Year Rock Performance 2012 The Black Keys Rock Performance 2013 yes 1) What is the output? (4 Pts) select p.name, genre from EPerformers p, E GrammyNominations g where p.name g.name and year '2013' and is winner yes'

Explanation / Answer

The query is:

select p.name, genre from E_Performance p,E-Germany_nominations g where p.name=g.name and year = 2013 and is _winner = 'yes';

Asd per given query, the nominations should be in te year 2013 and also nominies ds=should be winner also.

So that the output is :

name genre Frank Ocean R&B The Black Keys Rock

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

---

---

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