• Create SpotifyClone database

• Create QUERY to exhibit 3 columns (cancoes, artistas and albuns):

1. cancoes must exhibit total amount of songs
2. artistas must exhibit total amount of artists
3. albuns must exhibit total amount of albums

• Create QUERY to exhibit 3 columns (usuario, qtde_musicas_ouvidas and total_minutos):

1. usuario alias must display user name
2. qtde_musicas_ouvidas must display total amount of songs listened by user based on reproduction history
3. total_minutos must display total minutes listened by user based on reproduction history

• Create QUERY to display active users in 2021, based on most recent date in reproduction history:

1. usuario alias must display user name
2. condicao_usuario must display whether user is active or not

• Create QUERY to check top 2 played songs in the moment:

1. cancao alias must display song name
2. reproducoes alias must display how many users played the song

• Create QUERY to check company billing:

1. faturamento_minimo alias must display the lowest existing plan value for a user.
2. faturamento_maximo alias must display the highest existing plan value for a user.
3. faturamento_medio alias must display the average value of plans owned by users so far.
4. faturamento_total alias must display the total value earned from plans owned by users.

• Create QUERY to relate albums to followers:

1. artista alias must display artist name.
2. album alias must display album name.
3. seguidores alias must display the quantity of followers for each given artist.

• Create QUERY to relate albums to artists:

1. artista alias must display artist name.
2. album alias must display album name.

• Create QUERY to display quantity of songs in an user reproduction history:

1. quantidade_musicas_no_historico alias must display quantity of songs.

• Create QUERY to exhibit name and times a song was played by an user using free or personal plans:

1. nome alias must display song name.
2. reproducoes alias must display how many users listened to given song.

• Create QUERY to change and sort song names:

1. nome_musica alias must display original song name.
2. novo_nome alias must display altered song name.

In the last word of a song name:

• Change Streets by Code Review
• Change Her Own by Trybe
• Change Inner Fire by Project
• Change Silly by Nice
• Change Circus by Pull Request

⚠️ Before you start, you must check if your docker-compose version is 1.29 or higher

• Run node and db by running:

$ docker-compose up -d

• Open interactive terminal using:

$ docker exec -it one_for_all bash

• Install dependencies, inside the container, with:

$ npm install

• Open terminal and create a directory in your preferred location:

$ mkdir <Your directory name here>

• Access directory then clone the repository:

$ cd <Your directory name here>
$ git clone [email protected]:ViniGB/Project-One-for-all.git

• Access the newly created directory:

$ cd Project-One-for-all

• Install dependencies:

$ npm install