$3\mathrm{.}1$o Join Tables Queries $1$

These are queries that use the full Red Cat Database as shown in Figure $3\mathrm{.}1.$ To do these queries you cannot use the SimplifiedSales database. You must use the full Red Cat tables of Customer, Sale, SaleItem, Product, Manufacturer, and Employee tables.

For each information request below, formulate a single SQL query to produce the required information. In each case, you should display only the columns requested. Be sure that your queries do not produce duplicate records unless otherwise directed.

List the states of customers who have purchases in January of $2015.$ Only show states and sort them alphabetically. Eliminate duplicates.