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.

A description of the database schema used for this assignment is shown below.

CHART:

SimplifiedSales

SaleDate

FirstName

LastName

ProductName

Category

Color

ItemSize

ManufacturerName

Price

1. What manufacturers have had products sold in June of 2015? Only show manufacturer names.

2.Give a list of customer's last and first names with the product names who have purchased boots priced $10 and under. (Category names are not capitalized.)

3.Give first and last names of customers who have made purchases costing $120 or more but less than $130. Only show customer names. Do not use BETWEEN for this query.