My Sql Queries Using Album Paper

— 1. Display the album title and artist name for all albums in the album table

— 2. Repeat question 1 but sort the list by artist name

— 3. Display the track name and album name for all tracks with genreId = 8

— 4. Return the same result as question 3, but this time use implicit syntax

— 5. Return the same result as question 3, but this time use the USING keyword

— 6. List the artist name and Album titles for all albums where the artist name starts with ‘Santana’. Sort by album title.

— 7. Display the track name and album title for all tracks with MediaTypeId = 5 using table aliases. Sort by album name.

— 8. Display the album title, track name, and composer for all tracks where the artistid = 90 and genre = 1, sorted by album title and then track name.

"Order a similar paper and get 100% plagiarism free, professional written paper now!"

Order Now