Question: Please Provide an answer in MYSQL workbench Write a SELECT statement that returns the average length of each track by album as shown in the
Please Provide an answer in MYSQL workbench
Write a SELECT statement that returns the average length of each track by album as shown in the Miliseconds column of the track table, return the AlbumId, the album Title, the ArtistId, and the Name of the artist.
track table:
| TrackId | int(11) AI PK |
| Name | varchar(200) |
| AlbumId | int(11) |
| MediaTypeId | int(11) |
| GenreId | int(11) |
| Composer | varchar(220) |
| Milliseconds | int(11) |
| Bytes | int(11) |
| UnitPrice | decimal(10,2) |
album table:
Columns:
| AlbumId | int(11) AI PK |
| Title | varchar(160) |
| ArtistId | int(11) |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
