# View: count_earning_releases_by_artist

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

## Overview

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

## Dimensions

| Name | Type |
|------|------|
| `artist_id` | number |
| `release_count` | number |

## Derived Table

```sql
sql:
      SELECT da.artistid, COUNT(DISTINCT dr.releaseid) AS release_count
      FROM facts.prod.dim_release dr
        INNER JOIN facts.prod.dim_artist da ON dr.artistid = da.artistid
      GROUP BY 1  ;;
```