Spotify Data -- we are not given any streams less than 30 seconds. 
ie, we are not given the skips. 
=================================================================

setCluster(cluster=4)
qShowTables("Spotify")

qShowCols("staging_raw_spotify_v2")
qShowCols("staging_raw_spotify")

headDB("staging_raw_spotify_v2", where="NOT product = '' AND  NOT offline_timestamp is NULL")
headDB("staging_raw_spotify_v2", where="NOT offline_timestamp is NULL")
headDB("staging_raw_spotify_v2", where="NOT product = '' AND  length < 10")
headDB("staging_raw_spotify_v2", where="length < 10")


makeQry(tbl="staging_raw_spotify_v2", colsToAgg=c(gender="DISTINCT gender"), agg=NULL, colsToPull=NULL)
runQry("SELECT COUNT(*) AS rows
        ,  gender as gender
   FROM   staging_raw_spotify_v2
   GROUP BY 2")



      Running query on cluster 07  [Began at 17:38 PM]
   ---------------------------------------------------------------------------------------------------

   SELECT COUNT(*) AS rows
           ,  gender as gender
      FROM   staging_raw_spotify_v2
      GROUP BY 2
   ---------------------------------------------------------------------------------------------------
      Dim of results is   4 rows X 2 cols
      Total time to execute query was 10.35 seconds

         rows gender
1:  126560418   None
2: 2575659140 female
3: 4490651512   male
4:   16370057

runQry("SELECT min(length) from production.staging_raw_spotify_v2")
   ---------------------------------------------------------------------------------------------------
   SELECT min(length)
   FROM   production.staging_raw_spotify_v2
   ---------------------------------------------------------------------------------------------------
      Dim of results is   1 rows X 1 cols
      Total time to execute query was 4.24 seconds

   min
1:  30