# View: dt_label_review_accounting_non_release_level_country_rank

**View Name:** dt_label_review_accounting_non_release_level_country_rank
**Table Source:** `Derived from: Dbt_Prod_Label_Reviews.Label_Review_Accounting_Non_Release_Level, Intelligence.Dbt_Prod_Label_Reviews`
**File Path:** `dt_label_review_accounting_non_release_level_country_rank.view.lkml`

## Overview

- **File Size:** 1035 bytes
- **Lines of Code:** 36
- **Dimensions:** 3
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `label_id` | number |
| `country_name` | string |
| `row_number` | number |

## Derived Table

```sql
sql:
      select
        label_id,
        country_name,
        sum(gross_revenue_usd) as gross_revenue,
        row_number() over (partition by label_id order by gross_revenue desc) as row_number
      from INTELLIGENCE.DBT_PROD_LABEL_REVIEWS.LABEL_REVIEW_ACCOUNTING_NON_RELEASE_LEVEL
      where
        (((activity_month ) >= ((DATEADD('year', -1, DATE_TRUNC('year', CURRENT_DATE()))))
            AND ( activity_month ) < ((DATEADD('year', 1, DATEADD('year', -1, DATE_TRUNC('year', CURRENT_DATE())))))))
      AND ((UPPER(( LABEL_REVIEW_ACCOUNTING_NON_RELEASE_LEVEL.Transaction_group )) = UPPER('Streaming')))
      group by 1,2
    ;;
```