The given SQL creates a Song table and inserts some songs. The SELECT statement selects the genre and row count for each genre group.

Add a new column to the SELECT statement that uses MAX$0$ to find the most recent release year for each genre. Then add a HAVING clause that selects only genre groups that have more than one row count.

Run your solution and verify country pop, $R$&$B,$ and grunge genres, row counts, and most recent release years appear in the result table.

CREATE TABLE Song $($

ID INT,

Title VARCHAR$(60),$

Artist VARCHAR$(60),$

ReleaseYear INT,

Genre VARCHAR$(20),$

PRIMARY KEY $($ID$)$

;

INSERT INTO SONg VALUES

$(100,$ 'Hey Jude', 'Beatles', $1968,$ 'pop rock'$),$

$(200,$ 'You Belong With Me$\text{'},$ 'Taylor Swift', $2008,$ 'country pop'$),$

$(300,$ 'Youl're Still the One', 'Shania Twain', $1998,$ 'country pop'$),$

$(400,$ 'Need You Now', 'Lady Antebellum', $2011,$ 'country pop'$),$

$(500,$ 'You've Lost That Lovin' Feeling', 'The Righteous Brothers', $1964,\text{'}$R&B$\text{'}),$

$(600,$ 'That I$\text{'}$s The Way Love Goes', 'Janet Jackson', $1993,\text{'}$R&B$\text{'}),$

$(700,$ 'Smells Like Teen Spirit', 'Nirvana', $1991,$ 'grunge'$),$

$(800,$ 'Even Flow', 'Pearl Jam', $1992,$ 'grunge'$),$

$(900,$ 'Black Hole Sun', 'Soundgarden', $1994,\text{'}$ 'grunge'$)$;

$--$ Modify the SELECT statement

SELECT Genre, COUNT$(*)$

FROM Song

GROUP BY Genre;

Reset code