IS3063 MyEducator problems. PLEASE WRITE THIS IN SQL QUERY 5. List in alphabetic

Question

IS3063 MyEducator problems. PLEASE WRITE THIS IN SQL QUERY

5. List in alphabetical order the states of customers who have purchases in January of 2015. Use first letter of table names for aliases. Only show states.

6. What are the names of manufacturers of heels costing $50 or more? (Use aliases.) Only show manufacturer names

7. What are the categories of shoes from Puma and in what colors? Sort them by color. Only show category and color.

8. What categories of shoes were sold in January 2014? Only show categories.

9. What are the first and last names of customers living in California who made purchases in January 2015, and what was the quantity for each of their purchases? (States appear in the database as standard abbreviations, e.g. Alaska appears as “AK”). Show customer first name, last name, and quantity.

10. Who are all the customers in Washington who made purchases in 2015? Only show first and last names.

2.3s Join Queries on Tables 1 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 in show below The interface below may not remember queries you have written if you have to leave the page for any reason before you submit, so be sure to keep a copy of your queries in case you need to enter them again. Customer CustomerID FirstName LastName StreetAddress Sale SalelD SaleDate CustomerlD ProductID ItemSize Quantity SalePrice Product ProductID ProductName ManufacturerlD Category Color Price Description Manufacturer ManufacturerlD ManufacturerName Address State PostalCode Phone State PostalCode Country Phone

Explanation / Answer

5.
SELECT C.State
FROM Customer C, Sale S
WHERE
C.CustomerID = S.CustomerID
AND
to_char(S.SaleDate,'yyyy') = 2015
AND
to_char(S.SaleDate,'mm') = 01
ORDER BY C.Sate;

6.
SELECT M.ManufacturerName
FROM Manufacturer M, Product P
WHERE
M.ManufacturerID = P.ManufacturerID
AND
P.ProductName = 'heels'
AND
P.Price > 49;

7.
SELECT P.Category, P.Color
FROM Product P, Manufacturer M
WHERE
P.ManufacturerID = M.ManufacturerID
AND
M.ManufacturerName = 'Puma';

8.
SELECT P.Category
FROM Product P, Sale S
WHERE
P.ProductID = S.ProductID
AND
to_char(S.SaleDate,'yyyy') = 2014
AND
to_char(S.SaleDate,'mm') = 01;

9.
SELECT C.FirstName,C.LastName, S.Quantity
FROM Customer C, Sale S
WHERE
C.CustomerID = S.CustomerID
AND
C.State = 'CA'
AND
to_char(S.SaleDate,'yyyy') = 2015
AND
to_char(S.SaleDate,'mm') = 01;

10.
SELECT C.FirstName, C.LastName
FROM Customer C, Sale S
WHERE
C.CustomerID = S.CustomerID
AND
C.State = 'WA'
AND
to_char(S.SaleDate,'yyyy') = 2015;

THANKS AND CHEERS
If you like the answer please feel free to giva a thumbs up,
Having a problem?? Feel free to leave a comment.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.