Решить задачи по Oracle sql:
1) Find the number of unique tracks with genre 'Rock' added to playlists;
2) Find customers who bought more than 5 Rock tracks
3) Find the album and its artist where the average length of tracks in the album is more than 6  minutes;
4) Find the genre with the biggest average length of tracks
Скрипт на создание БД находится в файле create_oracle.txt

Решить задачи по Oracle sql:
1) Find the number of unique tracks with genre 'Rock' added to playlists;
2) Find customers who bought more than 5 Rock tracks
3) Find the album and its artist where the average length of tracks in the album is more than 6 minutes;
4) Find the genre with the biggest average length of tracks
Скрипт на создание БД находится в файле create_oracle.txt

Гость guest_16183873296601

Решить sql задачи