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,$ 'You$\backslash \text{'}$re Still the One', 'Shania Twain', $1998,$ 'country pop'$),$

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

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

$(600,$ 'That$\backslash \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,$ 'grunge'$)$;

$--$ Modify the SELECT statement

SELECT Genre, COUNT$(*)$

FROM Song

GROUP BY Genre;