MIS 180 SQL Chapter 2-4 Exam Questions With Complete Answers 100% Pass

MIS 180 SQL Chapter 2-4 Exam Questions With
Complete Answers 100% Pass



What manufacturers have had products sold in June of 2015? Only show manufacturer names.
- ANSWER Select Distinct ManufacturerName

From SimplifiedSales

Where month(SaleDate) = 6 and Year(SaleDate) = 2015




What were the category, productname, color and item size of products manufactured by
Converse and sold in 2014? - ANSWER Select Distinct Category, ProductName, Color, Itemsize

From simplifiedsales

Where ManufacturerName = 'Converse'

And Year(SaleDate) = 2014




Give all data for sales of more than $130 - ANSWER Select * From SimplifiedSales Where Price
> 130




List all the information for each sale made to customer Stephen Liddle. - ANSWER Select *

From SimplifiedSales

Where Firstname = 'Stephen'

And Lastname = 'Liddle'

,What are the product names of boots size 12 and above sold in 2014? (Category names are

not capitalized.) - ANSWER Select Distinct productname

From SimplifiedSales

Where Category = 'boots' And itemsize >= 12 And Year(SaleDate) = 2014




What were the sales prices of the product named hampton boots that have been sold?
(Product names are not capitalized in the database.) Return only the sales prices. - ANSWER
Select Price

From SimplifiedSales

Where ProductName = 'hampton boots'




Which products were sold on the second of January of 2014? Only show product names. -

ANSWER Select Distinct ProductName

From SimplifiedSales

Where SaleDate = '2014-1-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.) - ANSWER Select Distinct
lastname,

firstname,

productname

From SimplifiedSales

Where Category = 'boots'

,And Price <= 10




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. - ANSWER

Select Distinct Firstname,

Lastname

From SimplifiedSales

Where Price >= 120

And Price < 130




What are the colors of sold products whose price is more than $100? Show only colors. -
ANSWER Select Distinct Color

From SimplifiedSales

Where Price > 100




CHAPTER 2 QUERY SET #2 - ANSWER




Give an alphabetical list of manufacturers who have had products sold in June of 2015? Only

show manufacturer names. - ANSWER SELECT Distinct ManufacturerName

FROM simplifiedsales

WHERE month(SaleDate) = 6 and year(saledate) = 2015

ORDER BY ManufacturerName

, What are the names (first and last) of customers who have made purchases in June or
December of 2015? - ANSWER Select Distinct Firstname,

Lastname

From SimplifiedSales

Where (month(SaleDate) = 6

Or month(SaleDate) = 12)

And Year(SaleDate) = 2015




Show all of the prices at which products manufactured by Keds have been sold. Sort it in
descending order by price. (Manufacturer names are capitalized in the database.) Only show
product names and prices. - ANSWER Select Distinct Productname,

Price

From SimplifiedSales

Where ManufacturerName = 'Keds'

Order by Price DESC




What are the prices of blue sandals and green sandals that have been sold? Show the various
prices by color sorted with blue sandals first and then by descending price. (Colors are
capitalized in the database.) Show only colors and prices. - ANSWER Select Distinct Color,

Price

From SimplifiedSales