Give the release date, standard price, and the conductor for all albums of Tchaikovsky’s Swan Lake released since 1 January 2000. Which song on Leonard Cohen’s album The Future has the highest number...

Give the release date, standard price, and the conductor for all albums of Tchaikovsky’s Swan Lake released since 1 January 2000.


Which song on Leonard Cohen’s album The Future has the highest number of downloads? Give album title, release date, song title, and the number of downloads.

Give the title, release date and standard price of Bob Dylan’s albums that were released in both CD and vinyl formats.

Which album by Joe Cocker has the highest average review score? Give album title, release date and the average review score. Use the AvgReviewScore() method for this query.


Give the title and release date for albums where the word “magnificent” appears in any of the reviews.

Give the longest track on Miles Davis’s album Bitches Brew. List the song title, duration and price.