# View: count_earning_tracks_by_release

**View Name:** count_earning_tracks_by_release
**Table Source:** `Derived from: Prod.Dim_Release, Prod.Dim_Track`
**File Path:** `count_earning_tracks_by_release.view.lkml`

## Overview

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

## Dimensions

| Name | Type |
|------|------|
| `release_id` | number |
| `track_count` | number |

## Derived Table

```sql
sql:
      SELECT dr.releaseid, COUNT(DISTINCT dt.trackid) AS track_count
      FROM facts.prod.dim_track dt
        INNER JOIN facts.prod.dim_release dr ON dt.upc = dr.releaseid
      GROUP BY 1  ;;
```