|
Last change
on this file was 0e077ef, checked in by ManuelTrajcev <manueltrajcev7@…>, 3 weeks ago |
|
2 views wtih controllers and templates added
|
-
Property mode
set to
100644
|
|
File size:
299 bytes
|
| Line | |
|---|
| 1 | CREATE VIEW avg_track_duration_per_artist AS
|
|---|
| 2 | SELECT ar.name as artist_name, concat(ceil(avg(milliseconds) / 1000), 's') as avg_track_duration_in_seconds
|
|---|
| 3 | FROM artist ar
|
|---|
| 4 | left join album al on ar.artist_id = al.album_id
|
|---|
| 5 | left join track tr on al.album_id = tr.album_id
|
|---|
| 6 | group by ar.name
|
|---|
| 7 | order by ar.name |
|---|
Note:
See
TracBrowser
for help on using the repository browser.
