query.sql

Total listens = 182986

# query 1
df = run_query(""" 
  SELECT DISTINCT recording_msid FROM table
""")
df.count = 119929

# query 2 
df = run_query("""
  SELECT DISTINCT recording_msid, track_name, artist_name, artist_msid,
                  release_name, release_msid, user_name, tags, artist_name, artist_msid, artist_mbids
                  FROM table
""")
df.count = 129124

# query 3
df = run_query("""
   SELECT DISTINCT recording_msid, track_name, artist_name, artist_msid,
                  release_name, release_msid FROM table
""")
df.count = 120592

# query 4
df = run_query("""
  SELECT DISTINCT recording_msid, track_name FROM table
""")
df.count = 120220

# query 5
df = run_query("""
  SELECT DISTINCT recording_msid, track_name, recording_mbid FROM table
""")
df.count = 123464