• stratascratch-easy
  • Find-how-many-times-each-artist-appeared-on-the-Spotify-ranking-list

Find how many times each artist appeared on the Spotify ranking list

StrataScratch

Find how many times each artist appeared on the Spotify ranking list. Output the artist name along with the corresponding number of occurrences. Order records by the number of occurrences in descending order.

table name: spotify_worldwide_daily_song_ranking


Question Explanation:
Each artist has been there in spotify ranking list for multiple times. Our task is to find the number of occurrences each artist is there is ranking list.


Solution Explanation:
  • Use group by artist to make group for different artists.
select  artist from spotify_worldwide_daily_song_ranking group by artist 


  • Count number of rows for each group/artist.
select count(*) as n_occurences, artist from spotify_worldwide_daily_song_ranking group by artist 


  • Order by n_occurences descending.
select artist,count(artist) as n_occurences from spotify_worldwide_daily_song_ranking group by artist order by n_occurences desc;


Final Solution:
select artist,count(artist) as n_occurences from spotify_worldwide_daily_song_ranking group by artist order by count(artist) desc;

Output (Few records):


SQL Script:
CREATE TABLE [dbo].[spotify_worldwide_daily_song_ranking](
	[id] [int] NOT NULL,
	[position] [int] NULL,
	[trackname] [varchar](250) NULL,
	[artist] [varchar](50) NULL,
	[streams] [int] NULL,
	[url] [varchar](250) NULL,
	[date] [datetime] NULL,
	[region] [varchar](50) NULL,
 CONSTRAINT [PK_spotify_worldwide_daily_song_ranking] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (13789, 190, N'Hello', N'Adele', 1537, N'https://open.spotify.com/track/4sPmO7WMQUAf45kwMOtONw', CAST(N'2017-03-10T00:00:00.000' AS DateTime), N'ec')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (28007, 8, N'Una Lady Como Tu', N'Manuel Turizo', 14464, N'https://open.spotify.com/track/7MHN1aCFtLXjownGhvEQlF', CAST(N'2017-05-21T00:00:00.000' AS DateTime), N'ec')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (29358, 159, N'Sugar', N'Maroon 5', 1830, N'https://open.spotify.com/track/494OU6M7NOf4ICYb4zWCf5', CAST(N'2017-05-27T00:00:00.000' AS DateTime), N'ec')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (32998, 199, N'This Is What You Came For', N'Calvin Harris', 1670, N'https://open.spotify.com/track/0azC730Exh71aQlOt9Zj3y', CAST(N'2017-06-17T00:00:00.000' AS DateTime), N'ec')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (33445, 46, N'I''m the One', N'DJ Khaled', 5278, N'https://open.spotify.com/track/3DXncPQOG4VBw3QHh3S817', CAST(N'2017-06-20T00:00:00.000' AS DateTime), N'ec')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (39577, 178, N'Hasta el Amanecer', N'Nicky Jam', 1907, N'https://open.spotify.com/track/5Fim1gaXBgsiFfsQAfQSDS', CAST(N'2017-07-20T00:00:00.000' AS DateTime), N'ec')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (41662, 63, N'Sorry Not Sorry', N'Demi Lovato', 3552, N'https://open.spotify.com/track/25C5CowdsfXld2jJanbiex', CAST(N'2017-07-31T00:00:00.000' AS DateTime), N'ec')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (43994, 195, N'Don''t Let Me Down', N'The Chainsmokers', 1818, N'https://open.spotify.com/track/0QsvXIfqM0zZoerQfsI9lm', CAST(N'2017-08-11T00:00:00.000' AS DateTime), N'ec')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (46741, 142, N'Would You Ever', N'Skrillex', 2258, N'https://open.spotify.com/track/57p8CBvPOxrvyCbn6ttl5r', CAST(N'2017-08-25T00:00:00.000' AS DateTime), N'ec')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (54008, 9, N'Una Lady Como Tu', N'Manuel Turizo', 14966, N'https://open.spotify.com/track/7MHN1aCFtLXjownGhvEQlF', CAST(N'2017-10-01T00:00:00.000' AS DateTime), N'ec')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (68304, 105, N'Vacaciones', N'Wisin', 2803, N'https://open.spotify.com/track/1rXojdsUqqxGj2WCmJGWHP', CAST(N'2017-12-11T00:00:00.000' AS DateTime), N'ec')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (78344, 145, N'Work from Home', N'Fifth Harmony', 23421, N'https://open.spotify.com/track/4tCtwWceOPWzenK2HAIJSb', CAST(N'2017-01-21T00:00:00.000' AS DateTime), N'fr')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (85559, 160, N'Someone In The Crowd - From "La La Land" Soundtrack', N'Emma Stone', 17134, N'https://open.spotify.com/track/7xE4vKvjqUTtHyJ9zi0k1q', CAST(N'2017-02-26T00:00:00.000' AS DateTime), N'fr')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (92977, 178, N'Mon ami', N'Still Fresh', 19177, N'https://open.spotify.com/track/46P2kfhXGdwp3OJvl3INXu', CAST(N'2017-04-04T00:00:00.000' AS DateTime), N'fr')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (93745, 146, N'Lush Life', N'Zara Larsson', 26126, N'https://open.spotify.com/track/1rIKgCH4H52lrvDcz50hS8', CAST(N'2017-04-08T00:00:00.000' AS DateTime), N'fr')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (107808, 9, N'Chocolat (feat. Awa)', N'Lartiste', 93144, N'https://open.spotify.com/track/4fwtP5khM1iEoa6BP1QQsX', CAST(N'2017-06-21T00:00:00.000' AS DateTime), N'fr')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (117089, 90, N'Sunset Lover', N'Petit Biscuit', 27642, N'https://open.spotify.com/track/0hNduWmlWmEmuwEFcYvRu1', CAST(N'2017-08-06T00:00:00.000' AS DateTime), N'fr')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (119208, 9, N'Mobali', N'Siboy', 81790, N'https://open.spotify.com/track/6xcXAVbDuVT1pCsa2rmDHY', CAST(N'2017-08-17T00:00:00.000' AS DateTime), N'fr')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (121902, 103, N'Sunset Lover', N'Petit Biscuit', 30372, N'https://open.spotify.com/track/0hNduWmlWmEmuwEFcYvRu1', CAST(N'2017-08-30T00:00:00.000' AS DateTime), N'fr')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (137154, 155, N'Shine on my Way', N'Diva Faune', 24832, N'https://open.spotify.com/track/1LCdHocTe3wvSEPSISoEaQ', CAST(N'2017-11-14T00:00:00.000' AS DateTime), N'fr')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (139245, 46, N'Django', N'Dadju', 77111, N'https://open.spotify.com/track/51PPDB9v8QOMkiUe06eYfc', CAST(N'2017-11-25T00:00:00.000' AS DateTime), N'fr')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (143853, 54, N'Him & I (with Halsey)', N'G-Eazy', 52233, N'https://open.spotify.com/track/5k38wzpLb15YgncyWdTZE4', CAST(N'2017-12-18T00:00:00.000' AS DateTime), N'fr')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (145609, 10, N'Bling Bling', N'Kaaris', 97760, N'https://open.spotify.com/track/4s7OqcUEyLJ1RkbzBopRGt', CAST(N'2017-12-27T00:00:00.000' AS DateTime), N'fr')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (182513, 114, N'Mala Mujer', N'C. Tangana', 18833, N'https://open.spotify.com/track/6puxHBNwu2Nmm7uD3Rd2MP', CAST(N'2017-06-23T00:00:00.000' AS DateTime), N'ar')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (189647, 48, N'Imitadora', N'Romeo Santos', 52478, N'https://open.spotify.com/track/6r46lnXFbE9fr2d3KNaGbe', CAST(N'2017-07-29T00:00:00.000' AS DateTime), N'ar')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (237862, 63, N'Bad and Boujee (feat. Lil Uzi Vert)', N'Migos', 16628, N'https://open.spotify.com/track/4Km5HrUvYTaSUfiSGPJeQR', CAST(N'2017-03-18T00:00:00.000' AS DateTime), N'fi')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (242372, 173, N'Laula lujempaa (Show Must Go On)', N'Haloo Helsinki!', 5338, N'https://open.spotify.com/track/7twLnN62kZTfE6QaIOpyuN', CAST(N'2017-04-09T00:00:00.000' AS DateTime), N'fi')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (242543, 144, N'Leijonakuningas', N'Ellinoora', 6471, N'https://open.spotify.com/track/4MsOdD6nhPuvnK9MyVAniA', CAST(N'2017-04-10T00:00:00.000' AS DateTime), N'fi')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (273818, 19, N'Too Good At Goodbyes - Edit', N'Sam Smith', 37747, N'https://open.spotify.com/track/0mel2N9Ws9r4yLQn5QE21Y', CAST(N'2017-09-17T00:00:00.000' AS DateTime), N'fi')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (301207, 8, N'Make Me (Cry)', N'Noah Cyrus', 81932, N'https://open.spotify.com/track/2BrzlUj1u1CtvaJDGIKpsP', CAST(N'2017-01-23T00:00:00.000' AS DateTime), N'no')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (303651, 52, N'Heart Won''t Forget', N'Matoma', 28047, N'https://open.spotify.com/track/2of2DM5LqTh7ohmmVXUKsH', CAST(N'2017-02-04T00:00:00.000' AS DateTime), N'no')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (306207, 8, N'Alone', N'Alan Walker', 92447, N'https://open.spotify.com/track/0JiVRyTJcJnmlwCZ854K4p', CAST(N'2017-02-17T00:00:00.000' AS DateTime), N'no')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (317408, 9, N'Scared to Be Lonely', N'Martin Garrix', 71259, N'https://open.spotify.com/track/3ebXMykcMXOcLeJ9xZ17XH', CAST(N'2017-04-14T00:00:00.000' AS DateTime), N'no')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (327340, 141, N'Be Mine', N'Ofenbach', 12094, N'https://open.spotify.com/track/2KklXplRtxMsBYo474Es0w', CAST(N'2017-06-05T00:00:00.000' AS DateTime), N'no')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (337813, 14, N'Party On The West Coast (feat. Snoop Dogg)', N'Matoma', 73059, N'https://open.spotify.com/track/45OfR7ugJMgbFDuNOVpIq3', CAST(N'2017-07-28T00:00:00.000' AS DateTime), N'no')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (346306, 107, N'Go Flex', N'Post Malone', 18047, N'https://open.spotify.com/track/5yuShbu70mtHXY0yLzCQLQ', CAST(N'2017-09-08T00:00:00.000' AS DateTime), N'no')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (350824, 25, N'Unforgettable', N'French Montana', 46603, N'https://open.spotify.com/track/3B54sVLJ402zGa6Xm4YGNe', CAST(N'2017-10-01T00:00:00.000' AS DateTime), N'no')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (360998, 199, N'Awful Things', N'Lil Peep', 9911, N'https://open.spotify.com/track/0bcEHhsuLRDm712CQHomdm', CAST(N'2017-11-20T00:00:00.000' AS DateTime), N'no')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (375672, 73, N'Tutto il mondo v® periferia', N'J-AX', 18919, N'https://open.spotify.com/track/4OMeKnO7P2taRNhqx00Cio', CAST(N'2017-01-24T00:00:00.000' AS DateTime), N'it')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (401574, 175, N'Vietato morire', N'Ermal Meta', 13228, N'https://open.spotify.com/track/681fNvwhF5pF9sYiiOycPp', CAST(N'2017-06-05T00:00:00.000' AS DateTime), N'it')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (413409, 10, N'El Party', N'Jake La Furia', 100715, N'https://open.spotify.com/track/5xyExId5XWZplBvjmbIuy6', CAST(N'2017-08-04T00:00:00.000' AS DateTime), N'it')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (428248, 49, N'Galway Girl', N'Ed Sheeran', 44892, N'https://open.spotify.com/track/0afhq8XCExXpqazXczTSve', CAST(N'2017-10-17T00:00:00.000' AS DateTime), N'it')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (442607, 8, N'Perfect Duet (Ed Sheeran & Beyonce)', N'Ed Sheeran', 90487, N'https://open.spotify.com/track/1bhUWB0zJMIKr9yVPrkEuI', CAST(N'2017-12-28T00:00:00.000' AS DateTime), N'it')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (455547, 44, N'First Time', N'Kygo', 1224, N'https://open.spotify.com/track/2Gl0FzuLxflY6nPifJp5Dr', CAST(N'2017-07-12T00:00:00.000' AS DateTime), N'lt')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (459929, 49, N'Jocelyn Flores', N'XXXTENTACION', 1137, N'https://open.spotify.com/track/7m9OqQk4RVRkw9JJdeAw96', CAST(N'2017-10-27T00:00:00.000' AS DateTime), N'lt')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (462814, 16, N'Perfect Strangers', N'Jonas Blue', 109998, N'https://open.spotify.com/track/1CUVN2kn7mW5FjkqXTR2W1', CAST(N'2017-01-05T00:00:00.000' AS DateTime), N'ph')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (464107, 109, N'Terrified', N'Katharine McPhee', 22714, N'https://open.spotify.com/track/6vtOX9riyVzwJxj2SYTuES', CAST(N'2017-01-11T00:00:00.000' AS DateTime), N'ph')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (479815, 17, N'Touch', N'Little Mix', 96248, N'https://open.spotify.com/track/5Ua3GXyHwiSfpNTMjq6m2z', CAST(N'2017-03-31T00:00:00.000' AS DateTime), N'ph')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (482402, 4, N'Versace On The Floor', N'Bruno Mars', 144230, N'https://open.spotify.com/track/0kN8xEmgMW9mh7UmDYHlJP', CAST(N'2017-04-13T00:00:00.000' AS DateTime), N'ph')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (485240, 42, N'All We Know', N'The Chainsmokers', 65113, N'https://open.spotify.com/track/2rizacJSyD9S1IQUxUxnsK', CAST(N'2017-04-27T00:00:00.000' AS DateTime), N'ph')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (485513, 115, N'Paano Ba Ang Magmahal', N'Piolo Pascual', 25530, N'https://open.spotify.com/track/2qqte0XT0eFFVLuNP7Qena', CAST(N'2017-04-28T00:00:00.000' AS DateTime), N'ph')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (496406, 8, N'Attention', N'Charlie Puth', 113556, N'https://open.spotify.com/track/4iLqG9SeJSnt0cSPICSjxv', CAST(N'2017-06-25T00:00:00.000' AS DateTime), N'ph')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (505727, 129, N'Happier', N'Ed Sheeran', 25368, N'https://open.spotify.com/track/2RttW7RAu5nOAfq6YFvApB', CAST(N'2017-08-10T00:00:00.000' AS DateTime), N'ph')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (510338, 140, N'Beautiful Soul', N'Jesse McCartney', 22060, N'https://open.spotify.com/track/1HwpWwa6bnqqRhK8agG4RS', CAST(N'2017-09-02T00:00:00.000' AS DateTime), N'ph')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (512733, 135, N'Set You Free', N'MYMP', 25481, N'https://open.spotify.com/track/6CiuHbascZBxfFqdixSXiW', CAST(N'2017-09-14T00:00:00.000' AS DateTime), N'ph')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (525362, 164, N'More Than Words', N'Extreme', 21127, N'https://open.spotify.com/track/1gVgkQFOKa8Wc1HYsJtPdH', CAST(N'2017-11-16T00:00:00.000' AS DateTime), N'ph')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (528597, 199, N'A Thousand Years', N'Christina Perri', 17876, N'https://open.spotify.com/track/6lanRgr6wXibZr8KgzXxBl', CAST(N'2017-12-02T00:00:00.000' AS DateTime), N'ph')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (538837, 39, N'Scars To Your Beautiful', N'Alessia Cara', 7661, N'https://open.spotify.com/track/0prNGof3XqfTvNDxHonvdK', CAST(N'2017-01-14T00:00:00.000' AS DateTime), N'tw')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (542617, 19, N'‰O†,•O‰?ç•O? - Ending Theme Song of TVBS Series "Life List"', N'Eric Chou', 10600, N'https://open.spotify.com/track/2gug6MRv4xQFYi9LA3PJCS', CAST(N'2017-02-02T00:00:00.000' AS DateTime), N'tw')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (546207, 9, N'Castle on the Hill', N'Ed Sheeran', 15127, N'https://open.spotify.com/track/6PCUP3dWmTjcTtXY02oFdT', CAST(N'2017-02-20T00:00:00.000' AS DateTime), N'tw')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (580298, 100, N'All Night', N'Girls'' Generation', 3808, N'https://open.spotify.com/track/1UwERmn5UogyCz6qo21BmA', CAST(N'2017-08-12T00:00:00.000' AS DateTime), N'tw')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (605675, 77, N'I Like Me Better', N'Lauv', 5246, N'https://open.spotify.com/track/1wjzFQodRWrPcQ0AnYnvQ9', CAST(N'2017-12-17T00:00:00.000' AS DateTime), N'tw')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (610504, 106, N'Cake By The Ocean', N'DNCE', 4889, N'https://open.spotify.com/track/2aFiaMXmWsM3Vj72F9ksBl', CAST(N'2017-01-01T00:00:00.000' AS DateTime), N'nz')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (623249, 51, N'Solo Dance', N'Martin Jensen', 14617, N'https://open.spotify.com/track/6HUnnBwYZqcED1eQztxMBN', CAST(N'2017-03-06T00:00:00.000' AS DateTime), N'nz')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (688571, 34, N'Location', N'Khalid', 1119, N'https://open.spotify.com/track/152lZdxL1OR0ZMW6KquMif', CAST(N'2017-04-04T00:00:00.000' AS DateTime), N'ee')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (696149, 2, N'Perfect Duet (Ed Sheeran & Beyonce)', N'Ed Sheeran', 3815, N'https://open.spotify.com/track/1bhUWB0zJMIKr9yVPrkEuI', CAST(N'2017-12-01T00:00:00.000' AS DateTime), N'ee')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (697054, 37, N'Santa Baby', N'Eartha Kitt', 1450, N'https://open.spotify.com/track/1foCxQtxBweJtZmdxhEHVO', CAST(N'2017-12-23T00:00:00.000' AS DateTime), N'ee')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (716091, 70, N'Lush Life', N'Zara Larsson', 8068, N'https://open.spotify.com/track/1rIKgCH4H52lrvDcz50hS8', CAST(N'2017-04-04T00:00:00.000' AS DateTime), N'tr')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (717258, 37, N'Olsun', N'Sertab Erener', 15010, N'https://open.spotify.com/track/07Af1vF3LFqNrmLC1Yzs0L', CAST(N'2017-04-10T00:00:00.000' AS DateTime), N'tr')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (720355, 134, N'Panda', N'Desiigner', 6048, N'https://open.spotify.com/track/5OOkp4U9P9oL23maHFHL1h', CAST(N'2017-04-25T00:00:00.000' AS DateTime), N'tr')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (722663, 42, N'366.Gvºn', N'Sagopa Kajmer', 14090, N'https://open.spotify.com/track/1EuFr1JA70TaEzlaSM4ulc', CAST(N'2017-05-07T00:00:00.000' AS DateTime), N'tr')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (726819, 198, N'Janti', N'Murat Boz', 4608, N'https://open.spotify.com/track/20NWw4dRWT67e82Jrj6x85', CAST(N'2017-05-27T00:00:00.000' AS DateTime), N'tr')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (776822, 1, N'Bad and Boujee (feat. Lil Uzi Vert)', N'Migos', 1823391, N'https://open.spotify.com/track/4Km5HrUvYTaSUfiSGPJeQR', CAST(N'2017-01-27T00:00:00.000' AS DateTime), N'us')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (791152, 131, N'Side To Side', N'Ariana Grande', 224324, N'https://open.spotify.com/track/4pLwZjInHj3SimIyN9SnOz', CAST(N'2017-04-08T00:00:00.000' AS DateTime), N'us')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (792222, 1, N'HUMBLE.', N'Kendrick Lamar', 4068152, N'https://open.spotify.com/track/7KXjTSCq5nL1LoYtL7XAwS', CAST(N'2017-04-14T00:00:00.000' AS DateTime), N'us')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (792223, 2, N'DNA.', N'Kendrick Lamar', 3643231, N'https://open.spotify.com/track/6HZILIRieu8S0iqY8kIKhj', CAST(N'2017-04-14T00:00:00.000' AS DateTime), N'us')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (792422, 1, N'HUMBLE.', N'Kendrick Lamar', 3526246, N'https://open.spotify.com/track/7KXjTSCq5nL1LoYtL7XAwS', CAST(N'2017-04-15T00:00:00.000' AS DateTime), N'us')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (792423, 2, N'DNA.', N'Kendrick Lamar', 3013496, N'https://open.spotify.com/track/6HZILIRieu8S0iqY8kIKhj', CAST(N'2017-04-15T00:00:00.000' AS DateTime), N'us')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (792822, 1, N'HUMBLE.', N'Kendrick Lamar', 3337001, N'https://open.spotify.com/track/7KXjTSCq5nL1LoYtL7XAwS', CAST(N'2017-04-17T00:00:00.000' AS DateTime), N'us')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (793022, 1, N'HUMBLE.', N'Kendrick Lamar', 3394456, N'https://open.spotify.com/track/7KXjTSCq5nL1LoYtL7XAwS', CAST(N'2017-04-18T00:00:00.000' AS DateTime), N'us')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (793222, 1, N'HUMBLE.', N'Kendrick Lamar', 3255141, N'https://open.spotify.com/track/7KXjTSCq5nL1LoYtL7XAwS', CAST(N'2017-04-19T00:00:00.000' AS DateTime), N'us')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (793422, 1, N'HUMBLE.', N'Kendrick Lamar', 3144482, N'https://open.spotify.com/track/7KXjTSCq5nL1LoYtL7XAwS', CAST(N'2017-04-20T00:00:00.000' AS DateTime), N'us')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (793622, 1, N'HUMBLE.', N'Kendrick Lamar', 3172718, N'https://open.spotify.com/track/7KXjTSCq5nL1LoYtL7XAwS', CAST(N'2017-04-21T00:00:00.000' AS DateTime), N'us')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (811266, 45, N'Young Dumb & Broke', N'Khalid', 524715, N'https://open.spotify.com/track/5Z3GHaZ6ec9bsiI5BenrbY', CAST(N'2017-07-21T00:00:00.000' AS DateTime), N'us')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (818222, 1, N'Look What You Made Me Do', N'Taylor Swift', 3828478, N'https://open.spotify.com/track/2VjtYe7gpfUi2OkGxR2O2z', CAST(N'2017-08-25T00:00:00.000' AS DateTime), N'us')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (863110, 44, N'Bad Liar', N'Selena Gomez', 1857, N'https://open.spotify.com/track/1sCxVKWImDZSZKvG0U9B23', CAST(N'2017-07-10T00:00:00.000' AS DateTime), N'sv')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (865127, 56, N'Let Me Love You', N'DJ Snake', 1526, N'https://open.spotify.com/track/4pdPtRcBmOSQDlJ3Fk945m', CAST(N'2017-07-27T00:00:00.000' AS DateTime), N'sv')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (869079, 10, N'Ahora Dice', N'Chris Jeday', 4543, N'https://open.spotify.com/track/22eADXu8DfOAUEDw4vU8qy', CAST(N'2017-08-30T00:00:00.000' AS DateTime), N'sv')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (893086, 172, N'6 AM (Remix)', N'Enzo Ortiz', 2194, N'https://open.spotify.com/track/3WHqVVRvPDWz033iPs04md', CAST(N'2017-02-11T00:00:00.000' AS DateTime), N'cr')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (895852, 138, N'Let Her Go', N'Passenger', 2722, N'https://open.spotify.com/track/2jyjhRf6DVbMPU5zxagN2h', CAST(N'2017-02-25T00:00:00.000' AS DateTime), N'cr')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (972724, 10, N'You Don''t Know Me - Radio Edit', N'Jax Jones', 255434, N'https://open.spotify.com/track/00lNx0OcTJrS3MKHcB80HY', CAST(N'2017-03-11T00:00:00.000' AS DateTime), N'de')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (1040243, 129, N'The Greatest', N'Sia', 10531, N'https://open.spotify.com/track/7xHWNBFm6ObGEQPaUxHuKO', CAST(N'2017-02-05T00:00:00.000' AS DateTime), N'cl')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (1044724, 10, N'Vacaciones', N'Wisin', 86922, N'https://open.spotify.com/track/3dQDid3IUNhZy1OehIfYfE', CAST(N'2017-02-28T00:00:00.000' AS DateTime), N'cl')
GO
INSERT [dbo].[spotify_worldwide_daily_song_ranking] ([id], [position], [trackname], [artist], [streams], [url], [date], [region]) VALUES (1046089, 175, N'The Greatest', N'Sia', 10060, N'https://open.spotify.com/track/7xHWNBFm6ObGEQPaUxHuKO', CAST(N'2017-03-06T00:00:00.000' AS DateTime), N'cl')
GO


Comments (0)
Questions List