6) SQL (12 points) Note: All SQL questions assume the use of standard SOL Assume that you have created a database to keep track of your old CD music collection. The structure of the database is as follows: ARTISTS (artistlD, artist name, nationality, current salary, prior salary, grammy CD (cdID, od serial number, artistlD, Title, music type, year released, length in minutes purchase price, personal rating) Now you want to find specific information about your collection. For each of the following questions, write an SQL statement that can answer the question. Only retrieve columns that are directly relevant to each question a) What are the titles and music types of all CDs in your collection? b) What are the titles of CDs that are of the "Rock music type and cost you more than $15? c) Which artists have had a decrease in salary? d) What is the total amount that you spent on each music type? Sort these by the music type oheapest first