Please write a query based on the following requirements using Premier Database. The Mediafire link below is where the Premier Database can be found. For the question, you are required to submit 1) SQL query code and 2) a screen shot of your query results (if your results contains more than 15 records, you can submit a screen shot of the top 15 records).

http://www.mediafire.com/file/pbl5u3ah7aj4fc2/Premier%282%29.accdb

6. List the total number of items (sum of quantity of each item) sold to members living in Indiana, Illinois, and Kentucky. (List your results separately for each state.)