Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The music database consists of 9 tables (where keys are underlined): album_country (country, album_id), album_genre (album_id, genre_id), album_track (album_id, position, song_id), albums (album_id, title, released),

The music database consists of 9 tables (where keys are underlined):

album_country (country, album_id), album_genre (album_id, genre_id), album_track (album_id, position, song_id), albums (album_id, title, released), artist_album (artist_id, album_id), artists (id, name), countries (code, name, continent), genres(genre_id, genre), songs (song_id, title, duration), album_country.country references countries.code, album_country.album_id references albums.album_id, album_genre.album_id references albums.album_id, album_genre.genre_id references genres.genre_id, album_track.album_id references albums.album_id, album_track.song_id references songs.song_id, artist_album.artist_id references artists.artist_id, artist_album.album_id references albums.album_id

In SQL write these queries:

1. Find the highest number of albums released by any artist.

2. Find the songs that have duration greater than 59:59 (i.e., 59 minutes and 59 seconds). Note: for most songs, duration is specified as hours:minutes:seconds. However, there are some exceptions where duration is given as a number of minutes greater than 59. Your solution should consider both cases.

3. Find the number of albums that are collaborations between two or more artists.

4. Find the number of albums that have titles with more than three words.

5. Find the number of artists that have one-word names longer than 5 characters and shorter than 10 characters?

6. Assuming you are born in year x (e.g., 1988) find the albums released in year (x- 1), year (x) and year (x+1). Return the album title, released, and the string before, same or after for years (x-1), (x), (x+1), respectively. Sample output: Title-a | 1988 | same; Title-b | 1987 | before; Title-c |1989 | after;

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Database Experts Guide To Database 2

Authors: Bruce L. Larson

1st Edition

0070232679, 978-0070232679

More Books

Students also viewed these Databases questions

Question

7. It is advisable to do favors for people whenever possible.

Answered: 1 week ago