source:
music/views/tracks_count_per_genre.sql
| Last change on this file was d7662b5, checked in by , 3 weeks ago | |
|---|---|
|
|
| File size: 167 bytes | |
| Rev | Line | |
|---|---|---|
| [d7662b5] | 1 | CREATE VIEW track_count_per_genre AS |
| 2 | SELECT g.name as Genre, count(t.track_id) as num_tracks | |
| 3 | FROM genre g | |
| 4 | LEFT JOIN track t on g.genre_id = t.genre_id | |
| 5 | GROUP BY g.name |
Note:
See TracBrowser
for help on using the repository browser.
