Count Artist Occurrences On Spotify Ranking List
[]
['Create table If Not Exists Spotify (id int,track_name varchar(100),artist varchar(100))', 'Truncate table Spotify', "insert into Spotify (id, track_name, artist) values ('303651', 'Heart Won't Forget', 'Ed Sheeran')", "insert into Spotify (id, track_name, artist) values ('1046089', 'Shape of you', 'Sia')", "insert into Spotify (id, track_name, artist) values ('33445', 'I'm the one', 'DJ Khalid')", "insert into Spotify (id, track_name, artist) values ('811266', 'Young Dumb & Broke', 'DJ Khalid')", "insert into Spotify (id, track_name, artist) values ('505727', 'Happier', 'Ed Sheeran')"]
{"mysql": ["Create table If Not Exists Spotify (id int,track_name varchar(100),artist varchar(100))"], "mssql": ["Create table Spotify (id int,track_name varchar(100),artist varchar(100))"], "oraclesql": ["Create table  Spotify (id int,track_name varchar(100),artist varchar(100))"], "database": true, "name": "count_occurrences", "pythondata": ["Spotify = pd.DataFrame([], columns=['id', 'track_name', 'artist']).astype({'id':'Int64', 'track_name':'object', 'artist':'object'})"], "postgresql": ["Create table If Not Exists Spotify (id int,track_name varchar(100),artist varchar(100))"], "database_schema": {"Spotify": {"id": "INT", "track_name": "VARCHAR(100)", "artist": "VARCHAR(100)"}}}
{"mysql": ["MySQL", "<p><code>MySQL 8.0</code>.</p>"], "mssql": ["MS SQL Server", "<p><code>mssql server 2019</code>.</p>"], "oraclesql": ["Oracle", "<p><code>Oracle Sql 11.2</code>.</p>"], "pythondata": ["Pandas", "<p>Python 3.10 with Pandas 2.2.2 and NumPy 1.26.4</p>"], "postgresql": ["PostgreSQL", "<p>PostgreSQL 16</p>"]}
['Database']