-
Notifications
You must be signed in to change notification settings - Fork 0
/
dbScript.sql
47 lines (36 loc) · 79.4 KB
/
dbScript.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
#Note: Do not run the script complete. Run it in steps as
# mentioned:
# Step 1
Drop schema if exists SongsDb;
# Step 2
Create schema SongsDb;
# Steps 3
use SongsDb;
# Step 4
DROP TABLE IF EXISTS `SongImpressions`;
# Step 5
CREATE TABLE `SongImpressions` (
`Year` double DEFAULT NULL,
`Title` varchar(63) DEFAULT NULL,
`Artist` varchar(63) DEFAULT NULL,
`Country` varchar(63) DEFAULT NULL,
`Impressions` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#Step 6
INSERT INTO `SongImpressions` VALUES (2014,'Happy','Pharrell Williams','Argentina',3),(2014,'Happy','Pharrell Williams','Costa Rica',1),(2014,'Happy','Pharrell Williams','Ethiopia',12),(2014,'Happy','Pharrell Williams','Indonesia',3),(2014,'Happy','Pharrell Williams','Martinique',1),(2014,'Happy','Pharrell Williams','Mexico',2),(2014,'Happy','Pharrell Williams','South Korea',1),(2014,'Happy','Pharrell Williams','Spain',1),(2014,'Happy','Pharrell Williams','Turkey',1),(2014,'Happy','Pharrell Williams','United States',4),(2014,'Dark Horse','Katy Perry Featuring Juicy J','Antarctica',1),(2014,'Dark Horse','Katy Perry Featuring Juicy J','Ethiopia',4),(2014,'Dark Horse','Katy Perry Featuring Juicy J','United States',6),(2014,'All Of Me','John Legend','Argentina',1),(2014,'All Of Me','John Legend','Bosnia and Herzegovina',1),(2014,'All Of Me','John Legend','Colombia',2),(2014,'All Of Me','John Legend','Ethiopia',16),(2014,'All Of Me','John Legend','Guadeloupe',1),(2014,'All Of Me','John Legend','Hong Kong',2),(2014,'All Of Me','John Legend','Mexico',2),(2014,'All Of Me','John Legend','Peru',1),(2014,'All Of Me','John Legend','Puerto Rico',1),(2014,'All Of Me','John Legend','United States',7),(2014,'All Of Me','John Legend','Uruguay',1),(2014,'All Of Me','John Legend','Venezuela',2),(2014,'Fancy','Iggy Azalea Featuring Charli XCX','Guatemala',1),(2014,'Fancy','Iggy Azalea Featuring Charli XCX','United States',7),(2014,'Counting Stars','OneRepublic','Austria',1),(2014,'Counting Stars','OneRepublic','Brazil',1),(2014,'Counting Stars','OneRepublic','Canada',1),(2014,'Counting Stars','OneRepublic','Ethiopia',14),(2014,'Counting Stars','OneRepublic','Guam',3),(2014,'Counting Stars','OneRepublic','Indonesia',3),(2014,'Counting Stars','OneRepublic','Mauritius',1),(2014,'Counting Stars','OneRepublic','South Africa',1),(2014,'Counting Stars','OneRepublic','Sweden',1),(2014,'Counting Stars','OneRepublic','Turkey',1),(2014,'Counting Stars','OneRepublic','United Kingdom',1),(2014,'Counting Stars','OneRepublic','United States',6),(2014,'Talk Dirty','Jason Derulo Featuring 2 Chainz','United States',3),(2014,'Rude','MAGIC!','Albania',1),(2014,'Rude','MAGIC!','Argentina',5),(2014,'Rude','MAGIC!','Brazil',1),(2014,'Rude','MAGIC!','Canada',1),(2014,'Rude','MAGIC!','Chile',1),(2014,'Rude','MAGIC!','El Salvador',2),(2014,'Rude','MAGIC!','Ethiopia',9),(2014,'Rude','MAGIC!','Georgia',1),(2014,'Rude','MAGIC!','Guam',1),(2014,'Rude','MAGIC!','Hong Kong',1),(2014,'Rude','MAGIC!','Indonesia',1),(2014,'Rude','MAGIC!','Italy',1),(2014,'Rude','MAGIC!','Mexico',2),(2014,'Rude','MAGIC!','Peru',1),(2014,'Rude','MAGIC!','United States',1),(2014,'Rude','MAGIC!','Venezuela',3),(2014,'All About That Bass','Meghan Trainor','Angola',1),(2014,'All About That Bass','Meghan Trainor','Colombia',1),(2014,'All About That Bass','Meghan Trainor','Ethiopia',11),(2014,'All About That Bass','Meghan Trainor','Germany',1),(2014,'All About That Bass','Meghan Trainor','Indonesia',6),(2014,'All About That Bass','Meghan Trainor','Italy',2),(2014,'All About That Bass','Meghan Trainor','Netherlands',1),(2014,'All About That Bass','Meghan Trainor','Peru',1),(2014,'All About That Bass','Meghan Trainor','Puerto Rico',1),(2014,'All About That Bass','Meghan Trainor','Spain',1),(2014,'All About That Bass','Meghan Trainor','United States',5),(2014,'All About That Bass','Meghan Trainor','Venezuela',1),(2014,'Problem','Ariana Grande Featuring Iggy Azalea','United States',8),(2014,'Stay With Me','Sam Smith','Argentina',1),(2014,'Stay With Me','Sam Smith','Brazil',1),(2014,'Stay With Me','Sam Smith','Ethiopia',16),(2014,'Stay With Me','Sam Smith','Georgia',1),(2014,'Stay With Me','Sam Smith','Indonesia',6),(2014,'Stay With Me','Sam Smith','Mexico',2),(2014,'Stay With Me','Sam Smith','Morocco',1),(2014,'Stay With Me','Sam Smith','South Korea',1),(2014,'Stay With Me','Sam Smith','São Tomé and Príncipe',1),(2014,'Stay With Me','Sam Smith','United States',4),(2014,'Pompeii','Bastille','Argentina',1),(2014,'Pompeii','Bastille','Australia',1),(2014,'Pompeii','Bastille','Brazil',3),(2014,'Pompeii','Bastille','Canada',1),(2014,'Pompeii','Bastille','Ethiopia',20),(2014,'Pompeii','Bastille','Indonesia',4),(2014,'Pompeii','Bastille','Netherlands',1),(2014,'Pompeii','Bastille','Spain',1),(2014,'Pompeii','Bastille','United States',4),(2014,'Shake It Off','Taylor Swift','Australia',1),(2014,'Shake It Off','Taylor Swift','Brazil',2),(2014,'Shake It Off','Taylor Swift','Canada',1),(2014,'Shake It Off','Taylor Swift','Ethiopia',9),(2014,'Shake It Off','Taylor Swift','France',1),(2014,'Shake It Off','Taylor Swift','Mexico',1),(2014,'Shake It Off','Taylor Swift','Philippines',1),(2014,'Shake It Off','Taylor Swift','Puerto Rico',1),(2014,'Shake It Off','Taylor Swift','United States',6),(2014,'Am I Wrong','Nico & Vinz','Austria',1),(2014,'Am I Wrong','Nico & Vinz','Brazil',2),(2014,'Am I Wrong','Nico & Vinz','Canada',1),(2014,'Am I Wrong','Nico & Vinz','Colombia',1),(2014,'Am I Wrong','Nico & Vinz','Costa Rica',1),(2014,'Am I Wrong','Nico & Vinz','Ecuador',1),(2014,'Am I Wrong','Nico & Vinz','Ethiopia',10),(2014,'Am I Wrong','Nico & Vinz','France',1),(2014,'Am I Wrong','Nico & Vinz','Iceland',1),(2014,'Am I Wrong','Nico & Vinz','Indonesia',3),(2014,'Am I Wrong','Nico & Vinz','Italy',1),(2014,'Am I Wrong','Nico & Vinz','Japan',2),(2014,'Am I Wrong','Nico & Vinz','Jordan',1),(2014,'Am I Wrong','Nico & Vinz','Netherlands',1),(2014,'Am I Wrong','Nico & Vinz','Nicaragua',1),(2014,'Am I Wrong','Nico & Vinz','United Kingdom',1),(2014,'Am I Wrong','Nico & Vinz','United States',5),(2014,'Turn Down For What','DJ Snake & Lil Jon','Argentina',3),(2014,'Turn Down For What','DJ Snake & Lil Jon','Brazil',1),(2014,'Turn Down For What','DJ Snake & Lil Jon','Bulgaria',1),(2014,'Turn Down For What','DJ Snake & Lil Jon','Canada',1),(2014,'Turn Down For What','DJ Snake & Lil Jon','Chile',2),(2014,'Turn Down For What','DJ Snake & Lil Jon','Ethiopia',12),(2014,'Turn Down For What','DJ Snake & Lil Jon','France',1),(2014,'Turn Down For What','DJ Snake & Lil Jon','Iceland',1),(2014,'Turn Down For What','DJ Snake & Lil Jon','Indonesia',2),(2014,'Turn Down For What','DJ Snake & Lil Jon','Japan',2),(2014,'Turn Down For What','DJ Snake & Lil Jon','Mexico',2),(2014,'Turn Down For What','DJ Snake & Lil Jon','Palestine',1),(2014,'Turn Down For What','DJ Snake & Lil Jon','Puerto Rico',1),(2014,'Turn Down For What','DJ Snake & Lil Jon','United States',6),(2014,'Turn Down For What','DJ Snake & Lil Jon','Venezuela',1),(2014,'The Monster','Eminem Featuring Rihanna','Ethiopia',4),(2014,'The Monster','Eminem Featuring Rihanna','Japan',1),(2014,'The Monster','Eminem Featuring Rihanna','Mexico',1),(2014,'The Monster','Eminem Featuring Rihanna','United Arab Emirates',2),(2014,'The Monster','Eminem Featuring Rihanna','United States',4),(2014,'Say Something','A Great Big World & Christina Aguilera','Argentina',1),(2014,'Say Something','A Great Big World & Christina Aguilera','Australia',3),(2014,'Say Something','A Great Big World & Christina Aguilera','Canada',1),(2014,'Say Something','A Great Big World & Christina Aguilera','Chile',2),(2014,'Say Something','A Great Big World & Christina Aguilera','Ecuador',1),(2014,'Say Something','A Great Big World & Christina Aguilera','Eritrea',1),(2014,'Say Something','A Great Big World & Christina Aguilera','Ethiopia',10),(2014,'Say Something','A Great Big World & Christina Aguilera','Indonesia',3),(2014,'Say Something','A Great Big World & Christina Aguilera','Italy',2),(2014,'Say Something','A Great Big World & Christina Aguilera','Mexico',1),(2014,'Say Something','A Great Big World & Christina Aguilera','Netherlands',2),(2014,'Say Something','A Great Big World & Christina Aguilera','Norway',1),(2014,'Say Something','A Great Big World & Christina Aguilera','Peru',1),(2014,'Say Something','A Great Big World & Christina Aguilera','Thailand',1),(2014,'Say Something','A Great Big World & Christina Aguilera','United Kingdom',1),(2014,'Say Something','A Great Big World & Christina Aguilera','United States',6),(2014,'Team','Lorde','Antarctica',1),(2014,'Team','Lorde','Argentina',1),(2014,'Team','Lorde','Brazil',5),(2014,'Team','Lorde','Ethiopia',17),(2014,'Team','Lorde','Germany',1),(2014,'Team','Lorde','India',1),(2014,'Team','Lorde','United States',3),(2014,'Let Her Go','Passenger','Argentina',5),(2014,'Let Her Go','Passenger','Colombia',2),(2014,'Let Her Go','Passenger','Ethiopia',15),(2014,'Let Her Go','Passenger','Finland',1),(2014,'Let Her Go','Passenger','Indonesia',4),(2014,'Let Her Go','Passenger','Japan',1),(2014,'Let Her Go','Passenger','Peru',1),(2014,'Let Her Go','Passenger','Switzerland',1),(2014,'Let Her Go','Passenger','Turkey',1),(2014,'Let Her Go','Passenger','United Arab Emirates',1),(2014,'Royals','Lorde','Argentina',1),(2014,'Royals','Lorde','Brazil',2),(2014,'Royals','Lorde','Colombia',1),(2014,'Royals','Lorde','Ethiopia',11),(2014,'Royals','Lorde','Germany',1),(2014,'Royals','Lorde','Greece',1),(2014,'Royals','Lorde','Guernsey',1),(2014,'Royals','Lorde','India',2),(2014,'Royals','Lorde','Indonesia',2),(2014,'Royals','Lorde','Isle of Man',1),(2014,'Royals','Lorde','Japan',1),(2014,'Royals','Lorde','Kiribati',1),(2014,'Royals','Lorde','Mexico',1),(2014,'Royals','Lorde','United Kingdom',1),(2014,'Royals','Lorde','United States',6),(2013,'Thrift Shop','Macklemore & Ryan Lewis Featuring Wanz','Ethiopia',5),(2013,'Blurred Lines','Robin Thicke Featuring T.I. + Pharrell','Ethiopia',1),(2013,'Blurred Lines','Robin Thicke Featuring T.I. + Pharrell','Germany',1),(2013,'Radioactive','Imagine Dragons','Argentina',1),(2013,'Radioactive','Imagine Dragons','Austria',1),(2013,'Radioactive','Imagine Dragons','Bangladesh',1),(2013,'Radioactive','Imagine Dragons','Brazil',1),(2013,'Radioactive','Imagine Dragons','Colombia',2),(2013,'Radioactive','Imagine Dragons','Ethiopia',12),(2013,'Radioactive','Imagine Dragons','Germany',1),(2013,'Radioactive','Imagine Dragons','Indonesia',1),(2013,'Radioactive','Imagine Dragons','Italy',1),(2013,'Radioactive','Imagine Dragons','Japan',1),(2013,'Radioactive','Imagine Dragons','Mexico',1),(2013,'Radioactive','Imagine Dragons','Peru',1),(2013,'Radioactive','Imagine Dragons','United States',8),(2013,'Harlem Shake','Baauer','Albania',1),(2013,'Harlem Shake','Baauer','Brazil',2),(2013,'Harlem Shake','Baauer','Canada',2),(2013,'Harlem Shake','Baauer','Ethiopia',4),(2013,'Harlem Shake','Baauer','Guernsey',1),(2013,'Harlem Shake','Baauer','Indonesia',1),(2013,'Harlem Shake','Baauer','Japan',6),(2013,'Harlem Shake','Baauer','Netherlands',1),(2013,'Harlem Shake','Baauer','Peru',1),(2013,'Harlem Shake','Baauer','Puerto Rico',2),(2013,'Harlem Shake','Baauer','South Africa',2),(2013,'Harlem Shake','Baauer','United Kingdom',2),(2013,'Harlem Shake','Baauer','United States',10),(2013,'Mirrors','Justin Timberlake','Brazil',6),(2013,'Mirrors','Justin Timberlake','Ethiopia',22),(2013,'Mirrors','Justin Timberlake','Guam',1),(2013,'Mirrors','Justin Timberlake','Indonesia',1),(2013,'Mirrors','Justin Timberlake','Mexico',2),(2013,'Mirrors','Justin Timberlake','Singapore',1),(2013,'Mirrors','Justin Timberlake','United States',1),(2013,'Just Give Me A Reason','P!nk Featuring Nate Ruess','Ethiopia',2),(2013,'Just Give Me A Reason','P!nk Featuring Nate Ruess','United States',1),(2013,'When I Was Your Man','Bruno Mars','Brazil',3),(2013,'When I Was Your Man','Bruno Mars','Chile',1),(2013,'When I Was Your Man','Bruno Mars','Colombia',2),(2013,'When I Was Your Man','Bruno Mars','Egypt',1),(2013,'When I Was Your Man','Bruno Mars','Ethiopia',13),(2013,'When I Was Your Man','Bruno Mars','Guam',2),(2013,'When I Was Your Man','Bruno Mars','Indonesia',2),(2013,'When I Was Your Man','Bruno Mars','Italy',1),(2013,'When I Was Your Man','Bruno Mars','Japan',1),(2013,'When I Was Your Man','Bruno Mars','Mexico',1),(2013,'When I Was Your Man','Bruno Mars','Paraguay',2),(2013,'When I Was Your Man','Bruno Mars','Russia',1),(2013,'When I Was Your Man','Bruno Mars','United States',1),(2013,'When I Was Your Man','Bruno Mars','Venezuela',1),(2013,'Cruise','Florida Georgia Line Featuring Nelly','Ethiopia',1),(2013,'Cruise','Florida Georgia Line Featuring Nelly','United States',1),(2013,'Roar','Katy Perry','Antarctica',1),(2013,'Roar','Katy Perry','Argentina',2),(2013,'Roar','Katy Perry','Brazil',1),(2013,'Roar','Katy Perry','Ethiopia',19),(2013,'Roar','Katy Perry','Malaysia',2),(2013,'Roar','Katy Perry','Mexico',2),(2013,'Roar','Katy Perry','Peru',2),(2013,'Roar','Katy Perry','Philippines',2),(2013,'Roar','Katy Perry','United States',4),(2013,'Locked Out Of Heaven','Bruno Mars','Argentina',2),(2013,'Locked Out Of Heaven','Bruno Mars','Canada',1),(2013,'Locked Out Of Heaven','Bruno Mars','Chile',1),(2013,'Locked Out Of Heaven','Bruno Mars','Colombia',2),(2013,'Locked Out Of Heaven','Bruno Mars','Dominican Republic',1),(2013,'Locked Out Of Heaven','Bruno Mars','Ethiopia',21),(2013,'Locked Out Of Heaven','Bruno Mars','Germany',1),(2013,'Locked Out Of Heaven','Bruno Mars','Indonesia',1),(2013,'Locked Out Of Heaven','Bruno Mars','Netherlands',1),(2013,'Ho Hey','The Lumineers','Argentina',1),(2013,'Ho Hey','The Lumineers','Australia',1),(2013,'Ho Hey','The Lumineers','Bulgaria',1),(2013,'Ho Hey','The Lumineers','Colombia',1),(2013,'Ho Hey','The Lumineers','Ethiopia',12),(2013,'Ho Hey','The Lumineers','France',1),(2013,'Ho Hey','The Lumineers','Germany',1),(2013,'Ho Hey','The Lumineers','Greece',2),(2013,'Ho Hey','The Lumineers','Guam',5),(2013,'Ho Hey','The Lumineers','India',1),(2013,'Ho Hey','The Lumineers','Indonesia',2),(2013,'Ho Hey','The Lumineers','Italy',1),(2013,'Ho Hey','The Lumineers','New Zealand',1),(2013,'Ho Hey','The Lumineers','United States',3),(2013,'Ho Hey','The Lumineers','Uruguay',1),(2013,'Stay','Rihanna Featuring Mikky Ekko','Ethiopia',2),(2013,'Stay','Rihanna Featuring Mikky Ekko','United States',3),(2013,'Get Lucky','Daft Punk Featuring Pharrell Williams','Ethiopia',1),(2013,'Get Lucky','Daft Punk Featuring Pharrell Williams','United States',5),(2013,'Royals','Lorde','Argentina',1),(2013,'Royals','Lorde','Brazil',2),(2013,'Royals','Lorde','Colombia',1),(2013,'Royals','Lorde','Ethiopia',11),(2013,'Royals','Lorde','Greece',1),(2013,'Royals','Lorde','Guernsey',1),(2013,'Royals','Lorde','India',2),(2013,'Royals','Lorde','Indonesia',2),(2013,'Royals','Lorde','Isle of Man',1),(2013,'Royals','Lorde','Japan',1),(2013,'Royals','Lorde','Kiribati',1),(2013,'Royals','Lorde','Mexico',1),(2013,'Royals','Lorde','United Kingdom',1),(2013,'Royals','Lorde','United States',6),(2013,'I Knew You Were Trouble.','Taylor Swift','Australia',1),(2013,'I Knew You Were Trouble.','Taylor Swift','Ethiopia',10),(2013,'I Knew You Were Trouble.','Taylor Swift','Indonesia',2),(2013,'I Knew You Were Trouble.','Taylor Swift','Japan',3),(2013,'I Knew You Were Trouble.','Taylor Swift','Morocco',1),(2013,'I Knew You Were Trouble.','Taylor Swift','Portugal',1),(2013,'I Knew You Were Trouble.','Taylor Swift','Thailand',1),(2013,'I Knew You Were Trouble.','Taylor Swift','Turkey',1),(2013,'I Knew You Were Trouble.','Taylor Swift','United States',2),(2013,'I Knew You Were Trouble.','Taylor Swift','Uruguay',1),(2013,'I Knew You Were Trouble.','Taylor Swift','Venezuela',1),(2013,'We Can\'T Stop','Miley Cyrus','Brazil',2),(2013,'We Can\'T Stop','Miley Cyrus','Colombia',1),(2013,'We Can\'T Stop','Miley Cyrus','Ecuador',1),(2013,'We Can\'T Stop','Miley Cyrus','Ethiopia',15),(2013,'We Can\'T Stop','Miley Cyrus','Germany',1),(2013,'We Can\'T Stop','Miley Cyrus','Guam',2),(2013,'We Can\'T Stop','Miley Cyrus','Indonesia',2),(2013,'We Can\'T Stop','Miley Cyrus','Jordan',1),(2013,'We Can\'T Stop','Miley Cyrus','Mauritius',1),(2013,'We Can\'T Stop','Miley Cyrus','Peru',1),(2013,'We Can\'T Stop','Miley Cyrus','United States',3),(2013,'We Can\'T Stop','Miley Cyrus','Venezuela',2),(2013,'Wrecking Ball','Miley Cyrus','Argentina',1),(2013,'Wrecking Ball','Miley Cyrus','Brazil',5),(2013,'Wrecking Ball','Miley Cyrus','Chile',1),(2013,'Wrecking Ball','Miley Cyrus','Colombia',1),(2013,'Wrecking Ball','Miley Cyrus','Ethiopia',19),(2013,'Wrecking Ball','Miley Cyrus','Indonesia',1),(2013,'Wrecking Ball','Miley Cyrus','Jamaica',1),(2013,'Wrecking Ball','Miley Cyrus','Paraguay',1),(2013,'Wrecking Ball','Miley Cyrus','Saint Vincent and the Grenadines',1),(2013,'Wrecking Ball','Miley Cyrus','Singapore',1),(2013,'Wrecking Ball','Miley Cyrus','United States',3),(2013,'Wake Me Up!','Avicii','Afghanistan',1),(2013,'Wake Me Up!','Avicii','Chile',1),(2013,'Wake Me Up!','Avicii','Colombia',3),(2013,'Wake Me Up!','Avicii','Ethiopia',11),(2013,'Wake Me Up!','Avicii','Indonesia',1),(2013,'Wake Me Up!','Avicii','Japan',3),(2013,'Wake Me Up!','Avicii','Malaysia',1),(2013,'Wake Me Up!','Avicii','Mexico',2),(2013,'Wake Me Up!','Avicii','Peru',1),(2013,'Wake Me Up!','Avicii','Russia',1),(2013,'Wake Me Up!','Avicii','United States',3),(2013,'Suit & Tie','Justin Timberlake Featuring JAY Z','Ethiopia',6),(2013,'Suit & Tie','Justin Timberlake Featuring JAY Z','France',1),(2013,'Suit & Tie','Justin Timberlake Featuring JAY Z','United States',2),(2012,'Somebody That I Used To Know','Gotye Featuring Kimbra','Ethiopia',4),(2012,'Somebody That I Used To Know','Gotye Featuring Kimbra','Indonesia',1),(2012,'Somebody That I Used To Know','Gotye Featuring Kimbra','United States',3),(2012,'Call Me Maybe','Carly Rae Jepsen','Australia',1),(2012,'Call Me Maybe','Carly Rae Jepsen','Austria',1),(2012,'Call Me Maybe','Carly Rae Jepsen','Brazil',2),(2012,'Call Me Maybe','Carly Rae Jepsen','Denmark',1),(2012,'Call Me Maybe','Carly Rae Jepsen','Dominican Republic',1),(2012,'Call Me Maybe','Carly Rae Jepsen','Ethiopia',13),(2012,'Call Me Maybe','Carly Rae Jepsen','Guernsey',1),(2012,'Call Me Maybe','Carly Rae Jepsen','Indonesia',3),(2012,'Call Me Maybe','Carly Rae Jepsen','Netherlands',1),(2012,'Call Me Maybe','Carly Rae Jepsen','Peru',1),(2012,'Call Me Maybe','Carly Rae Jepsen','Puerto Rico',1),(2012,'Call Me Maybe','Carly Rae Jepsen','United States',4),(2012,'Call Me Maybe','Carly Rae Jepsen','Vietnam',1),(2012,'We Are Young','fun. Featuring Janelle Monae','Antarctica',1),(2012,'We Are Young','fun. Featuring Janelle Monae','Brazil',1),(2012,'We Are Young','fun. Featuring Janelle Monae','Indonesia',1),(2012,'We Are Young','fun. Featuring Janelle Monae','United States',3),(2012,'Payphone','Maroon 5 Featuring Wiz Khalifa','Ethiopia',1),(2012,'Lights','Ellie Goulding','Argentina',4),(2012,'Lights','Ellie Goulding','Canada',3),(2012,'Lights','Ellie Goulding','Colombia',1),(2012,'Lights','Ellie Goulding','Ethiopia',9),(2012,'Lights','Ellie Goulding','France',1),(2012,'Lights','Ellie Goulding','Guernsey',1),(2012,'Lights','Ellie Goulding','Honduras',1),(2012,'Lights','Ellie Goulding','Isle of Man',2),(2012,'Lights','Ellie Goulding','Japan',1),(2012,'Lights','Ellie Goulding','Mexico',2),(2012,'Lights','Ellie Goulding','Netherlands',1),(2012,'Lights','Ellie Goulding','Poland',1),(2012,'Lights','Ellie Goulding','Puerto Rico',1),(2012,'Lights','Ellie Goulding','South Africa',1),(2012,'Lights','Ellie Goulding','Spain',1),(2012,'Lights','Ellie Goulding','United Kingdom',1),(2012,'Lights','Ellie Goulding','United States',5),(2012,'Glad You Came','The Wanted','Antigua and Barbuda',1),(2012,'Glad You Came','The Wanted','Brazil',1),(2012,'Glad You Came','The Wanted','Ethiopia',19),(2012,'Glad You Came','The Wanted','France',3),(2012,'Glad You Came','The Wanted','Indonesia',2),(2012,'Glad You Came','The Wanted','Japan',2),(2012,'Glad You Came','The Wanted','Panama',1),(2012,'Glad You Came','The Wanted','Poland',1),(2012,'Glad You Came','The Wanted','United Kingdom',1),(2012,'Glad You Came','The Wanted','United States',4),(2012,'Stronger (What Doesn\'T Kill You)','Kelly Clarkson','Antarctica',1),(2012,'Stronger (What Doesn\'T Kill You)','Kelly Clarkson','Brazil',1),(2012,'Stronger (What Doesn\'T Kill You)','Kelly Clarkson','Canada',3),(2012,'Stronger (What Doesn\'T Kill You)','Kelly Clarkson','Costa Rica',1),(2012,'Stronger (What Doesn\'T Kill You)','Kelly Clarkson','Egypt',1),(2012,'Stronger (What Doesn\'T Kill You)','Kelly Clarkson','Ethiopia',12),(2012,'Stronger (What Doesn\'T Kill You)','Kelly Clarkson','Indonesia',4),(2012,'Stronger (What Doesn\'T Kill You)','Kelly Clarkson','Netherlands',1),(2012,'Stronger (What Doesn\'T Kill You)','Kelly Clarkson','Philippines',1),(2012,'Stronger (What Doesn\'T Kill You)','Kelly Clarkson','Russia',1),(2012,'Stronger (What Doesn\'T Kill You)','Kelly Clarkson','United Kingdom',1),(2012,'Stronger (What Doesn\'T Kill You)','Kelly Clarkson','United States',5),(2012,'We Found Love','Rihanna Featuring Calvin Harris','United States',3),(2012,'Starships','Nicki Minaj','Brazil',1),(2012,'Starships','Nicki Minaj','Canada',1),(2012,'Starships','Nicki Minaj','Colombia',1),(2012,'Starships','Nicki Minaj','Ethiopia',22),(2012,'Starships','Nicki Minaj','Guam',1),(2012,'Starships','Nicki Minaj','Italy',2),(2012,'Starships','Nicki Minaj','Japan',2),(2012,'Starships','Nicki Minaj','Slovakia',2),(2012,'Starships','Nicki Minaj','South Africa',1),(2012,'Starships','Nicki Minaj','Spain',1),(2012,'What Makes You Beautiful','One Direction','Argentina',4),(2012,'What Makes You Beautiful','One Direction','Canada',2),(2012,'What Makes You Beautiful','One Direction','El Salvador',1),(2012,'What Makes You Beautiful','One Direction','Ethiopia',18),(2012,'What Makes You Beautiful','One Direction','United Kingdom',1),(2012,'What Makes You Beautiful','One Direction','United States',2),(2012,'Wild Ones','Flo Rida Featuring Sia','United States',2),(2012,'Set Fire To The Rain','Adele','Argentina',2),(2012,'Set Fire To The Rain','Adele','Bonaire',1),(2012,'Set Fire To The Rain','Adele','Brazil',1),(2012,'Set Fire To The Rain','Adele','Burkina Faso',1),(2012,'Set Fire To The Rain','Adele','Canada',1),(2012,'Set Fire To The Rain','Adele','Egypt',1),(2012,'Set Fire To The Rain','Adele','Ethiopia',12),(2012,'Set Fire To The Rain','Adele','France',1),(2012,'Set Fire To The Rain','Adele','Greece',1),(2012,'Set Fire To The Rain','Adele','India',1),(2012,'Set Fire To The Rain','Adele','Peru',1),(2012,'Set Fire To The Rain','Adele','United States',6),(2012,'Set Fire To The Rain','Adele','Uruguay',1),(2012,'Set Fire To The Rain','Adele','Venezuela',2),(2012,'Sexy And I Know It','LMFAO','',1),(2012,'Sexy And I Know It','LMFAO','Canada',3),(2012,'Sexy And I Know It','LMFAO','Ethiopia',11),(2012,'Sexy And I Know It','LMFAO','Germany',1),(2012,'Sexy And I Know It','LMFAO','Indonesia',2),(2012,'Sexy And I Know It','LMFAO','Mexico',1),(2012,'Sexy And I Know It','LMFAO','Poland',2),(2012,'Sexy And I Know It','LMFAO','Spain',1),(2012,'Sexy And I Know It','LMFAO','United Kingdom',2),(2012,'Sexy And I Know It','LMFAO','United States',3),(2012,'Sexy And I Know It','LMFAO','Western Sahara',1),(2012,'Some Nights','fun.','Austria',1),(2012,'Some Nights','fun.','Colombia',1),(2012,'Some Nights','fun.','Denmark',1),(2012,'Some Nights','fun.','Ethiopia',19),(2012,'Some Nights','fun.','Mauritius',1),(2012,'Some Nights','fun.','Philippines',1),(2012,'Some Nights','fun.','Russia',1),(2012,'Some Nights','fun.','United Arab Emirates',1),(2012,'Some Nights','fun.','United States',6),(2012,'Wide Awake','Katy Perry','Bahamas',1),(2012,'Wide Awake','Katy Perry','Brazil',1),(2012,'Wide Awake','Katy Perry','Canada',1),(2012,'Wide Awake','Katy Perry','Colombia',2),(2012,'Wide Awake','Katy Perry','Equatorial Guinea',1),(2012,'Wide Awake','Katy Perry','Ethiopia',18),(2012,'Wide Awake','Katy Perry','India',1),(2012,'Wide Awake','Katy Perry','Mexico',1),(2012,'Wide Awake','Katy Perry','South Korea',1),(2012,'Wide Awake','Katy Perry','United Kingdom',2),(2012,'Wide Awake','Katy Perry','United States',6),(2012,'Wide Awake','Katy Perry','Venezuela',1),(2012,'Good Feeling','Flo Rida','Australia',2),(2012,'Good Feeling','Flo Rida','Brazil',3),(2012,'Good Feeling','Flo Rida','Canada',2),(2012,'Good Feeling','Flo Rida','Chile',1),(2012,'Good Feeling','Flo Rida','Dominican Republic',1),(2012,'Good Feeling','Flo Rida','Ethiopia',13),(2012,'Good Feeling','Flo Rida','France',1),(2012,'Good Feeling','Flo Rida','Japan',7),(2012,'Good Feeling','Flo Rida','Mexico',1),(2012,'Good Feeling','Flo Rida','Spain',1),(2012,'Good Feeling','Flo Rida','United States',6),(2012,'Whistle','Flo Rida','Austria',2),(2012,'Whistle','Flo Rida','Brazil',1),(2012,'Whistle','Flo Rida','Colombia',4),(2012,'Whistle','Flo Rida','Ecuador',1),(2012,'Whistle','Flo Rida','Ethiopia',9),(2012,'Whistle','Flo Rida','France',1),(2012,'Whistle','Flo Rida','Germany',1),(2012,'Whistle','Flo Rida','Guam',1),(2012,'Whistle','Flo Rida','Indonesia',1),(2012,'Whistle','Flo Rida','Italy',1),(2012,'Whistle','Flo Rida','Japan',5),(2012,'Whistle','Flo Rida','Sweden',1),(2012,'Whistle','Flo Rida','Thailand',1),(2012,'Whistle','Flo Rida','United Kingdom',1),(2012,'Whistle','Flo Rida','United States',5),(2012,'One More Night','Maroon 5','Argentina',1),(2012,'One More Night','Maroon 5','Canada',2),(2012,'One More Night','Maroon 5','Ethiopia',11),(2012,'One More Night','Maroon 5','Indonesia',1),(2012,'One More Night','Maroon 5','Ireland',1),(2012,'One More Night','Maroon 5','Isle of Man',1),(2012,'One More Night','Maroon 5','Japan',1),(2012,'One More Night','Maroon 5','Macedonia',2),(2012,'One More Night','Maroon 5','Malaysia',1),(2012,'One More Night','Maroon 5','United States',9),(2012,'One More Night','Maroon 5','Venezuela',1),(2012,'Drive By','Train','Antarctica',1),(2012,'Drive By','Train','Austria',2),(2012,'Drive By','Train','Canada',1),(2012,'Drive By','Train','Chile',1),(2012,'Drive By','Train','Ethiopia',8),(2012,'Drive By','Train','Finland',2),(2012,'Drive By','Train','Germany',1),(2012,'Drive By','Train','Indonesia',5),(2012,'Drive By','Train','Ireland',1),(2012,'Drive By','Train','Italy',2),(2012,'Drive By','Train','Switzerland',1),(2012,'Drive By','Train','United Kingdom',4),(2012,'Drive By','Train','United States',4),(2012,'Drive By','Train','Uruguay',1),(2011,'Rolling In The Deep','Adele','Argentina',1),(2011,'Rolling In The Deep','Adele','Belgium',1),(2011,'Rolling In The Deep','Adele','Brazil',3),(2011,'Rolling In The Deep','Adele','Colombia',1),(2011,'Rolling In The Deep','Adele','Ecuador',1),(2011,'Rolling In The Deep','Adele','Ethiopia',13),(2011,'Rolling In The Deep','Adele','Indonesia',1),(2011,'Rolling In The Deep','Adele','Japan',1),(2011,'Rolling In The Deep','Adele','Panama',1),(2011,'Rolling In The Deep','Adele','South Africa',1),(2011,'Rolling In The Deep','Adele','United Kingdom',5),(2011,'Rolling In The Deep','Adele','United States',4),(2011,'Rolling In The Deep','Adele','Venezuela',1),(2011,'Party Rock Anthem','LMFAO Featuring Lauren Bennett & GoonRock','Netherlands',1),(2011,'Firework','Katy Perry','Brazil',1),(2011,'Firework','Katy Perry','Canada',1),(2011,'Firework','Katy Perry','Egypt',1),(2011,'Firework','Katy Perry','Ethiopia',13),(2011,'Firework','Katy Perry','Martinique',1),(2011,'Firework','Katy Perry','United States',4),(2011,'Firework','Katy Perry','Venezuela',1),(2011,'E.T.','Katy Perry Featuring Kanye West','Ethiopia',1),(2011,'E.T.','Katy Perry Featuring Kanye West','United States',4),(2011,'Give Me Everything','\"Pitbull Featuring Ne-Yo, Afrojack & Nayer\"','Canada',2),(2011,'Grenade','Bruno Mars','Austria',1),(2011,'Grenade','Bruno Mars','Colombia',3),(2011,'Grenade','Bruno Mars','Ethiopia',13),(2011,'Grenade','Bruno Mars','India',1),(2011,'Grenade','Bruno Mars','Indonesia',2),(2011,'Grenade','Bruno Mars','Malaysia',1),(2011,'Grenade','Bruno Mars','Mexico',1),(2011,'Grenade','Bruno Mars','Peru',2),(2011,'Grenade','Bruno Mars','United States',5),(2011,'Grenade','Bruno Mars','Venezuela',1),(2011,'Grenade','Bruno Mars','Vietnam',1),(2011,'Super Bass','Nicki Minaj','Brazil',5),(2011,'Super Bass','Nicki Minaj','Cameroon',1),(2011,'Super Bass','Nicki Minaj','Colombia',1),(2011,'Super Bass','Nicki Minaj','Ethiopia',17),(2011,'Super Bass','Nicki Minaj','New Zealand',1),(2011,'Super Bass','Nicki Minaj','Peru',1),(2011,'Super Bass','Nicki Minaj','Puerto Rico',1),(2011,'Super Bass','Nicki Minaj','Spain',1),(2011,'Super Bass','Nicki Minaj','United States',3),(2011,'Super Bass','Nicki Minaj','Venezuela',1),(2011,'Moves Like Jagger','Maroon 5 Featuring Christina Aguilera','Canada',2),(2011,'Moves Like Jagger','Maroon 5 Featuring Christina Aguilera','Ethiopia',6),(2011,'Moves Like Jagger','Maroon 5 Featuring Christina Aguilera','France',1),(2011,'Moves Like Jagger','Maroon 5 Featuring Christina Aguilera','Mexico',1),(2011,'Moves Like Jagger','Maroon 5 Featuring Christina Aguilera','Singapore',1),(2011,'Moves Like Jagger','Maroon 5 Featuring Christina Aguilera','United States',2),(2011,'Just Can\'T Get Enough','The Black Eyed Peas','Brazil',6),(2011,'Just Can\'T Get Enough','The Black Eyed Peas','Canada',2),(2011,'Just Can\'T Get Enough','The Black Eyed Peas','Ecuador',1),(2011,'Just Can\'T Get Enough','The Black Eyed Peas','El Salvador',2),(2011,'Just Can\'T Get Enough','The Black Eyed Peas','Ethiopia',15),(2011,'Just Can\'T Get Enough','The Black Eyed Peas','Germany',1),(2011,'Just Can\'T Get Enough','The Black Eyed Peas','Guatemala',1),(2011,'Just Can\'T Get Enough','The Black Eyed Peas','Iraq',1),(2011,'Just Can\'T Get Enough','The Black Eyed Peas','Mexico',1),(2011,'Just Can\'T Get Enough','The Black Eyed Peas','Nigeria',1),(2011,'Just Can\'T Get Enough','The Black Eyed Peas','United States',2),(2011,'Just Can\'T Get Enough','The Black Eyed Peas','Venezuela',2),(2011,'On The Floor','Jennifer Lopez Featuring Pitbull','Ethiopia',1),(2011,'On The Floor','Jennifer Lopez Featuring Pitbull','United States',2),(2011,'S&M','Rihanna','Brazil',5),(2011,'S&M','Rihanna','Canada',2),(2011,'S&M','Rihanna','Ethiopia',14),(2011,'S&M','Rihanna','India',1),(2011,'S&M','Rihanna','Mexico',1),(2011,'S&M','Rihanna','Morocco',1),(2011,'S&M','Rihanna','United States',3),(2011,'S&M','Rihanna','Uruguay',1),(2011,'Pumped Up Kicks','Foster The People','Argentina',1),(2011,'Pumped Up Kicks','Foster The People','Australia',1),(2011,'Pumped Up Kicks','Foster The People','Bolivia',1),(2011,'Pumped Up Kicks','Foster The People','Chile',2),(2011,'Pumped Up Kicks','Foster The People','Costa Rica',1),(2011,'Pumped Up Kicks','Foster The People','Ethiopia',13),(2011,'Pumped Up Kicks','Foster The People','Greece',1),(2011,'Pumped Up Kicks','Foster The People','Guam',1),(2011,'Pumped Up Kicks','Foster The People','Malta',1),(2011,'Pumped Up Kicks','Foster The People','Mexico',2),(2011,'Pumped Up Kicks','Foster The People','United Kingdom',1),(2011,'Pumped Up Kicks','Foster The People','United States',4),(2011,'Last Friday Night (T.G.I.F.)','Katy Perry','Brazil',3),(2011,'Last Friday Night (T.G.I.F.)','Katy Perry','Canada',2),(2011,'Last Friday Night (T.G.I.F.)','Katy Perry','Ethiopia',10),(2011,'Last Friday Night (T.G.I.F.)','Katy Perry','Greece',2),(2011,'Last Friday Night (T.G.I.F.)','Katy Perry','Guatemala',2),(2011,'Last Friday Night (T.G.I.F.)','Katy Perry','Indonesia',2),(2011,'Last Friday Night (T.G.I.F.)','Katy Perry','Italy',1),(2011,'Last Friday Night (T.G.I.F.)','Katy Perry','Japan',1),(2011,'Last Friday Night (T.G.I.F.)','Katy Perry','Netherlands',1),(2011,'Last Friday Night (T.G.I.F.)','Katy Perry','Peru',1),(2011,'Last Friday Night (T.G.I.F.)','Katy Perry','South Korea',1),(2011,'Last Friday Night (T.G.I.F.)','Katy Perry','United Kingdom',1),(2011,'Last Friday Night (T.G.I.F.)','Katy Perry','United States',1),(2011,'Just The Way You Are','Bruno Mars','Brazil',1),(2011,'Just The Way You Are','Bruno Mars','Ethiopia',19),(2011,'Just The Way You Are','Bruno Mars','Indonesia',4),(2011,'Just The Way You Are','Bruno Mars','Japan',6),(2011,'Just The Way You Are','Bruno Mars','Jordan',1),(2011,'Just The Way You Are','Bruno Mars','Switzerland',1),(2011,'Just The Way You Are','Bruno Mars','United States',1),(2011,'Just The Way You Are','Bruno Mars','Venezuela',2),(2011,'Raise Your Glass','P!nk','Australia',2),(2011,'Raise Your Glass','P!nk','Canada',6),(2011,'Raise Your Glass','P!nk','Colombia',1),(2011,'Raise Your Glass','P!nk','Ethiopia',16),(2011,'Raise Your Glass','P!nk','Japan',2),(2011,'Raise Your Glass','P!nk','Mexico',1),(2011,'Raise Your Glass','P!nk','Netherlands',1),(2011,'Raise Your Glass','P!nk','Poland',1),(2011,'Raise Your Glass','P!nk','Portugal',1),(2011,'Raise Your Glass','P!nk','Turkey',1),(2011,'Raise Your Glass','P!nk','United Kingdom',1),(2011,'Raise Your Glass','P!nk','United States',3),(2011,'Born This Way','Lady Gaga','Australia',2),(2011,'Born This Way','Lady Gaga','Ethiopia',27),(2011,'Born This Way','Lady Gaga','Honduras',1),(2011,'Born This Way','Lady Gaga','Peru',3),(2011,'Born This Way','Lady Gaga','Portugal',3),(2011,'Born This Way','Lady Gaga','United States',2),(2011,'F**Kin\' Perfect','P!nk','Australia',1),(2011,'F**Kin\' Perfect','P!nk','Canada',1),(2011,'F**Kin\' Perfect','P!nk','Ethiopia',16),(2011,'F**Kin\' Perfect','P!nk','Greece',1),(2011,'F**Kin\' Perfect','P!nk','Italy',1),(2011,'F**Kin\' Perfect','P!nk','Japan',2),(2011,'F**Kin\' Perfect','P!nk','Mexico',2),(2011,'F**Kin\' Perfect','P!nk','South Korea',1),(2011,'F**Kin\' Perfect','P!nk','Spain',1),(2011,'F**Kin\' Perfect','P!nk','United Kingdom',1),(2011,'F**Kin\' Perfect','P!nk','United States',4),(2011,'What\'S My Name?','Rihanna Featuring Drake','United States',9),(2010,'Need You Now','Lady Antebellum','Brazil',2),(2010,'Need You Now','Lady Antebellum','Canada',1),(2010,'Need You Now','Lady Antebellum','Ethiopia',12),(2010,'Need You Now','Lady Antebellum','Indonesia',4),(2010,'Need You Now','Lady Antebellum','Mexico',2),(2010,'Need You Now','Lady Antebellum','South Africa',1),(2010,'Need You Now','Lady Antebellum','Spain',1),(2010,'Need You Now','Lady Antebellum','Trinidad and Tobago',1),(2010,'Need You Now','Lady Antebellum','United States',11),(2010,'Hey, Soul Sister','Train','Antarctica',1),(2010,'Hey, Soul Sister','Train','Argentina',2),(2010,'Hey, Soul Sister','Train','Brazil',1),(2010,'Hey, Soul Sister','Train','Canada',2),(2010,'Hey, Soul Sister','Train','Colombia',1),(2010,'Hey, Soul Sister','Train','Ecuador',1),(2010,'Hey, Soul Sister','Train','Ethiopia',6),(2010,'Hey, Soul Sister','Train','France',1),(2010,'Hey, Soul Sister','Train','Indonesia',4),(2010,'Hey, Soul Sister','Train','Peru',1),(2010,'Hey, Soul Sister','Train','United States',13),(2010,'Hey, Soul Sister','Train','Uruguay',1),(2010,'Hey, Soul Sister','Train','Venezuela',1),(2010,'California Gurls','Katy Perry Featuring Snoop Dogg','Ethiopia',1),(2010,'California Gurls','Katy Perry Featuring Snoop Dogg','United States',1),(2010,'Omg','Usher Featuring will.i.am','Ethiopia',1),(2010,'Omg','Usher Featuring will.i.am','Jamaica',1),(2010,'Omg','Usher Featuring will.i.am','United States',2),(2010,'Airplanes','B.o.B Featuring Hayley Williams','Brazil',1),(2010,'Airplanes','B.o.B Featuring Hayley Williams','United Kingdom',1),(2010,'Airplanes','B.o.B Featuring Hayley Williams','United States',3),(2010,'Love The Way You Lie','Eminem Featuring Rihanna','Australia',1),(2010,'Love The Way You Lie','Eminem Featuring Rihanna','Ethiopia',5),(2010,'Love The Way You Lie','Eminem Featuring Rihanna','United States',2),(2010,'Bad Romance','Lady Gaga','Australia',1),(2010,'Bad Romance','Lady Gaga','Bolivia',4),(2010,'Bad Romance','Lady Gaga','Brazil',7),(2010,'Bad Romance','Lady Gaga','Colombia',1),(2010,'Bad Romance','Lady Gaga','Costa Rica',1),(2010,'Bad Romance','Lady Gaga','Ethiopia',19),(2010,'Bad Romance','Lady Gaga','Portugal',2),(2010,'Bad Romance','Lady Gaga','Sri Lanka',1),(2010,'Bad Romance','Lady Gaga','United Kingdom',1),(2010,'Bad Romance','Lady Gaga','United States',1),(2010,'Dynamite','Taio Cruz','Argentina',1),(2010,'Dynamite','Taio Cruz','Australia',1),(2010,'Dynamite','Taio Cruz','Canada',1),(2010,'Dynamite','Taio Cruz','Czech Republic',1),(2010,'Dynamite','Taio Cruz','Ethiopia',17),(2010,'Dynamite','Taio Cruz','Germany',1),(2010,'Dynamite','Taio Cruz','Guam',2),(2010,'Dynamite','Taio Cruz','Mexico',1),(2010,'Dynamite','Taio Cruz','United Kingdom',1),(2010,'Dynamite','Taio Cruz','United States',11),(2010,'Nothin\' On You','B.o.B Featuring Bruno Mars','Ethiopia',1),(2010,'I Like It','Enrique Iglesias Featuring Pitbull','Canada',2),(2010,'Bedrock','Young Money Featuring Lloyd','United States',2),(2010,'In My Head','Jason Derulo','Australia',1),(2010,'In My Head','Jason Derulo','Belgium',1),(2010,'In My Head','Jason Derulo','Benin',1),(2010,'In My Head','Jason Derulo','Canada',1),(2010,'In My Head','Jason Derulo','Ethiopia',17),(2010,'In My Head','Jason Derulo','Indonesia',3),(2010,'In My Head','Jason Derulo','Italy',1),(2010,'In My Head','Jason Derulo','Macedonia',1),(2010,'In My Head','Jason Derulo','Mexico',1),(2010,'In My Head','Jason Derulo','Russia',1),(2010,'In My Head','Jason Derulo','U.S. Minor Outlying Islands',1),(2010,'In My Head','Jason Derulo','United Kingdom',4),(2010,'In My Head','Jason Derulo','United States',2),(2010,'In My Head','Jason Derulo','Vietnam',1),(2010,'Rude Boy','Rihanna','Brazil',12),(2010,'Rude Boy','Rihanna','Ethiopia',9),(2010,'Rude Boy','Rihanna','France',1),(2010,'Rude Boy','Rihanna','Georgia',1),(2010,'Rude Boy','Rihanna','Indonesia',1),(2010,'Rude Boy','Rihanna','Sweden',1),(2010,'Rude Boy','Rihanna','United Kingdom',2),(2010,'Rude Boy','Rihanna','United States',6),(2010,'Rude Boy','Rihanna','Venezuela',1),(2010,'Rude Boy','Rihanna','Yemen',1),(2010,'Telephone','Lady Gaga Featuring Beyonce','Australia',1),(2010,'Teenage Dream','Katy Perry','Brazil',7),(2010,'Teenage Dream','Katy Perry','Cambodia',1),(2010,'Teenage Dream','Katy Perry','Ethiopia',7),(2010,'Teenage Dream','Katy Perry','France',1),(2010,'Teenage Dream','Katy Perry','Greece',1),(2010,'Teenage Dream','Katy Perry','India',2),(2010,'Teenage Dream','Katy Perry','Latvia',1),(2010,'Teenage Dream','Katy Perry','Mexico',2),(2010,'Teenage Dream','Katy Perry','United States',6),(2010,'Teenage Dream','Katy Perry','Vietnam',1),(2010,'Just The Way You Are','Bruno Mars','Brazil',1),(2010,'Just The Way You Are','Bruno Mars','Ethiopia',21),(2010,'Just The Way You Are','Bruno Mars','Indonesia',4),(2010,'Just The Way You Are','Bruno Mars','Japan',6),(2010,'Just The Way You Are','Bruno Mars','Jordan',1),(2010,'Just The Way You Are','Bruno Mars','Switzerland',1),(2010,'Just The Way You Are','Bruno Mars','United States',1),(2010,'Just The Way You Are','Bruno Mars','Venezuela',2),(2010,'Cooler Than Me','Mike Posner','Bonaire',1),(2010,'Cooler Than Me','Mike Posner','Canada',2),(2010,'Cooler Than Me','Mike Posner','Ethiopia',14),(2010,'Cooler Than Me','Mike Posner','France',1),(2010,'Cooler Than Me','Mike Posner','Germany',1),(2010,'Cooler Than Me','Mike Posner','Ghana',1),(2010,'Cooler Than Me','Mike Posner','India',1),(2010,'Cooler Than Me','Mike Posner','Italy',2),(2010,'Cooler Than Me','Mike Posner','Jordan',1),(2010,'Cooler Than Me','Mike Posner','Kenya',1),(2010,'Cooler Than Me','Mike Posner','Philippines',1),(2010,'Cooler Than Me','Mike Posner','South Korea',1),(2010,'Cooler Than Me','Mike Posner','United States',4),(2010,'Imma Be','The Black Eyed Peas','Brazil',1),(2010,'Imma Be','The Black Eyed Peas','Canada',4),(2010,'Imma Be','The Black Eyed Peas','Colombia',1),(2010,'Imma Be','The Black Eyed Peas','Ethiopia',9),(2010,'Imma Be','The Black Eyed Peas','France',1),(2010,'Imma Be','The Black Eyed Peas','Guam',3),(2010,'Imma Be','The Black Eyed Peas','Japan',1),(2010,'Imma Be','The Black Eyed Peas','Lebanon',1),(2010,'Imma Be','The Black Eyed Peas','Russia',2),(2010,'Imma Be','The Black Eyed Peas','United States',9),(2010,'Imma Be','The Black Eyed Peas','Uruguay',1),(2009,'Boom Boom Pow','The Black Eyed Peas','',1),(2009,'Boom Boom Pow','The Black Eyed Peas','Bangladesh',1),(2009,'Boom Boom Pow','The Black Eyed Peas','Ethiopia',22),(2009,'Boom Boom Pow','The Black Eyed Peas','Greece',1),(2009,'Boom Boom Pow','The Black Eyed Peas','Guam',1),(2009,'Boom Boom Pow','The Black Eyed Peas','Italy',2),(2009,'Boom Boom Pow','The Black Eyed Peas','Japan',1),(2009,'Boom Boom Pow','The Black Eyed Peas','Northern Mariana Islands',1),(2009,'Boom Boom Pow','The Black Eyed Peas','Turkey',2),(2009,'Boom Boom Pow','The Black Eyed Peas','United States',3),(2009,'Boom Boom Pow','The Black Eyed Peas','Uruguay',1),(2009,'Boom Boom Pow','The Black Eyed Peas','Venezuela',1),(2009,'Boom Boom Pow','The Black Eyed Peas','Vietnam',1),(2009,'Poker Face','Lady Gaga','Australia',2),(2009,'Poker Face','Lady Gaga','Bolivia',2),(2009,'Poker Face','Lady Gaga','Brazil',6),(2009,'Poker Face','Lady Gaga','Colombia',1),(2009,'Poker Face','Lady Gaga','Costa Rica',1),(2009,'Poker Face','Lady Gaga','Ethiopia',23),(2009,'Just Dance','Lady Gaga Featuring Colby O\'Donis','United States',2),(2009,'I Gotta Feeling','The Black Eyed Peas','Australia',1),(2009,'I Gotta Feeling','The Black Eyed Peas','Brazil',2),(2009,'I Gotta Feeling','The Black Eyed Peas','Canada',2),(2009,'I Gotta Feeling','The Black Eyed Peas','Chile',1),(2009,'I Gotta Feeling','The Black Eyed Peas','Colombia',3),(2009,'I Gotta Feeling','The Black Eyed Peas','Costa Rica',1),(2009,'I Gotta Feeling','The Black Eyed Peas','El Salvador',1),(2009,'I Gotta Feeling','The Black Eyed Peas','Ethiopia',10),(2009,'I Gotta Feeling','The Black Eyed Peas','Italy',1),(2009,'I Gotta Feeling','The Black Eyed Peas','Japan',1),(2009,'I Gotta Feeling','The Black Eyed Peas','New Zealand',1),(2009,'I Gotta Feeling','The Black Eyed Peas','Papua New Guinea',1),(2009,'I Gotta Feeling','The Black Eyed Peas','Peru',1),(2009,'I Gotta Feeling','The Black Eyed Peas','Philippines',1),(2009,'I Gotta Feeling','The Black Eyed Peas','Spain',1),(2009,'I Gotta Feeling','The Black Eyed Peas','United Arab Emirates',1),(2009,'I Gotta Feeling','The Black Eyed Peas','United Kingdom',1),(2009,'I Gotta Feeling','The Black Eyed Peas','United States',7),(2009,'Love Story','Taylor Swift','Brazil',1),(2009,'Love Story','Taylor Swift','Ethiopia',10),(2009,'Love Story','Taylor Swift','India',1),(2009,'Love Story','Taylor Swift','Japan',1),(2009,'Love Story','Taylor Swift','Kyrgyzstan',1),(2009,'Love Story','Taylor Swift','Philippines',1),(2009,'Love Story','Taylor Swift','United Kingdom',1),(2009,'Love Story','Taylor Swift','United States',2),(2009,'Love Story','Taylor Swift','Vietnam',1),(2009,'Right Round','Flo Rida','Armenia',1),(2009,'Right Round','Flo Rida','Brazil',1),(2009,'Right Round','Flo Rida','Canada',1),(2009,'Right Round','Flo Rida','Ethiopia',10),(2009,'Right Round','Flo Rida','Italy',1),(2009,'Right Round','Flo Rida','Japan',18),(2009,'Right Round','Flo Rida','Mexico',1),(2009,'Right Round','Flo Rida','Netherlands',1),(2009,'Right Round','Flo Rida','Puerto Rico',1),(2009,'Right Round','Flo Rida','Russia',1),(2009,'Right Round','Flo Rida','United States',3),(2009,'I\'M Yours','Jason Mraz','Albania',1),(2009,'I\'M Yours','Jason Mraz','Ethiopia',8),(2009,'I\'M Yours','Jason Mraz','Germany',1),(2009,'I\'M Yours','Jason Mraz','Guam',1),(2009,'I\'M Yours','Jason Mraz','Iceland',1),(2009,'I\'M Yours','Jason Mraz','Indonesia',1),(2009,'I\'M Yours','Jason Mraz','Iran',1),(2009,'I\'M Yours','Jason Mraz','Mexico',2),(2009,'I\'M Yours','Jason Mraz','Peru',1),(2009,'I\'M Yours','Jason Mraz','Russia',1),(2009,'I\'M Yours','Jason Mraz','United States',2),(2009,'Single Ladies (Put A Ring On It)','Beyonce','Argentina',1),(2009,'Single Ladies (Put A Ring On It)','Beyonce','Australia',1),(2009,'Single Ladies (Put A Ring On It)','Beyonce','Canada',3),(2009,'Single Ladies (Put A Ring On It)','Beyonce','Chile',1),(2009,'Single Ladies (Put A Ring On It)','Beyonce','Ethiopia',14),(2009,'Single Ladies (Put A Ring On It)','Beyonce','Indonesia',4),(2009,'Single Ladies (Put A Ring On It)','Beyonce','Japan',1),(2009,'Single Ladies (Put A Ring On It)','Beyonce','Mexico',1),(2009,'Single Ladies (Put A Ring On It)','Beyonce','New Zealand',1),(2009,'Single Ladies (Put A Ring On It)','Beyonce','Spain',1),(2009,'Single Ladies (Put A Ring On It)','Beyonce','United States',4),(2009,'Single Ladies (Put A Ring On It)','Beyonce','Venezuela',2),(2009,'Heartless','Kanye West','Afghanistan',1),(2009,'Heartless','Kanye West','Canada',2),(2009,'Heartless','Kanye West','Chile',1),(2009,'Heartless','Kanye West','Ethiopia',17),(2009,'Heartless','Kanye West','Indonesia',1),(2009,'Heartless','Kanye West','Mexico',1),(2009,'Heartless','Kanye West','Sint Maarten',1),(2009,'Heartless','Kanye West','Turkey',1),(2009,'Heartless','Kanye West','United States',5),(2009,'Heartless','Kanye West','Venezuela',1),(2009,'Gives You Hell','The All-American Rejects','Antarctica',1),(2009,'Gives You Hell','The All-American Rejects','Canada',3),(2009,'Gives You Hell','The All-American Rejects','Ethiopia',12),(2009,'Gives You Hell','The All-American Rejects','Germany',1),(2009,'Gives You Hell','The All-American Rejects','Guam',1),(2009,'Gives You Hell','The All-American Rejects','Indonesia',1),(2009,'Gives You Hell','The All-American Rejects','Japan',1),(2009,'Gives You Hell','The All-American Rejects','Jordan',1),(2009,'Gives You Hell','The All-American Rejects','Mexico',1),(2009,'Gives You Hell','The All-American Rejects','Spain',1),(2009,'Gives You Hell','The All-American Rejects','Sri Lanka',1),(2009,'Gives You Hell','The All-American Rejects','United States',5),(2009,'You Belong With Me','Taylor Swift','Argentina',1),(2009,'You Belong With Me','Taylor Swift','Ethiopia',14),(2009,'You Belong With Me','Taylor Swift','France',1),(2009,'You Belong With Me','Taylor Swift','Greece',1),(2009,'You Belong With Me','Taylor Swift','India',1),(2009,'You Belong With Me','Taylor Swift','Japan',2),(2009,'You Belong With Me','Taylor Swift','Philippines',1),(2009,'You Belong With Me','Taylor Swift','Singapore',1),(2009,'You Belong With Me','Taylor Swift','United States',5),(2009,'Dead And Gone','T.I. Featuring Justin Timberlake','Iceland',1),(2009,'You Found Me','The Fray','Argentina',2),(2009,'You Found Me','The Fray','Australia',1),(2009,'You Found Me','The Fray','Brazil',2),(2009,'You Found Me','The Fray','Canada',3),(2009,'You Found Me','The Fray','Ethiopia',16),(2009,'You Found Me','The Fray','Portugal',1),(2009,'You Found Me','The Fray','United Kingdom',1),(2009,'You Found Me','The Fray','United States',3),(2009,'Use Somebody','Kings Of Leon','Australia',1),(2009,'Use Somebody','Kings Of Leon','Belgium',1),(2009,'Use Somebody','Kings Of Leon','Brazil',2),(2009,'Use Somebody','Kings Of Leon','Ethiopia',12),(2009,'Use Somebody','Kings Of Leon','Ghana',1),(2009,'Use Somebody','Kings Of Leon','Italy',2),(2009,'Use Somebody','Kings Of Leon','Lebanon',1),(2009,'Use Somebody','Kings Of Leon','United Kingdom',4),(2009,'Use Somebody','Kings Of Leon','United States',3),(2009,'Knock You Down','Keri Hilson Featuring Kanye West & Ne-Yo','Iceland',2),(2009,'Blame It','Jamie Foxx Featuring T-Pain','Serbia',1),(2009,'Blame It','Jamie Foxx Featuring T-Pain','United States',2),(2009,'I Know You Want Me (Calle Ocho)','Pitbull','Afghanistan',1),(2009,'I Know You Want Me (Calle Ocho)','Pitbull','Canada',3),(2009,'I Know You Want Me (Calle Ocho)','Pitbull','Ethiopia',18),(2009,'I Know You Want Me (Calle Ocho)','Pitbull','Germany',1),(2009,'I Know You Want Me (Calle Ocho)','Pitbull','Guam',1),(2009,'I Know You Want Me (Calle Ocho)','Pitbull','Indonesia',1),(2009,'I Know You Want Me (Calle Ocho)','Pitbull','Italy',1),(2009,'I Know You Want Me (Calle Ocho)','Pitbull','Japan',8),(2009,'I Know You Want Me (Calle Ocho)','Pitbull','Spain',1),(2009,'I Know You Want Me (Calle Ocho)','Pitbull','United Kingdom',1),(2009,'I Know You Want Me (Calle Ocho)','Pitbull','United States',2),(2009,'Live Your Life','T.I. Featuring Rihanna','Ethiopia',1),(2009,'Live Your Life','T.I. Featuring Rihanna','Iceland',5),(2009,'Kiss Me Thru The Phone','Soulja Boy Tell \'em Featuring Sammie','United States',10),(2009,'Down','Jay Sean Featuring Lil Wayne','Iceland',1),(2009,'Down','Jay Sean Featuring Lil Wayne','Indonesia',1),(2009,'Down','Jay Sean Featuring Lil Wayne','United States',1),(2008,'Bleeding Love','Leona Lewis','Australia',1),(2008,'Bleeding Love','Leona Lewis','Austria',1),(2008,'Bleeding Love','Leona Lewis','Brazil',3),(2008,'Bleeding Love','Leona Lewis','Canada',2),(2008,'Bleeding Love','Leona Lewis','Cayman Islands',1),(2008,'Bleeding Love','Leona Lewis','Cuba',2),(2008,'Bleeding Love','Leona Lewis','Czech Republic',1),(2008,'Bleeding Love','Leona Lewis','Ethiopia',11),(2008,'Bleeding Love','Leona Lewis','France',1),(2008,'Bleeding Love','Leona Lewis','Italy',1),(2008,'Bleeding Love','Leona Lewis','Thailand',1),(2008,'Bleeding Love','Leona Lewis','United Arab Emirates',1),(2008,'Bleeding Love','Leona Lewis','United States',6),(2008,'No One','Alicia Keys','Brazil',2),(2008,'No One','Alicia Keys','Canada',1),(2008,'No One','Alicia Keys','Chile',1),(2008,'No One','Alicia Keys','Ethiopia',16),(2008,'No One','Alicia Keys','Mongolia',1),(2008,'No One','Alicia Keys','Nigeria',1),(2008,'No One','Alicia Keys','Northern Mariana Islands',1),(2008,'No One','Alicia Keys','Sweden',1),(2008,'No One','Alicia Keys','United Kingdom',1),(2008,'No One','Alicia Keys','United States',6),(2008,'Apologize','Timbaland Featuring OneRepublic','Ethiopia',3),(2008,'Apologize','Timbaland Featuring OneRepublic','South Africa',1),(2008,'Apologize','Timbaland Featuring OneRepublic','United States',4),(2008,'No Air','Jordin Sparks Duet With Chris Brown','Cuba',2),(2008,'No Air','Jordin Sparks Duet With Chris Brown','Germany',1),(2008,'No Air','Jordin Sparks Duet With Chris Brown','North Korea',1),(2008,'No Air','Jordin Sparks Duet With Chris Brown','Papua New Guinea',3),(2008,'No Air','Jordin Sparks Duet With Chris Brown','Uruguay',1),(2008,'Love Song','Sara Bareilles','Australia',1),(2008,'Love Song','Sara Bareilles','Brazil',2),(2008,'Love Song','Sara Bareilles','Colombia',2),(2008,'Love Song','Sara Bareilles','Egypt',1),(2008,'Love Song','Sara Bareilles','Ethiopia',15),(2008,'Love Song','Sara Bareilles','Germany',1),(2008,'Love Song','Sara Bareilles','Indonesia',1),(2008,'Love Song','Sara Bareilles','Isle of Man',1),(2008,'Love Song','Sara Bareilles','Japan',2),(2008,'Love Song','Sara Bareilles','Netherlands',1),(2008,'Love Song','Sara Bareilles','Philippines',2),(2008,'Love Song','Sara Bareilles','United Kingdom',1),(2008,'Love Song','Sara Bareilles','United States',4),(2008,'Love In This Club','Usher Featuring Young Jeezy','France',1),(2008,'Love In This Club','Usher Featuring Young Jeezy','Switzerland',2),(2008,'With You','Chris Brown','Brazil',2),(2008,'With You','Chris Brown','Ethiopia',19),(2008,'With You','Chris Brown','Lesotho',1),(2008,'With You','Chris Brown','Mexico',1),(2008,'With You','Chris Brown','Mongolia',1),(2008,'With You','Chris Brown','Palestine',1),(2008,'With You','Chris Brown','Philippines',1),(2008,'With You','Chris Brown','Switzerland',1),(2008,'With You','Chris Brown','United States',7),(2008,'Forever','Chris Brown','Antarctica',1),(2008,'Forever','Chris Brown','Argentina',1),(2008,'Forever','Chris Brown','Brazil',2),(2008,'Forever','Chris Brown','Ethiopia',10),(2008,'Forever','Chris Brown','France',1),(2008,'Forever','Chris Brown','India',1),(2008,'Forever','Chris Brown','United States',8),(2008,'Sexy Can I','Ray J & Yung Berg','Canada',1),(2008,'Sexy Can I','Ray J & Yung Berg','Ethiopia',7),(2008,'Sexy Can I','Ray J & Yung Berg','France',1),(2008,'Sexy Can I','Ray J & Yung Berg','Guam',3),(2008,'Sexy Can I','Ray J & Yung Berg','Malaysia',1),(2008,'Sexy Can I','Ray J & Yung Berg','Papua New Guinea',2),(2008,'Sexy Can I','Ray J & Yung Berg','Philippines',1),(2008,'Sexy Can I','Ray J & Yung Berg','Puerto Rico',1),(2008,'Sexy Can I','Ray J & Yung Berg','United Arab Emirates',2),(2008,'Sexy Can I','Ray J & Yung Berg','United States',5),(2008,'Sexy Can I','Ray J & Yung Berg','Uruguay',1),(2008,'Take A Bow','Rihanna','Brazil',3),(2008,'Take A Bow','Rihanna','Canada',1),(2008,'Take A Bow','Rihanna','Ethiopia',25),(2008,'Take A Bow','Rihanna','Guernsey',1),(2008,'Take A Bow','Rihanna','Japan',1),(2008,'Take A Bow','Rihanna','Puerto Rico',1),(2008,'Take A Bow','Rihanna','United States',6),(2008,'Viva La Vida','Coldplay','Antarctica',1),(2008,'Viva La Vida','Coldplay','Argentina',1),(2008,'Viva La Vida','Coldplay','Australia',2),(2008,'Viva La Vida','Coldplay','Belgium',1),(2008,'Viva La Vida','Coldplay','Brazil',1),(2008,'Viva La Vida','Coldplay','Canada',1),(2008,'Viva La Vida','Coldplay','Ethiopia',6),(2008,'Viva La Vida','Coldplay','Indonesia',3),(2008,'Viva La Vida','Coldplay','Japan',1),(2008,'Viva La Vida','Coldplay','Mexico',1),(2008,'Viva La Vida','Coldplay','United States',10),(2008,'Viva La Vida','Coldplay','Uruguay',1),(2008,'I Kissed A Girl','Katy Perry','Argentina',2),(2008,'I Kissed A Girl','Katy Perry','Brazil',7),(2008,'I Kissed A Girl','Katy Perry','El Salvador',1),(2008,'I Kissed A Girl','Katy Perry','Ethiopia',17),(2008,'I Kissed A Girl','Katy Perry','Guam',1),(2008,'I Kissed A Girl','Katy Perry','Hungary',1),(2008,'I Kissed A Girl','Katy Perry','Indonesia',1),(2008,'I Kissed A Girl','Katy Perry','Portugal',1),(2008,'I Kissed A Girl','Katy Perry','United States',2),(2008,'I Kissed A Girl','Katy Perry','Venezuela',1),(2008,'Whatever You Like','T.I.','Antarctica',1),(2008,'Whatever You Like','T.I.','Australia',1),(2008,'Whatever You Like','T.I.','Canada',1),(2008,'Whatever You Like','T.I.','Ethiopia',16),(2008,'Whatever You Like','T.I.','Philippines',1),(2008,'Whatever You Like','T.I.','United States',7),(2008,'Disturbia','Rihanna','Argentina',1),(2008,'Disturbia','Rihanna','Brazil',13),(2008,'Disturbia','Rihanna','Canada',1),(2008,'Disturbia','Rihanna','Chile',1),(2008,'Disturbia','Rihanna','Ethiopia',4),(2008,'Disturbia','Rihanna','France',2),(2008,'Disturbia','Rihanna','Guernsey',1),(2008,'Disturbia','Rihanna','Indonesia',1),(2008,'Disturbia','Rihanna','United States',8),(2008,'Don\'T Stop The Music','Rihanna','Brazil',15),(2008,'Don\'T Stop The Music','Rihanna','Canada',1),(2008,'Don\'T Stop The Music','Rihanna','Egypt',1),(2008,'Don\'T Stop The Music','Rihanna','Ethiopia',10),(2008,'Don\'T Stop The Music','Rihanna','Greece',1),(2008,'Don\'T Stop The Music','Rihanna','Guernsey',1),(2008,'Don\'T Stop The Music','Rihanna','Philippines',1),(2008,'Don\'T Stop The Music','Rihanna','United Kingdom',1),(2008,'Don\'T Stop The Music','Rihanna','United States',4),(2008,'Pocketful Of Sunshine','Natasha Bedingfield','Austria',1),(2008,'Pocketful Of Sunshine','Natasha Bedingfield','Brazil',1),(2008,'Pocketful Of Sunshine','Natasha Bedingfield','Canada',6),(2008,'Pocketful Of Sunshine','Natasha Bedingfield','Colombia',1),(2008,'Pocketful Of Sunshine','Natasha Bedingfield','Dominican Republic',1),(2008,'Pocketful Of Sunshine','Natasha Bedingfield','Ethiopia',12),(2008,'Pocketful Of Sunshine','Natasha Bedingfield','Honduras',1),(2008,'Pocketful Of Sunshine','Natasha Bedingfield','Japan',1),(2008,'Pocketful Of Sunshine','Natasha Bedingfield','United Kingdom',1),(2008,'Pocketful Of Sunshine','Natasha Bedingfield','United States',11),(2008,'Kiss Kiss','Chris Brown Featuring T-Pain','Ethiopia',1),(2008,'Closer','Ne-Yo','Brazil',3),(2008,'Closer','Ne-Yo','Canada',1),(2008,'Closer','Ne-Yo','Ethiopia',16),(2008,'Closer','Ne-Yo','France',2),(2008,'Closer','Ne-Yo','Italy',1),(2008,'Closer','Ne-Yo','Poland',1),(2008,'Closer','Ne-Yo','South Africa',1),(2008,'Closer','Ne-Yo','United Kingdom',1),(2008,'Closer','Ne-Yo','United States',4),(2008,'Closer','Ne-Yo','Uruguay',1),(2007,'Irreplaceable','Beyonce','Australia',1),(2007,'Irreplaceable','Beyonce','Brazil',1),(2007,'Irreplaceable','Beyonce','Ethiopia',16),(2007,'Irreplaceable','Beyonce','Japan',1),(2007,'Irreplaceable','Beyonce','Mexico',1),(2007,'Irreplaceable','Beyonce','Russia',1),(2007,'Irreplaceable','Beyonce','United States',10),(2007,'Umbrella','Rihanna Featuring Jay-Z','Ethiopia',4),(2007,'Umbrella','Rihanna Featuring Jay-Z','United States',4),(2007,'The Sweet Escape','Gwen Stefani Featuring Akon','Ethiopia',3),(2007,'The Sweet Escape','Gwen Stefani Featuring Akon','United States',1),(2007,'Big Girls Don\'T Cry','Fergie','Brazil',6),(2007,'Big Girls Don\'T Cry','Fergie','Canada',2),(2007,'Big Girls Don\'T Cry','Fergie','Ethiopia',12),(2007,'Big Girls Don\'T Cry','Fergie','Georgia',1),(2007,'Big Girls Don\'T Cry','Fergie','Isle of Man',1),(2007,'Big Girls Don\'T Cry','Fergie','Italy',1),(2007,'Big Girls Don\'T Cry','Fergie','Jordan',2),(2007,'Big Girls Don\'T Cry','Fergie','Spain',1),(2007,'Big Girls Don\'T Cry','Fergie','United Kingdom',1),(2007,'Big Girls Don\'T Cry','Fergie','United States',5),(2007,'Buy U A Drank (Shawty Snappin\')','T-Pain Featuring Yung Joc','Ethiopia',1),(2007,'Before He Cheats','Carrie Underwood','Canada',2),(2007,'Before He Cheats','Carrie Underwood','Colombia',1),(2007,'Before He Cheats','Carrie Underwood','Ethiopia',12),(2007,'Before He Cheats','Carrie Underwood','Guam',1),(2007,'Before He Cheats','Carrie Underwood','Guyana',1),(2007,'Before He Cheats','Carrie Underwood','Papua New Guinea',1),(2007,'Before He Cheats','Carrie Underwood','Puerto Rico',1),(2007,'Before He Cheats','Carrie Underwood','United States',16),(2007,'Hey There Delilah','Plain White T\'s','Colombia',1),(2007,'Hey There Delilah','Plain White T\'s','Ethiopia',18),(2007,'Hey There Delilah','Plain White T\'s','Papua New Guinea',1),(2007,'Hey There Delilah','Plain White T\'s','Republic of the Congo',1),(2007,'Hey There Delilah','Plain White T\'s','Thailand',1),(2007,'Hey There Delilah','Plain White T\'s','United Kingdom',1),(2007,'Hey There Delilah','Plain White T\'s','United States',7),(2007,'Hey There Delilah','Plain White T\'s','Vietnam',1),(2007,'I Wanna Love You','Akon Featuring Snoop Dogg','Ethiopia',4),(2007,'Say It Right','Nelly Furtado','Brazil',3),(2007,'Say It Right','Nelly Furtado','Cape Verde',1),(2007,'Say It Right','Nelly Furtado','Ethiopia',18),(2007,'Say It Right','Nelly Furtado','Germany',1),(2007,'Say It Right','Nelly Furtado','Switzerland',1),(2007,'Say It Right','Nelly Furtado','United Kingdom',1),(2007,'Say It Right','Nelly Furtado','United States',6),(2007,'Say It Right','Nelly Furtado','Venezuela',1),(2007,'Glamorous','Fergie Featuring Ludacris','Bonaire',1),(2007,'Glamorous','Fergie Featuring Ludacris','United States',1),(2007,'Don\'T Matter','Akon','',1),(2007,'Don\'T Matter','Akon','Brazil',2),(2007,'Don\'T Matter','Akon','Chile',1),(2007,'Don\'T Matter','Akon','Colombia',1),(2007,'Don\'T Matter','Akon','Ethiopia',15),(2007,'Don\'T Matter','Akon','France',2),(2007,'Don\'T Matter','Akon','United Kingdom',2),(2007,'Don\'T Matter','Akon','United States',7),(2007,'Girlfriend','Avril Lavigne','Argentina',1),(2007,'Girlfriend','Avril Lavigne','Dominican Republic',1),(2007,'Girlfriend','Avril Lavigne','Ethiopia',21),(2007,'Girlfriend','Avril Lavigne','Guam',1),(2007,'Girlfriend','Avril Lavigne','Japan',1),(2007,'Girlfriend','Avril Lavigne','Mexico',1),(2007,'Girlfriend','Avril Lavigne','Netherlands',1),(2007,'Girlfriend','Avril Lavigne','Peru',1),(2007,'Girlfriend','Avril Lavigne','Philippines',1),(2007,'Girlfriend','Avril Lavigne','Spain',3),(2007,'Girlfriend','Avril Lavigne','United States',2),(2007,'Makes Me Wonder','Maroon 5','',1),(2007,'Makes Me Wonder','Maroon 5','Argentina',2),(2007,'Makes Me Wonder','Maroon 5','Armenia',1),(2007,'Makes Me Wonder','Maroon 5','Bonaire',1),(2007,'Makes Me Wonder','Maroon 5','Chile',1),(2007,'Makes Me Wonder','Maroon 5','Colombia',2),(2007,'Makes Me Wonder','Maroon 5','Ethiopia',13),(2007,'Makes Me Wonder','Maroon 5','Indonesia',1),(2007,'Makes Me Wonder','Maroon 5','Italy',1),(2007,'Makes Me Wonder','Maroon 5','Mexico',1),(2007,'Makes Me Wonder','Maroon 5','Peru',1),(2007,'Makes Me Wonder','Maroon 5','Philippines',3),(2007,'Makes Me Wonder','Maroon 5','United States',5),(2007,'Party Like A Rockstar','Shop Boyz','Antarctica',1),(2007,'Party Like A Rockstar','Shop Boyz','Ethiopia',9),(2007,'Party Like A Rockstar','Shop Boyz','Hong Kong',1),(2007,'Party Like A Rockstar','Shop Boyz','India',1),(2007,'Party Like A Rockstar','Shop Boyz','Poland',1),(2007,'Party Like A Rockstar','Shop Boyz','United States',4),(2007,'Party Like A Rockstar','Shop Boyz','Zimbabwe',1),(2007,'Smack That','Akon Featuring Eminem','Indonesia',1),(2007,'Smack That','Akon Featuring Eminem','Japan',3),(2007,'This Is Why I\'M Hot','Mims','Belgium',1),(2007,'This Is Why I\'M Hot','Mims','Canada',1),(2007,'This Is Why I\'M Hot','Mims','Cyprus',1),(2007,'This Is Why I\'M Hot','Mims','Ethiopia',15),(2007,'This Is Why I\'M Hot','Mims','France',1),(2007,'This Is Why I\'M Hot','Mims','Georgia',1),(2007,'This Is Why I\'M Hot','Mims','Guam',1),(2007,'This Is Why I\'M Hot','Mims','Nigeria',2),(2007,'This Is Why I\'M Hot','Mims','South Africa',3),(2007,'This Is Why I\'M Hot','Mims','Tunisia',1),(2007,'This Is Why I\'M Hot','Mims','United States',3),(2007,'This Is Why I\'M Hot','Mims','Zimbabwe',1),(2007,'It\'S Not Over','Daughtry','Antarctica',3),(2007,'It\'S Not Over','Daughtry','Ethiopia',5),(2007,'It\'S Not Over','Daughtry','Germany',5),(2007,'It\'S Not Over','Daughtry','Indonesia',2),(2007,'It\'S Not Over','Daughtry','Iran',1),(2007,'It\'S Not Over','Daughtry','Russia',1),(2007,'It\'S Not Over','Daughtry','United States',19),(2007,'The Way I Are','Timbaland Featuring Keri Hilson','United States',4),(2007,'Fergalicious','Fergie','Bolivia',2),(2007,'Fergalicious','Fergie','Canada',1),(2007,'Fergalicious','Fergie','Colombia',1),(2007,'Fergalicious','Fergie','Ethiopia',15),(2007,'Fergalicious','Fergie','France',1),(2007,'Fergalicious','Fergie','Lebanon',1),(2007,'Fergalicious','Fergie','Mexico',2),(2007,'Fergalicious','Fergie','Peru',1),(2007,'Fergalicious','Fergie','United Kingdom',1),(2007,'Fergalicious','Fergie','United States',7),(2007,'Crank That (Soulja Boy)','Soulja Boy Tell\'em','Brazil',14),(2007,'Crank That (Soulja Boy)','Soulja Boy Tell\'em','Colombia',1),(2007,'Crank That (Soulja Boy)','Soulja Boy Tell\'em','El Salvador',2),(2007,'Crank That (Soulja Boy)','Soulja Boy Tell\'em','Ethiopia',13),(2007,'Crank That (Soulja Boy)','Soulja Boy Tell\'em','Indonesia',1),(2007,'Crank That (Soulja Boy)','Soulja Boy Tell\'em','Kiribati',1),(2007,'Crank That (Soulja Boy)','Soulja Boy Tell\'em','Mexico',1),(2007,'Crank That (Soulja Boy)','Soulja Boy Tell\'em','Spain',1),(2007,'Crank That (Soulja Boy)','Soulja Boy Tell\'em','Sweden',1),(2007,'Crank That (Soulja Boy)','Soulja Boy Tell\'em','Turkey',1),(2007,'Crank That (Soulja Boy)','Soulja Boy Tell\'em','United Kingdom',1),(2007,'Crank That (Soulja Boy)','Soulja Boy Tell\'em','United States',2),(2006,'Bad Day','Daniel Powter','Australia',1),(2006,'Bad Day','Daniel Powter','Benin',1),(2006,'Bad Day','Daniel Powter','Canada',1),(2006,'Bad Day','Daniel Powter','Dominican Republic',1),(2006,'Bad Day','Daniel Powter','Ethiopia',14),(2006,'Bad Day','Daniel Powter','France',4),(2006,'Bad Day','Daniel Powter','Indonesia',1),(2006,'Bad Day','Daniel Powter','Japan',1),(2006,'Bad Day','Daniel Powter','Mexico',1),(2006,'Bad Day','Daniel Powter','Netherlands',1),(2006,'Bad Day','Daniel Powter','Russia',1),(2006,'Bad Day','Daniel Powter','United Kingdom',1),(2006,'Bad Day','Daniel Powter','United States',1),(2006,'Bad Day','Daniel Powter','Venezuela',1),(2006,'Temperature','Sean Paul','Antarctica',1),(2006,'Temperature','Sean Paul','Bahamas',1),(2006,'Temperature','Sean Paul','Ethiopia',17),(2006,'Temperature','Sean Paul','France',1),(2006,'Temperature','Sean Paul','Jamaica',1),(2006,'Temperature','Sean Paul','Serbia',2),(2006,'Temperature','Sean Paul','United Kingdom',3),(2006,'Temperature','Sean Paul','United States',5),(2006,'Temperature','Sean Paul','Venezuela',3),(2006,'Promiscuous','Nelly Furtado Featuring Timbaland','Australia',1),(2006,'Promiscuous','Nelly Furtado Featuring Timbaland','Ethiopia',17),(2006,'You\'Re Beautiful','James Blunt','',1),(2006,'You\'Re Beautiful','James Blunt','Ecuador',2),(2006,'You\'Re Beautiful','James Blunt','Ethiopia',15),(2006,'You\'Re Beautiful','James Blunt','India',1),(2006,'You\'Re Beautiful','James Blunt','Malaysia',1),(2006,'You\'Re Beautiful','James Blunt','Russia',1),(2006,'You\'Re Beautiful','James Blunt','United Kingdom',1),(2006,'You\'Re Beautiful','James Blunt','United States',7),(2006,'Hips Don\'T Lie','Shakira Featuring Wyclef Jean','United Kingdom',1),(2006,'Hips Don\'T Lie','Shakira Featuring Wyclef Jean','United States',2),(2006,'Unwritten','Natasha Bedingfield','Australia',1),(2006,'Unwritten','Natasha Bedingfield','Brazil',1),(2006,'Unwritten','Natasha Bedingfield','Chile',1),(2006,'Unwritten','Natasha Bedingfield','Dominican Republic',1),(2006,'Unwritten','Natasha Bedingfield','Ethiopia',6),(2006,'Unwritten','Natasha Bedingfield','Philippines',1),(2006,'Unwritten','Natasha Bedingfield','Portugal',1),(2006,'Unwritten','Natasha Bedingfield','Spain',3),(2006,'Unwritten','Natasha Bedingfield','Uganda',1),(2006,'Unwritten','Natasha Bedingfield','United Kingdom',1),(2006,'Unwritten','Natasha Bedingfield','United States',12),(2006,'Unwritten','Natasha Bedingfield','Vietnam',1),(2006,'Crazy','Gnarls Barkley','Argentina',2),(2006,'Crazy','Gnarls Barkley','Australia',1),(2006,'Crazy','Gnarls Barkley','Brazil',1),(2006,'Crazy','Gnarls Barkley','Canada',3),(2006,'Crazy','Gnarls Barkley','Chile',1),(2006,'Crazy','Gnarls Barkley','Colombia',1),(2006,'Crazy','Gnarls Barkley','Ethiopia',11),(2006,'Crazy','Gnarls Barkley','Italy',1),(2006,'Crazy','Gnarls Barkley','Mexico',1),(2006,'Crazy','Gnarls Barkley','New Zealand',1),(2006,'Crazy','Gnarls Barkley','Russia',1),(2006,'Crazy','Gnarls Barkley','United Kingdom',1),(2006,'Crazy','Gnarls Barkley','United States',8),(2006,'Crazy','Gnarls Barkley','Uruguay',1),(2006,'Ridin\'','Chamillionaire Featuring Krayzie Bone','Netherlands',1),(2006,'Ridin\'','Chamillionaire Featuring Krayzie Bone','Sint Maarten',2),(2006,'Ridin\'','Chamillionaire Featuring Krayzie Bone','United States',5),(2006,'Sexyback','Justin Timberlake','Argentina',1),(2006,'Sexyback','Justin Timberlake','Bolivia',1),(2006,'Sexyback','Justin Timberlake','Brazil',1),(2006,'Sexyback','Justin Timberlake','Canada',1),(2006,'Sexyback','Justin Timberlake','Egypt',1),(2006,'Sexyback','Justin Timberlake','Ethiopia',18),(2006,'Sexyback','Justin Timberlake','Guatemala',1),(2006,'Sexyback','Justin Timberlake','Ireland',1),(2006,'Sexyback','Justin Timberlake','Japan',1),(2006,'Sexyback','Justin Timberlake','Mexico',1),(2006,'Sexyback','Justin Timberlake','Netherlands',1),(2006,'Sexyback','Justin Timberlake','Switzerland',1),(2006,'Sexyback','Justin Timberlake','Turkey',1),(2006,'Sexyback','Justin Timberlake','United States',3),(2006,'Check On It','Beyonce Featuring Slim Thug','United States',2),(2006,'Be Without You','Mary J. Blige','Antarctica',1),(2006,'Be Without You','Mary J. Blige','Dominica',1),(2006,'Be Without You','Mary J. Blige','Ethiopia',9),(2006,'Be Without You','Mary J. Blige','Ghana',1),(2006,'Be Without You','Mary J. Blige','Honduras',1),(2006,'Be Without You','Mary J. Blige','United Kingdom',1),(2006,'Be Without You','Mary J. Blige','United States',5),(2006,'Grillz','Nelly Featuring Paul Wall, Ali & Gipp','Canada',2),(2006,'Over My Head (Cable Car)','The Fray','Australia',1),(2006,'Over My Head (Cable Car)','The Fray','Canada',3),(2006,'Over My Head (Cable Car)','The Fray','Colombia',1),(2006,'Over My Head (Cable Car)','The Fray','Ethiopia',10),(2006,'Over My Head (Cable Car)','The Fray','Mexico',1),(2006,'Over My Head (Cable Car)','The Fray','Paraguay',1),(2006,'Over My Head (Cable Car)','The Fray','Philippines',1),(2006,'Over My Head (Cable Car)','The Fray','South Korea',1),(2006,'Over My Head (Cable Car)','The Fray','Spain',1),(2006,'Over My Head (Cable Car)','The Fray','United Kingdom',2),(2006,'Over My Head (Cable Car)','The Fray','United States',8),(2006,'Over My Head (Cable Car)','The Fray','Uruguay',2),(2006,'Me & U','Cassie','Ethiopia',22),(2006,'Me & U','Cassie','France',5),(2006,'Me & U','Cassie','Guyana',1),(2006,'Me & U','Cassie','Philippines',1),(2006,'Me & U','Cassie','Sri Lanka',1),(2006,'Me & U','Cassie','Tuvalu',1),(2006,'Me & U','Cassie','United States',3),(2006,'Buttons','The Pussycat Dolls Featuring Snoop Dogg','Ethiopia',3),(2006,'Buttons','The Pussycat Dolls Featuring Snoop Dogg','United States',1),(2006,'Run It!','Chris Brown','Antarctica',1),(2006,'Run It!','Chris Brown','Austria',1),(2006,'Run It!','Chris Brown','Colombia',1),(2006,'Run It!','Chris Brown','East Timor',1),(2006,'Run It!','Chris Brown','Ethiopia',14),(2006,'Run It!','Chris Brown','France',2),(2006,'Run It!','Chris Brown','Jordan',1),(2006,'Run It!','Chris Brown','Netherlands',1),(2006,'Run It!','Chris Brown','Northern Mariana Islands',1),(2006,'Run It!','Chris Brown','Thailand',1),(2006,'Run It!','Chris Brown','United States',7),(2006,'Run It!','Chris Brown','Vietnam',1),(2006,'So Sick','Ne-Yo','Australia',1),(2006,'So Sick','Ne-Yo','Ethiopia',16),(2006,'So Sick','Ne-Yo','Malaysia',1),(2006,'So Sick','Ne-Yo','Thailand',1),(2006,'So Sick','Ne-Yo','United States',8),(2006,'It\'S Goin\' Down','Yung Joc','Canada',3),(2006,'It\'S Goin\' Down','Yung Joc','Colombia',1),(2006,'It\'S Goin\' Down','Yung Joc','Ethiopia',10),(2006,'It\'S Goin\' Down','Yung Joc','South Africa',1),(2006,'It\'S Goin\' Down','Yung Joc','United States',12),(2006,'Sos','Rihanna','Argentina',1),(2006,'Sos','Rihanna','Brazil',8),(2006,'Sos','Rihanna','Canada',1),(2006,'Sos','Rihanna','Ethiopia',22),(2006,'Sos','Rihanna','Guam',1),(2006,'Sos','Rihanna','Guernsey',1),(2006,'Sos','Rihanna','United States',1),(2006,'I Write Sins Not Tragedies','Panic! At The Disco','Antarctica',1),(2006,'I Write Sins Not Tragedies','Panic! At The Disco','Egypt',1),(2006,'I Write Sins Not Tragedies','Panic! At The Disco','Ethiopia',18),(2006,'I Write Sins Not Tragedies','Panic! At The Disco','Germany',1),(2006,'I Write Sins Not Tragedies','Panic! At The Disco','Malaysia',1),(2006,'I Write Sins Not Tragedies','Panic! At The Disco','United States',10);
# Step 7
DROP TABLE IF EXISTS `SongRating`;
#Step 8
CREATE TABLE `SongRating` (
`Year` bigint(20) DEFAULT NULL,
`Title` varchar(63) DEFAULT NULL,
`Artist` varchar(63) DEFAULT NULL,
`Rank` varchar(63) DEFAULT NULL,
`PositiveTweets` bigint(20) DEFAULT NULL,
`NegativeTweets` bigint(20) DEFAULT NULL,
`Retweets` bigint(20) DEFAULT NULL,
`PositiveScore` double DEFAULT NULL,
`NegativeScore` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
# Step 9
INSERT INTO `SongRating` VALUES (2014,'Happy','Pharrell Williams','1',2,2,3,2,2),(2014,'Dark Horse','Katy Perry Featuring Juicy J','2',0,0,4,0,0),(2014,'All Of Me','John Legend','3',4,1,14,4,1),(2014,'Fancy','Iggy Azalea Featuring Charli XCX','4',0,0,0,0,0),(2014,'Counting Stars','OneRepublic','5',3,3,2,3,3),(2014,'Talk Dirty','Jason Derulo Featuring 2 Chainz','6',0,0,0,0,0),(2014,'Rude','MAGIC!','7',16,0,8,17,0),(2014,'All About That Bass','Meghan Trainor','8',3,3,5,3,4),(2014,'Problem','Ariana Grande Featuring Iggy Azalea','9',0,0,0,0,0),(2014,'Stay With Me','Sam Smith','10',5,4,10,6,7),(2014,'Timber','Pitbull Featuring Ke$ha','11',0,0,0,0,0),(2014,'Pompeii','Bastille','12',1,1,6,1,1),(2014,'Shake It Off','Taylor Swift','13',17,18,25,40,39),(2014,'Am I Wrong','Nico & Vinz','14',2,0,1,3,0),(2014,'Turn Down For What','DJ Snake & Lil Jon','15',3,2,1,4,2),(2014,'The Monster','Eminem Featuring Rihanna','16',3,0,1,3,0),(2014,'Say Something','A Great Big World & Christina Aguilera','17',36,0,2,38,0),(2014,'Team','Lorde','18',1,0,29,1,0),(2014,'Let Her Go','Passenger','19',2,1,11,2,1),(2014,'Royals','Lorde','20',5,3,6,6,4),(2013,'Thrift Shop','Macklemore & Ryan Lewis Featuring Wanz','1',1,0,0,1,0),(2013,'Blurred Lines','Robin Thicke Featuring T.I. + Pharrell','2',0,0,0,0,0),(2013,'Radioactive','Imagine Dragons','3',7,0,4,7,0),(2013,'Harlem Shake','Baauer','4',2,0,1,2,0),(2013,'Can\'T Hold Us','Macklemore & Ryan Lewis Featuring Ray Dalton','5',0,0,0,0,0),(2013,'Mirrors','Justin Timberlake','6',5,1,18,5,1),(2013,'Just Give Me A Reason','P!nk Featuring Nate Ruess','7',0,0,0,0,0),(2013,'When I Was Your Man','Bruno Mars','8',7,0,9,7,0),(2013,'Cruise','Florida Georgia Line Featuring Nelly','9',0,0,0,0,0),(2013,'Roar','Katy Perry','10',10,2,13,10,2),(2013,'Locked Out Of Heaven','Bruno Mars','11',6,0,8,6,0),(2013,'Ho Hey','The Lumineers','12',5,0,3,5,0),(2013,'Stay','Rihanna Featuring Mikky Ekko','13',0,0,2,0,0),(2013,'Get Lucky','Daft Punk Featuring Pharrell Williams','14',1,8,0,1,8),(2013,'Royals','Lorde','15',5,3,6,6,4),(2013,'I Knew You Were Trouble.','Taylor Swift','16',3,1,25,39,37),(2013,'We Can\'T Stop','Miley Cyrus','17',4,0,7,5,1),(2013,'Wrecking Ball','Miley Cyrus','18',2,1,30,3,2),(2013,'Wake Me Up!','Avicii','19',5,0,4,5,0),(2013,'Suit & Tie','Justin Timberlake Featuring JAY Z','20',0,0,2,0,0),(2012,'Somebody That I Used To Know','Gotye Featuring Kimbra','1',0,0,0,0,0),(2012,'Call Me Maybe','Carly Rae Jepsen','2',3,0,7,3,0),(2012,'We Are Young','fun. Featuring Janelle Monae','3',2,0,0,2,0),(2012,'Payphone','Maroon 5 Featuring Wiz Khalifa','4',0,0,0,0,0),(2012,'Lights','Ellie Goulding','5',8,1,9,12,2),(2012,'Glad You Came','The Wanted','6',1,0,13,1,0),(2012,'Stronger (What Doesn\'T Kill You)','Kelly Clarkson','7',1,11,5,7,21),(2012,'We Found Love','Rihanna Featuring Calvin Harris','8',0,0,1,0,0),(2012,'Starships','Nicki Minaj','9',21,0,23,25,4),(2012,'What Makes You Beautiful','One Direction','10',6,1,21,6,1),(2012,'Wild Ones','Flo Rida Featuring Sia','11',0,0,0,0,0),(2012,'Set Fire To The Rain','Adele','12',5,3,9,6,5),(2012,'Sexy And I Know It','LMFAO','13',1,1,25,1,1),(2012,'Some Nights','fun.','14',34,1,25,39,3),(2012,'Wide Awake','Katy Perry','15',2,3,18,3,6),(2012,'Good Feeling','Flo Rida','16',5,1,3,5,1),(2012,'Whistle','Flo Rida','17',2,0,3,2,0),(2012,'One More Night','Maroon 5','18',2,0,16,2,0),(2012,'Drive By','Train','19',3,3,2,4,4),(2012,'The Motto','Drake Featuring Lil Wayne','20',0,0,0,0,0),(2011,'Rolling In The Deep','Adele','1',2,0,12,4,2),(2011,'Party Rock Anthem','LMFAO Featuring Lauren Bennett & GoonRock','2',0,0,0,0,0),(2011,'Firework','Katy Perry','3',3,0,35,5,0),(2011,'E.T.','Katy Perry Featuring Kanye West','4',0,0,1,0,0),(2011,'Give Me Everything','\"Pitbull Featuring Ne-Yo, Afrojack & Nayer\"','5',0,0,0,0,0),(2011,'Grenade','Bruno Mars','6',11,4,14,12,5),(2011,'F**K You (Forget You)','Cee Lo Green','7',0,0,0,0,0),(2011,'Super Bass','Nicki Minaj','8',2,0,17,3,1),(2011,'Moves Like Jagger','Maroon 5 Featuring Christina Aguilera','9',2,0,0,2,0),(2011,'Just Can\'T Get Enough','The Black Eyed Peas','10',4,1,7,4,1),(2011,'On The Floor','Jennifer Lopez Featuring Pitbull','11',0,0,0,0,0),(2011,'S&M','Rihanna','12',17,8,8,23,12),(2011,'Pumped Up Kicks','Foster The People','13',5,0,12,7,0),(2011,'Last Friday Night (T.G.I.F.)','Katy Perry','14',5,0,3,5,0),(2011,'Just The Way You Are','Bruno Mars','15',5,0,14,5,0),(2011,'Tonight (I\'M Lovin\' You)','Enrique Iglesias Featuring Ludacris & DJ Frank E','16',0,0,0,0,0),(2011,'Raise Your Glass','P!nk','17',1,2,5,2,3),(2011,'Born This Way','Lady Gaga','18',31,0,17,34,3),(2011,'F**Kin\' Perfect','P!nk','19',2,0,11,3,1),(2011,'What\'S My Name?','Rihanna Featuring Drake','20',0,0,0,0,0),(2010,'Tik Tok','Ke$ha','1',0,0,0,0,0),(2010,'Need You Now','Lady Antebellum','2',3,1,0,4,2),(2010,'Hey, Soul Sister','Train','3',2,3,4,2,3),(2010,'California Gurls','Katy Perry Featuring Snoop Dogg','4',0,0,0,0,0),(2010,'Omg','Usher Featuring will.i.am','5',0,0,1,0,0),(2010,'Airplanes','B.o.B Featuring Hayley Williams','6',0,0,0,0,0),(2010,'Love The Way You Lie','Eminem Featuring Rihanna','7',0,0,0,0,0),(2010,'Bad Romance','Lady Gaga','8',0,0,26,20,20),(2010,'Dynamite','Taio Cruz','9',5,0,2,5,0),(2010,'Break Your Heart','Taio Cruz Featuring Ludacris','10',0,0,0,0,0),(2010,'Nothin\' On You','B.o.B Featuring Bruno Mars','11',0,0,0,0,0),(2010,'I Like It','Enrique Iglesias Featuring Pitbull','12',0,0,0,0,0),(2010,'Bedrock','Young Money Featuring Lloyd','13',0,0,0,0,0),(2010,'In My Head','Jason Derulo','14',7,5,6,8,6),(2010,'Rude Boy','Rihanna','15',2,0,10,4,1),(2010,'Telephone','Lady Gaga Featuring Beyonce','16',0,0,0,0,0),(2010,'Teenage Dream','Katy Perry','17',7,6,21,12,12),(2010,'Just The Way You Are','Bruno Mars','18',5,0,14,5,0),(2010,'Cooler Than Me','Mike Posner','19',7,0,1,7,0),(2010,'Imma Be','The Black Eyed Peas','20',8,1,0,9,2),(2009,'Boom Boom Pow','The Black Eyed Peas','1',4,0,4,4,0),(2009,'Poker Face','Lady Gaga','2',6,1,27,6,1),(2009,'Just Dance','Lady Gaga Featuring Colby O\'Donis','3',0,0,0,0,0),(2009,'I Gotta Feeling','The Black Eyed Peas','4',0,0,4,0,0),(2009,'Love Story','Taylor Swift','5',17,2,5,21,3),(2009,'Right Round','Flo Rida','6',1,3,1,1,3),(2009,'I\'M Yours','Jason Mraz','7',0,0,32,0,0),(2009,'Single Ladies (Put A Ring On It)','Beyonce','8',4,1,2,4,1),(2009,'Heartless','Kanye West','9',0,0,30,0,0),(2009,'Gives You Hell','The All-American Rejects','10',1,22,13,3,28),(2009,'You Belong With Me','Taylor Swift','11',24,2,13,31,7),(2009,'Dead And Gone','T.I. Featuring Justin Timberlake','12',0,0,0,0,0),(2009,'You Found Me','The Fray','13',13,1,21,13,1),(2009,'Use Somebody','Kings Of Leon','14',0,0,25,0,0),(2009,'Knock You Down','Keri Hilson Featuring Kanye West & Ne-Yo','15',0,0,0,0,0),(2009,'Blame It','Jamie Foxx Featuring T-Pain','16',0,0,0,0,0),(2009,'I Know You Want Me (Calle Ocho)','Pitbull','17',3,0,2,3,0),(2009,'Live Your Life','T.I. Featuring Rihanna','18',1,0,0,1,0),(2009,'Kiss Me Thru The Phone','Soulja Boy Tell \'em Featuring Sammie','19',0,0,0,0,0),(2009,'Down','Jay Sean Featuring Lil Wayne','20',0,0,0,0,0),(2008,'Low','Flo Rida Featuring T-Pain','1',0,0,0,0,0),(2008,'Bleeding Love','Leona Lewis','2',3,2,19,6,2),(2008,'No One','Alicia Keys','3',2,0,31,2,0),(2008,'Lollipop','Lil Wayne Featuring Static Major','4',0,1,0,0,1),(2008,'Apologize','Timbaland Featuring OneRepublic','5',4,0,3,4,0),(2008,'No Air','Jordin Sparks Duet With Chris Brown','6',2,0,0,2,0),(2008,'Love Song','Sara Bareilles','7',6,2,3,7,4),(2008,'Love In This Club','Usher Featuring Young Jeezy','8',0,0,0,0,0),(2008,'With You','Chris Brown','9',8,3,18,12,7),(2008,'Forever','Chris Brown','10',12,7,17,13,8),(2008,'Sexy Can I','Ray J & Yung Berg','11',3,0,3,3,0),(2008,'Take A Bow','Rihanna','12',0,0,35,1,1),(2008,'Viva La Vida','Coldplay','13',9,2,17,14,6),(2008,'I Kissed A Girl','Katy Perry','14',4,1,24,4,1),(2008,'Whatever You Like','T.I.','15',25,8,8,40,22),(2008,'Disturbia','Rihanna','16',4,0,10,7,2),(2008,'Don\'T Stop The Music','Rihanna','17',1,1,10,1,1),(2008,'Pocketful Of Sunshine','Natasha Bedingfield','18',5,2,0,6,3),(2008,'Kiss Kiss','Chris Brown Featuring T-Pain','19',1,0,1,2,0),(2008,'Closer','Ne-Yo','20',4,4,26,5,7),(2007,'Irreplaceable','Beyonce','1',10,0,27,13,1),(2007,'Umbrella','Rihanna Featuring Jay-Z','2',1,0,0,2,0),(2007,'The Sweet Escape','Gwen Stefani Featuring Akon','3',0,0,0,0,0),(2007,'Big Girls Don\'T Cry','Fergie','4',3,2,14,6,5),(2007,'Buy U A Drank (Shawty Snappin\')','T-Pain Featuring Yung Joc','5',0,0,0,0,0),(2007,'Before He Cheats','Carrie Underwood','6',5,1,7,6,1),(2007,'Hey There Delilah','Plain White T\'s','7',0,0,32,0,0),(2007,'I Wanna Love You','Akon Featuring Snoop Dogg','8',0,0,0,0,0),(2007,'Say It Right','Nelly Furtado','9',1,0,34,2,1),(2007,'Glamorous','Fergie Featuring Ludacris','10',0,0,0,0,0),(2007,'Don\'T Matter','Akon','11',5,0,3,7,0),(2007,'Girlfriend','Avril Lavigne','12',2,1,6,2,1),(2007,'Makes Me Wonder','Maroon 5','13',1,0,4,1,0),(2007,'Party Like A Rockstar','Shop Boyz','14',2,3,2,2,3),(2007,'Smack That','Akon Featuring Eminem','15',0,0,0,0,0),(2007,'This Is Why I\'M Hot','Mims','16',7,0,8,8,1),(2007,'It\'S Not Over','Daughtry','17',2,1,2,3,2),(2007,'The Way I Are','Timbaland Featuring Keri Hilson','18',0,0,0,0,0),(2007,'Fergalicious','Fergie','19',16,0,20,22,3),(2007,'Crank That (Soulja Boy)','Soulja Boy Tell\'em','20',1,0,20,1,0),(2006,'Bad Day','Daniel Powter','1',3,0,8,4,1),(2006,'Temperature','Sean Paul','2',3,0,30,3,0),(2006,'Promiscuous','Nelly Furtado Featuring Timbaland','3',0,0,0,0,0),(2006,'You\'Re Beautiful','James Blunt','4',0,18,23,5,27),(2006,'Hips Don\'T Lie','Shakira Featuring Wyclef Jean','5',0,0,1,0,0),(2006,'Unwritten','Natasha Bedingfield','6',8,2,7,9,4),(2006,'Crazy','Gnarls Barkley','7',4,2,1,5,3),(2006,'Ridin\'','Chamillionaire Featuring Krayzie Bone','8',0,0,0,0,0),(2006,'Sexyback','Justin Timberlake','9',1,3,22,1,3),(2006,'Check On It','Beyonce Featuring Slim Thug','10',0,2,0,0,2),(2006,'Be Without You','Mary J. Blige','11',0,0,9,2,2),(2006,'Grillz','Nelly Featuring Paul Wall, Ali & Gipp','12',0,0,0,0,0),(2006,'Over My Head (Cable Car)','The Fray','13',4,0,3,4,0),(2006,'Me & U','Cassie','14',7,1,30,10,4),(2006,'Buttons','The Pussycat Dolls Featuring Snoop Dogg','15',0,0,0,0,0),(2006,'Run It!','Chris Brown','16',2,0,28,4,0),(2006,'So Sick','Ne-Yo','17',17,6,27,20,9),(2006,'It\'S Goin\' Down','Yung Joc','18',9,4,6,9,5),(2006,'Sos','Rihanna','19',2,1,4,2,1),(2006,'I Write Sins Not Tragedies','Panic! At The Disco','20',31,3,33,31,3);