IndEx1_STU_NUM.sql

/*
Write SQL queries that can be executed on the chinook.sqlite database to provide answers the following questions.
Save your SQL to this .sql file. Do not include the query results.
In PyCharm you can right click on the file name in the Project pane and select Refactor > Rename, and replace STU_NUM with your student number.
*/

--1. Which employees have 'IT' in their job title? (list their EmployeeId, FirstName, LastName and Title)

--2. List the names of all Artists and the titles of their albums

--3. Which track(s) features the greatest number of times in playlists and how many times is it/are they included? (list Track name and the total number of appearances in playlists).

--4. Provide a list of the number of tracks by each artist

--5. How much money has been invoiced for the artist Deep Purple? (For this you can create two queries, one that shows the line item from the invoices and the total amount per line, and another that sums the totals from each line)