Assignment $4$

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.

SimplifiedSales

SaleDate

FirstName

LastName

ProductName

Category

Color

ItemSize

ManufacturerName

Price

$1.$ What unique manufacturers have had product sold in june of $2015?$ Only show manufracture names

$2.$ What were the unique category, productname, color and item size of product manufractured by converse and sokd in $2014?$

$3.$ Give all data for sales of more than $$130$

$4.$ List all the informationfor each sale made to customer stephen liddle.

$5.$ What are the unique product name of boots size $12$ and above sold in $2014?($ category names are not capitalized$)$

$6.$ What were the sales of the product named hampton boots that have been sold? $($ product name ls are not capitalized in the database$)$ return only the sales prices

$7.$ Which product were sold on the second of junuary of $2014?$ Only show the unique product names.

$8.$ Give a list of unique customer's last and first names with the product names who have purchased bots priced $$10$ and under. $($ category names are not capitalized$)$

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

$10.$ What are the colors of sold products whose price is more than $$100?$ Show only unique colors