# View: round_hill_streaming_report_request

**View Name:** round_hill_streaming_report_request
**Table Source:** `Derived from: Dbt_Prod.Summary_Streams, Intelligence.Dbt_Prod, Prod.Dim_Artist, Prod.Dim_Label, Prod.Dim_Release + 2 more`
**File Path:** `round_hill_streaming_report_request.view.lkml`

## Overview

- **File Size:** 22390 bytes
- **Lines of Code:** 316
- **Dimensions:** 8
- **Measures:** 1
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `facts_prod_dim_track_track_name` | string |
| `int_dbt_prod_summary_streams_isrc` | string |
| `facts_prod_dim_artist_artist_name` | string |
| `facts_prod_dim_label_label_name` | string |
| `int_dbt_prod_summary_streams_activity_date_month` | date |
| `int_dbt_prod_summary_streams_label_id` | number |
| `int_dbt_prod_summary_streams_streams` | number |
| `row_num` | number |

## Measures

| Name | Type |
|------|------|
| `count` | count |

## Derived Table

```sql
sql: (WITH ranked_tracks AS (
          SELECT
              facts_prod_dim_track.trackname  AS "facts_prod_dim_track.track_name",
              int_dbt_prod_summary_streams.isrc  AS "int_dbt_prod_summary_streams.isrc",
              facts_prod_dim_artist.artistname  AS "facts_prod_dim_artist.artist_name",
              facts_prod_dim_label.labelname  AS "facts_prod_dim_label.label_name",
              DATE_TRUNC('month', int_dbt_prod_summary_streams.download_activity_date) AS "int_dbt_prod_summary_streams.activity_date_month",
              int_dbt_prod_summary_streams.label_id  AS "int_dbt_prod_summary_streams.label_id",
              SUM(int_dbt_prod_summary_streams.streams) AS "int_dbt_prod_summary_streams.streams",
              ROW_NUMBER() OVER (PARTITION BY DATE_TRUNC('month', int_dbt_prod_summary_streams.download_activity_date) ORDER BY SUM(int_dbt_prod_summary_streams.streams) DESC) AS row_num
          FROM INTELLIGENCE.DBT_PROD.SUMMARY_STREAMS  AS int_dbt_prod_summary_streams
          LEFT JOIN facts.prod.dim_release  AS facts_prod_dim_release ON (ltrim(int_dbt_prod_summary_streams.upc,0)) = to_varchar(facts_prod_dim_release.releaseid)
          LEFT JOIN facts.prod.dim_track  AS facts_prod_dim_track ON to_varchar(int_dbt_prod_summary_streams.isrc) = to_varchar(facts_prod_dim_track.isrc)
              AND (ltrim(int_dbt_prod_summary_streams.upc,0)) =  to_varchar(facts_prod_dim_track.upc)
          LEFT JOIN facts.prod.dim_artist  AS facts_prod_dim_artist ON facts_prod_dim_release.artistid = facts_prod_dim_artist.artistid
          LEFT JOIN facts.prod.dim_label  AS facts_prod_dim_label ON int_dbt_prod_summary_streams.label_id = facts_prod_dim_label.labelid
          WHERE ((( int_dbt_prod_summary_streams.download_activity_date  ) >= ((DATEADD('month', -3, DATE_TRUNC('month', CURRENT_DATE())))) AND ( int_dbt_prod_summary_streams.download_activity_date  ) < ((DATEADD('month', 3, DATEADD('month', -3, DATE_TRUNC('month', CURRENT_DATE()))))))) AND (int_dbt_prod_summary_streams.label_id ) = 56425 AND (int_dbt_prod_summary_streams.label_id != 32551 )
          GROUP BY
              DATE_TRUNC('month', int_dbt_prod_summary_streams.download_activity_date),
              facts_prod_dim_track.trackname,
              int_dbt_prod_summary_streams.isrc,
              facts_prod_dim_artist.artistname,
              facts_prod_dim_label.labelname,
              int_dbt_prod_summary_streams.label_id
      )
      SELECT * 
      FROM ranked_tracks
      WHERE row_num = 1
      ORDER BY "int_dbt_prod_summary_streams.activity_date_month" DESC)
      
      UNION ALL 
      
      (WITH ranked_tracks AS (
          SELECT
              facts_prod_dim_track.trackname  AS "facts_prod_dim_track.track_name",
              int_dbt_prod_summary_streams.isrc  AS "int_dbt_prod_summary_streams.isrc",
              facts_prod_dim_artist.artistname  AS "facts_prod_dim_artist.artist_name",
              facts_prod_dim_label.labelname  AS "facts_prod_dim_label.label_name",
              DATE_TRUNC('month', int_dbt_prod_summary_streams.download_activity_date) AS "int_dbt_prod_summary_streams.activity_date_month",
              int_dbt_prod_summary_streams.label_id  AS "int_dbt_prod_summary_streams.label_id",
              SUM(int_dbt_prod_summary_streams.streams) AS "int_dbt_prod_summary_streams.streams",
              ROW_NUMBER() OVER (PARTITION BY DATE_TRUNC('month', int_dbt_prod_summary_streams.download_activity_date) ORDER BY SUM(int_dbt_prod_summary_streams.streams) DESC) AS row_num
          FROM INTELLIGENCE.DBT_PROD.SUMMARY_STREAMS  AS int_dbt_prod_summary_streams
          LEFT JOIN facts.prod.dim_release  AS facts_prod_dim_release ON (ltrim(int_dbt_prod_summary_streams.upc,0)) = to_varchar(facts_prod_dim_release.releaseid)
          LEFT JOIN facts.prod.dim_track  AS facts_prod_dim_track ON to_varchar(int_dbt_prod_summary_streams.isrc) = to_varchar(facts_prod_dim_track.isrc)
              AND (ltrim(int_dbt_prod_summary_streams.upc,0)) =  to_varchar(facts_prod_dim_track.upc)
          LEFT JOIN facts.prod.dim_artist  AS facts_prod_dim_artist ON facts_prod_dim_release.artistid = facts_prod_dim_artist.artistid
          LEFT JOIN facts.prod.dim_label  AS facts_prod_dim_label ON int_dbt_prod_summary_streams.label_id = facts_prod_dim_label.labelid
          WHERE ((( int_dbt_prod_summary_streams.download_activity_date  ) >= ((DATEADD('month', -3, DATE_TRUNC('month', CURRENT_DATE())))) AND ( int_dbt_prod_summary_streams.download_activity_date  ) < ((DATEADD('month', 3, DATEADD('month', -3, DATE_TRUNC('month', CURRENT_DATE()))))))) AND (int_dbt_prod_summary_streams.label_id ) = 26658 AND (int_dbt_prod_summary_streams.label_id != 32551 )
          GROUP BY
              DATE_TRUNC('month', int_dbt_prod_summary_streams.download_activity_date),
              facts_prod_dim_track.trackname,
              int_dbt_prod_summary_streams.isrc,
              facts_prod_dim_artist.artistname,
              facts_prod_dim_label.labelname,
              int_dbt_prod_summary_streams.label_id
      )
      SELECT * 
      FROM ranked_tracks
      WHERE row_num = 1
      ORDER BY "int_dbt_prod_summary_streams.activity_date_month" DESC)
      
      UNION ALL 
      
      (WITH ranked_tracks AS (
          SELECT
              facts_prod_dim_track.trackname  AS "facts_prod_dim_track.track_name",
              int_dbt_prod_summary_streams.isrc  AS "int_dbt_prod_summary_streams.isrc",
              facts_prod_dim_artist.artistname  AS "facts_prod_dim_artist.artist_name",
              facts_prod_dim_label.labelname  AS "facts_prod_dim_label.label_name",
              DATE_TRUNC('month', int_dbt_prod_summary_streams.download_activity_date) AS "int_dbt_prod_summary_streams.activity_date_month",
              int_dbt_prod_summary_streams.label_id  AS "int_dbt_prod_summary_streams.label_id",
              SUM(int_dbt_prod_summary_streams.streams) AS "int_dbt_prod_summary_streams.streams",
              ROW_NUMBER() OVER (PARTITION BY DATE_TRUNC('month', int_dbt_prod_summary_streams.download_activity_date) ORDER BY SUM(int_dbt_prod_summary_streams.streams) DESC) AS row_num
          FROM INTELLIGENCE.DBT_PROD.SUMMARY_STREAMS  AS int_dbt_prod_summary_streams
          LEFT JOIN facts.prod.dim_release  AS facts_prod_dim_release ON (ltrim(int_dbt_prod_summary_streams.upc,0)) = to_varchar(facts_prod_dim_release.releaseid)
          LEFT JOIN facts.prod.dim_track  AS facts_prod_dim_track ON to_varchar(int_dbt_prod_summary_streams.isrc) = to_varchar(facts_prod_dim_track.isrc)
              AND (ltrim(int_dbt_prod_summary_streams.upc,0)) =  to_varchar(facts_prod_dim_track.upc)
          LEFT JOIN facts.prod.dim_artist  AS facts_prod_dim_artist ON facts_prod_dim_release.artistid = facts_prod_dim_artist.artistid
          LEFT JOIN facts.prod.dim_label  AS facts_prod_dim_label ON int_dbt_prod_summary_streams.label_id = facts_prod_dim_label.labelid
          WHERE ((( int_dbt_prod_summary_streams.download_activity_date  ) >= ((DATEADD('month', -3, DATE_TRUNC('month', CURRENT_DATE())))) AND ( int_dbt_prod_summary_streams.download_activity_date  ) < ((DATEADD('month', 3, DATEADD('month', -3, DATE_TRUNC('month', CURRENT_DATE()))))))) AND (int_dbt_prod_summary_streams.label_id ) = 26688 AND (int_dbt_prod_summary_streams.label_id != 32551 )
          GROUP BY
              DATE_TRUNC('month', int_dbt_prod_summary_streams.download_activity_date),
              facts_prod_dim_track.trackname,
              int_dbt_prod_summary_streams.isrc,
              facts_prod_dim_artist.artistname,
              facts_prod_dim_label.labelname,
              int_dbt_prod_summary_streams.label_id
      )
      SELECT * 
      FROM ranked_tracks
      WHERE row_num = 1
      ORDER BY "int_dbt_prod_summary_streams.activity_date_month" DESC)
      
      UNION ALL 
      
      (WITH ranked_tracks AS (
          SELECT
              facts_prod_dim_track.trackname  AS "facts_prod_dim_track.track_name",
              int_dbt_prod_summary_streams.isrc  AS "int_dbt_prod_summary_streams.isrc",
              facts_prod_dim_artist.artistname  AS "facts_prod_dim_artist.artist_name",
              facts_prod_dim_label.labelname  AS "facts_prod_dim_label.label_name",
              DATE_TRUNC('month', int_dbt_prod_summary_streams.download_activity_date) AS "int_dbt_prod_summary_streams.activity_date_month",
              int_dbt_prod_summary_streams.label_id  AS "int_dbt_prod_summary_streams.label_id",
              SUM(int_dbt_prod_summary_streams.streams) AS "int_dbt_prod_summary_streams.streams",
              ROW_NUMBER() OVER (PARTITION BY DATE_TRUNC('month', int_dbt_prod_summary_streams.download_activity_date) ORDER BY SUM(int_dbt_prod_summary_streams.streams) DESC) AS row_num
          FROM INTELLIGENCE.DBT_PROD.SUMMARY_STREAMS  AS int_dbt_prod_summary_streams
          LEFT JOIN facts.prod.dim_release  AS facts_prod_dim_release ON (ltrim(int_dbt_prod_summary_streams.upc,0)) = to_varchar(facts_prod_dim_release.releaseid)
          LEFT JOIN facts.prod.dim_track  AS facts_prod_dim_track ON to_varchar(int_dbt_prod_summary_streams.isrc) = to_varchar(facts_prod_dim_track.isrc)
              AND (ltrim(int_dbt_prod_summary_streams.upc,0)) =  to_varchar(facts_prod_dim_track.upc)
          LEFT JOIN facts.prod.dim_artist  AS facts_prod_dim_artist ON facts_prod_dim_release.artistid = facts_prod_dim_artist.artistid
          LEFT JOIN facts.prod.dim_label  AS facts_prod_dim_label ON int_dbt_prod_summary_streams.label_id = facts_prod_dim_label.labelid
          WHERE ((( int_dbt_prod_summary_streams.download_activity_date  ) >= ((DATEADD('month', -3, DATE_TRUNC('month', CURRENT_DATE())))) AND ( int_dbt_prod_summary_streams.download_activity_date  ) < ((DATEADD('month', 3, DATEADD('month', -3, DATE_TRUNC('month', CURRENT_DATE()))))))) AND (int_dbt_prod_summary_streams.label_id ) = 35651 AND (int_dbt_prod_summary_streams.label_id != 32551 )
          GROUP BY
              DATE_TRUNC('month', int_dbt_prod_summary_streams.download_activity_date),
              facts_prod_dim_track.trackname,
              int_dbt_prod_summary_streams.isrc,
              facts_prod_dim_artist.artistname,
              facts_prod_dim_label.labelname,
              int_dbt_prod_summary_streams.label_id
      )
      SELECT * 
      FROM ranked_tracks
      WHERE row_num = 1
      ORDER BY "int_dbt_prod_summary_streams.activity_date_month" DESC)
      
      UNION ALL 
      
      (WITH ranked_tracks AS (
          SELECT
              facts_prod_dim_track.trackname  AS "facts_prod_dim_track.track_name",
              int_dbt_prod_summary_streams.isrc  AS "int_dbt_prod_summary_streams.isrc",
              facts_prod_dim_artist.artistname  AS "facts_prod_dim_artist.artist_name",
              facts_prod_dim_label.labelname  AS "facts_prod_dim_label.label_name",
              DATE_TRUNC('month', int_dbt_prod_summary_streams.download_activity_date) AS "int_dbt_prod_summary_streams.activity_date_month",
              int_dbt_prod_summary_streams.label_id  AS "int_dbt_prod_summary_streams.label_id",
              SUM(int_dbt_prod_summary_streams.streams) AS "int_dbt_prod_summary_streams.streams",
              ROW_NUMBER() OVER (PARTITION BY DATE_TRUNC('month', int_dbt_prod_summary_streams.download_activity_date) ORDER BY SUM(int_dbt_prod_summary_streams.streams) DESC) AS row_num
          FROM INTELLIGENCE.DBT_PROD.SUMMARY_STREAMS  AS int_dbt_prod_summary_streams
          LEFT JOIN facts.prod.dim_release  AS facts_prod_dim_release ON (ltrim(int_dbt_prod_summary_streams.upc,0)) = to_varchar(facts_prod_dim_release.releaseid)
          LEFT JOIN facts.prod.dim_track  AS facts_prod_dim_track ON to_varchar(int_dbt_prod_summary_streams.isrc) = to_varchar(facts_prod_dim_track.isrc)
              AND (ltrim(int_dbt_prod_summary_streams.upc,0)) =  to_varchar(facts_prod_dim_track.upc)
          LEFT JOIN facts.prod.dim_artist  AS facts_prod_dim_artist ON facts_prod_dim_release.artistid = facts_prod_dim_artist.artistid
          LEFT JOIN facts.prod.dim_label  AS facts_prod_dim_label ON int_dbt_prod_summary_streams.label_id = facts_prod_dim_label.labelid
          WHERE ((( int_dbt_prod_summary_streams.download_activity_date  ) >= ((DATEADD('month', -3, DATE_TRUNC('month', CURRENT_DATE())))) AND ( int_dbt_prod_summary_streams.download_activity_date  ) < ((DATEADD('month', 3, DATEADD('month', -3, DATE_TRUNC('month', CURRENT_DATE()))))))) AND (int_dbt_prod_summary_streams.label_id ) = 35652 AND (int_dbt_prod_summary_streams.label_id != 32551 )
          GROUP BY
              DATE_TRUNC('month', int_dbt_prod_summary_streams.download_activity_date),
              facts_prod_dim_track.trackname,
              int_dbt_prod_summary_streams.isrc,
              facts_prod_dim_artist.artistname,
              facts_prod_dim_label.labelname,
              int_dbt_prod_summary_streams.label_id
      )
      SELECT * 
      FROM ranked_tracks
      WHERE row_num = 1
      ORDER BY "int_dbt_prod_summary_streams.activity_date_month" DESC)
      
      UNION ALL 
      
      (WITH ranked_tracks AS (
          SELECT
              facts_prod_dim_track.trackname  AS "facts_prod_dim_track.track_name",
              int_dbt_prod_summary_streams.isrc  AS "int_dbt_prod_summary_streams.isrc",
              facts_prod_dim_artist.artistname  AS "facts_prod_dim_artist.artist_name",
              facts_prod_dim_label.labelname  AS "facts_prod_dim_label.label_name",
              DATE_TRUNC('month', int_dbt_prod_summary_streams.download_activity_date) AS "int_dbt_prod_summary_streams.activity_date_month",
              int_dbt_prod_summary_streams.label_id  AS "int_dbt_prod_summary_streams.label_id",
              SUM(int_dbt_prod_summary_streams.streams) AS "int_dbt_prod_summary_streams.streams",
              ROW_NUMBER() OVER (PARTITION BY DATE_TRUNC('month', int_dbt_prod_summary_streams.download_activity_date) ORDER BY SUM(int_dbt_prod_summary_streams.streams) DESC) AS row_num
          FROM INTELLIGENCE.DBT_PROD.SUMMARY_STREAMS  AS int_dbt_prod_summary_streams
          LEFT JOIN facts.prod.dim_release  AS facts_prod_dim_release ON (ltrim(int_dbt_prod_summary_streams.upc,0)) = to_varchar(facts_prod_dim_release.releaseid)
          LEFT JOIN facts.prod.dim_track  AS facts_prod_dim_track ON to_varchar(int_dbt_prod_summary_streams.isrc) = to_varchar(facts_prod_dim_track.isrc)
              AND (ltrim(int_dbt_prod_summary_streams.upc,0)) =  to_varchar(facts_prod_dim_track.upc)
          LEFT JOIN facts.prod.dim_artist  AS facts_prod_dim_artist ON facts_prod_dim_release.artistid = facts_prod_dim_artist.artistid
          LEFT JOIN facts.prod.dim_label  AS facts_prod_dim_label ON int_dbt_prod_summary_streams.label_id = facts_prod_dim_label.labelid
          WHERE ((( int_dbt_prod_summary_streams.download_activity_date  ) >= ((DATEADD('month', -3, DATE_TRUNC('month', CURRENT_DATE())))) AND ( int_dbt_prod_summary_streams.download_activity_date  ) < ((DATEADD('month', 3, DATEADD('month', -3, DATE_TRUNC('month', CURRENT_DATE()))))))) AND (int_dbt_prod_summary_streams.label_id ) = 23594 AND (int_dbt_prod_summary_streams.label_id != 32551 )
          GROUP BY
              DATE_TRUNC('month', int_dbt_prod_summary_streams.download_activity_date),
              facts_prod_dim_track.trackname,
              int_dbt_prod_summary_streams.isrc,
              facts_prod_dim_artist.artistname,
              facts_prod_dim_label.labelname,
              int_dbt_prod_summary_streams.label_id
      )
      SELECT * 
      FROM ranked_tracks
      WHERE row_num = 1
      ORDER BY "int_dbt_prod_summary_streams.activity_date_month" DESC)
      
      UNION ALL 
      
      (WITH ranked_tracks AS (
          SELECT
              facts_prod_dim_track.trackname  AS "facts_prod_dim_track.track_name",
              int_dbt_prod_summary_streams.isrc  AS "int_dbt_prod_summary_streams.isrc",
              facts_prod_dim_artist.artistname  AS "facts_prod_dim_artist.artist_name",
              facts_prod_dim_label.labelname  AS "facts_prod_dim_label.label_name",
              DATE_TRUNC('month', int_dbt_prod_summary_streams.download_activity_date) AS "int_dbt_prod_summary_streams.activity_date_month",
              int_dbt_prod_summary_streams.label_id  AS "int_dbt_prod_summary_streams.label_id",
              SUM(int_dbt_prod_summary_streams.streams) AS "int_dbt_prod_summary_streams.streams",
              ROW_NUMBER() OVER (PARTITION BY DATE_TRUNC('month', int_dbt_prod_summary_streams.download_activity_date) ORDER BY SUM(int_dbt_prod_summary_streams.streams) DESC) AS row_num
          FROM INTELLIGENCE.DBT_PROD.SUMMARY_STREAMS  AS int_dbt_prod_summary_streams
          LEFT JOIN facts.prod.dim_release  AS facts_prod_dim_release ON (ltrim(int_dbt_prod_summary_streams.upc,0)) = to_varchar(facts_prod_dim_release.releaseid)
          LEFT JOIN facts.prod.dim_track  AS facts_prod_dim_track ON to_varchar(int_dbt_prod_summary_streams.isrc) = to_varchar(facts_prod_dim_track.isrc)
              AND (ltrim(int_dbt_prod_summary_streams.upc,0)) =  to_varchar(facts_prod_dim_track.upc)
          LEFT JOIN facts.prod.dim_artist  AS facts_prod_dim_artist ON facts_prod_dim_release.artistid = facts_prod_dim_artist.artistid
          LEFT JOIN facts.prod.dim_label  AS facts_prod_dim_label ON int_dbt_prod_summary_streams.label_id = facts_prod_dim_label.labelid
          WHERE ((( int_dbt_prod_summary_streams.download_activity_date  ) >= ((DATEADD('month', -3, DATE_TRUNC('month', CURRENT_DATE())))) AND ( int_dbt_prod_summary_streams.download_activity_date  ) < ((DATEADD('month', 3, DATEADD('month', -3, DATE_TRUNC('month', CURRENT_DATE()))))))) AND (int_dbt_prod_summary_streams.label_id ) = 35650 AND (int_dbt_prod_summary_streams.label_id != 32551 )
          GROUP BY
              DATE_TRUNC('month', int_dbt_prod_summary_streams.download_activity_date),
              facts_prod_dim_track.trackname,
              int_dbt_prod_summary_streams.isrc,
              facts_prod_dim_artist.artistname,
              facts_prod_dim_label.labelname,
              int_dbt_prod_summary_streams.label_id
      )
      SELECT * 
      FROM ranked_tracks
      WHERE row_num = 1
      ORDER BY "int_dbt_prod_summary_streams.activity_date_month" DESC)
      
      UNION ALL 
      
      (WITH ranked_tracks AS (
          SELECT
              facts_prod_dim_track.trackname  AS "facts_prod_dim_track.track_name",
              int_dbt_prod_summary_streams.isrc  AS "int_dbt_prod_summary_streams.isrc",
              facts_prod_dim_artist.artistname  AS "facts_prod_dim_artist.artist_name",
              facts_prod_dim_label.labelname  AS "facts_prod_dim_label.label_name",
              DATE_TRUNC('month', int_dbt_prod_summary_streams.download_activity_date) AS "int_dbt_prod_summary_streams.activity_date_month",
              int_dbt_prod_summary_streams.label_id  AS "int_dbt_prod_summary_streams.label_id",
              SUM(int_dbt_prod_summary_streams.streams) AS "int_dbt_prod_summary_streams.streams",
              ROW_NUMBER() OVER (PARTITION BY DATE_TRUNC('month', int_dbt_prod_summary_streams.download_activity_date) ORDER BY SUM(int_dbt_prod_summary_streams.streams) DESC) AS row_num
          FROM INTELLIGENCE.DBT_PROD.SUMMARY_STREAMS  AS int_dbt_prod_summary_streams
          LEFT JOIN facts.prod.dim_release  AS facts_prod_dim_release ON (ltrim(int_dbt_prod_summary_streams.upc,0)) = to_varchar(facts_prod_dim_release.releaseid)
          LEFT JOIN facts.prod.dim_track  AS facts_prod_dim_track ON to_varchar(int_dbt_prod_summary_streams.isrc) = to_varchar(facts_prod_dim_track.isrc)
              AND (ltrim(int_dbt_prod_summary_streams.upc,0)) =  to_varchar(facts_prod_dim_track.upc)
          LEFT JOIN facts.prod.dim_artist  AS facts_prod_dim_artist ON facts_prod_dim_release.artistid = facts_prod_dim_artist.artistid
          LEFT JOIN facts.prod.dim_label  AS facts_prod_dim_label ON int_dbt_prod_summary_streams.label_id = facts_prod_dim_label.labelid
          WHERE ((( int_dbt_prod_summary_streams.download_activity_date  ) >= ((DATEADD('month', -3, DATE_TRUNC('month', CURRENT_DATE())))) AND ( int_dbt_prod_summary_streams.download_activity_date  ) < ((DATEADD('month', 3, DATEADD('month', -3, DATE_TRUNC('month', CURRENT_DATE()))))))) AND (int_dbt_prod_summary_streams.label_id ) = 26586 AND (int_dbt_prod_summary_streams.label_id != 32551 )
          GROUP BY
              DATE_TRUNC('month', int_dbt_prod_summary_streams.download_activity_date),
              facts_prod_dim_track.trackname,
              int_dbt_prod_summary_streams.isrc,
              facts_prod_dim_artist.artistname,
              facts_prod_dim_label.labelname,
              int_dbt_prod_summary_streams.label_id
      )
      SELECT * 
      FROM ranked_tracks
      WHERE row_num = 1
      ORDER BY "int_dbt_prod_summary_streams.activity_date_month" DESC) ;;
```