# View: moments_track_name_isrc_list

**View Name:** moments_track_name_isrc_list
**Table Source:** `Derived from: Prod.Dim_Track, Track_Ranks`
**File Path:** `views/moments_track_name_isrc_list.view.lkml`

## Overview

- **File Size:** 909 bytes
- **Lines of Code:** 49
- **Dimensions:** 2
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `isrc` | string |
| `track_name` | string |

## Derived Table

```sql
sql:
    with track_ranks as (
select
    isrc,
    trackname,
    count(trackname) as count_name,
    row_number() over (partition by isrc order by count_name desc) as row_number

from facts.prod.dim_track
group by 1,2
)
select * from track_ranks where row_number = 1
    ;;
```