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 (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 name name year is_winner Coldplay Arizona Shakes Arizona Shakes Frank Ocean Frank Ocean 2013 2013 2013 2013 2013 2009 2009 2012 2013 no no Arizona Shakes Frank Ocean The Black Keys Rock Performance Rock Album Alburm of the Year Rock Performance Rock Performance no no no The Black Keys 1) Write a SQL query to display Performers table. (3 Pts) NAME GENRE 1 Coldplay 2 Amy Winehouse RnB 3 Arizona Shakes Rock 4 Frank Ocean nB 5 The Black Keys Rock Rock 2) Write a SQL query to list all unique genres. (3 Pts) GENRE 1 RnB 2 Rock

Explanation / Answer

1) The query to display the performers tables is as followed below:

SQL> SELECT * FROM Performers;

2)The query to display all the list of genres from the performers tables is as followed below:

SQL> SELECT DISTINCT genre FROM Performers;

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

---

---

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