7. You are querying a database that contains data about music. Each musical genre is given an ID number. You are only interested in data related to the genre with ID number 7. The genre IDs are listed in the genre_id column.
You write the SQL query below. Add a WHERE clause that will return only data about the genre with Id number 7.
Who is the composer listed in row 4 of your query result?
8. You are working with a database that contains invoice data about online music purchases. You are only interested in invoices sent to customers located in the city of Delhi. You want to sort the invoices by order total in ascending order. The order totals are listed in the total column.
You write the SQL query below. Add an ORDER BY clause that will sort the invoices by order total in ascending order.
What total appears in row 4 of your query result?
9. Fill in the blank: The _____ phase of the data analysis process includes organizing data, formatting and adjusting data, getting input from others, and transforming data by observing relationships between data points and making calculations.