Generate a single-row "catalog overview" for the platform's daily dashboard.
| Column | Type |
|---|---|
| TrackId | INTEGER (Primary Key) |
| Name | TEXT NOT NULL |
| AlbumId | INTEGER |
| GenreId | INTEGER |
| Composer | TEXT |
| Milliseconds | INTEGER NOT NULL |
| UnitPrice | NUMERIC(10,2) NOT NULL |
TotalTracks: total number of tracksDistinctGenres: how many distinct GenreId values appearDistinctAlbums: how many distinct AlbumId values appearTotalArtists: total count of rows in the Artist table (use a scalar subquery)AvgPrice: average UnitPrice across all tracks, rounded to 2 decimal placesReady to take your skills to the next level? Enroll in our comprehensive Data Analyst Career Track to master SQL, Python, Excel, and Power BI.
Run your code to see the result here.