Using the Chinook database as a sample, we want to investigate and find an answer to the following question: Do tracks that are titled using positive words sell better on average than tracks that are titled with negative words. We would like to only focus on the following words in the investigations.

List of negative words: $[\text{'}$Evil$\text{'},$ 'Night', 'Problem', 'Sorrow', 'Dead', 'Curse', 'Venom', 'Pain', 'Lonely', 'Beast'$]$

List of positive words: $[\text{'}$Amazing$\text{'},$ 'Angel', 'Perfect', 'Sunshine', 'Home', 'Live', 'Friends'$]$

a$)$ Connect to the chinook database using Sqlite$3$ and execute the following query.

SELECT $*$ FROM tracks join invoice$\_$items on tracks.TrackId $=$ invoice$\_$items.TrackId

b$)$ Use the skills you learned from previous chapters $($applying a function, group by function, etc.$)$ to come up with a table that lists the average of the total sale for tracks with good words and track with bad words.

Here is how the table will look like