Unformatted text preview: FROM (tbl_Albums INNER JOIN tbl_Tracks ON tbl_Albums.AlbumID = tbl_Tracks.AlbumID) INNER JOIN qry_day23_ShortestTracks_1 ON tbl_Albums.AlbumID = qry_day23_ShortestTracks_1.AlbumID WHERE (((tbl_Tracks.TrackDuration)=[qry_day23_ShortestTracks_1].[Shortest])); List the digital tracks (names) that have filesizes larger than the average filesize in your music database Query 1. Find average filesize of all digital tracks----SELECT Avg(tbl_DigitalTracks.DigitalFilesize) AS AvgOfDigitalFilesize FROM tbl_DigitalTracks; Query 2. Find which digital tracks have filesizes larger than that average (sort largest down)----SELECT tbl_DigitalTracks.DigitalFilename, tbl_DigitalTracks.DigitalFilesize FROM tbl_DigitalTracks, qry_day23_AboveAvFilesize_1 WHERE (((tbl_DigitalTracks.DigitalFilesize)>[qry_day23_AboveAvFilesize_1].[AvgOfDigitalFilesize])) ORDER BY tbl_DigitalTracks.DigitalFilesize DESC;...
View Full Document
- Fall '08