I need help doing this. Please! ASSIGNMENT DESCRIPTION: A company named Pretty P

Question

I need help doing this. Please!

ASSIGNMENT DESCRIPTION: A company named Pretty Prints is in the business of selling lithograph prints created by local artists When an artist creates a lithograph, s(he) creates several hundred prints from it. The company needs a database to manage orders. You are to create a database for this purpose and enter the existing data. The database should be named prints and is composed of the tables below You are asked to do the following Download the mySQL database management system along with the mySQL workbench. Also download connector/J. After the download you are to use SQL to create a database named prints which is composed of these tables. Submit either a screenshot of the SQL commands or a script file containing the SQL into Moodle2 for grading TABLES customers customer id customer name customer-add customer customer state customer zip customer phone 704/552.1810 336/316-5434 803/432.6225 404/243.7379 904/992-7234 919/809.2545 803/432-7600 919/355/0034 803/432-1987 904/725-4672 7041365.7655 704/372/9000 918/941-9121 1555 Seminole Ct. Charlotte 878 Madison Ave. reensboro 4200 Olive Ave 608 Old Post Rd. 235 Easton Ave. 2508 W. Shaw Rd. Raleigh Cora Blanca 27407 29206 30030 Yash Reed NC 1200 David Cox Tina Evans Will Allen Decatur 27542 SC Will Parsons 4990 S. Pine St. Raleigh 1200 Little St. 27545 1800Walter Kelly SC 32216 7822 N. Ridge Rd.Jacksonville 4090Caldweld St. Charlotte 3320 W. Main St Charlotte 1600 Sardis Rd Grace Hul NC 28205 Jane Brown 2200 Betty Draper Sarasota 32441 artist Under the Sun 46.80 200 Dark Lady Keith Morris 120.99 350 Top of the Mountain Streets from Old The Hunt Rainbow Row Janice Sharon Brune Walter Alford 123.00 390 46.00 700 Alexander Wilson 98.00 as and Moon 850 Greek Isles Benjamin C orders order id customer id order date 2013-10-23 2013-10-30 2013-11-09 2013-11-15 2013-11-15 2013-12-15 2013-12-18 2013-12-20 2014-01-18 2014-01-31 2014-02-01 2014-02-27 2014-03-10 2014-03-14 2013-10-28 2013-11-03 2013-11-14 2013-11-20 2013-11-20 2013-12-19 2013-12-22 2013-12-22 2014-01-23 2014-02-04 2014-02-06 2014-03-02 2014-03-15 2014-03-19 2100 orderline order_qty

Explanation / Answer

before write to this querry you shoolud create data base which is related to address datails.you can select any one option like addess,city,or state,zip.
1)select name, creditlimit
from CUSTOMERS
where name in
(select name
from CUSTOMERS
where City = 'sunnyvale'or where address=' ',or where state=' ', or where zip=' ');

or
SELECT VendName, VendZipCode
FROM Vendors
2)SYNTAX

SELECT column list
FROM tablename
WHERE criteria
ORDER BY column list
3)select zip code from table where laction='nc' or 'sc';

4)

SELECT "column_name"
FROM "table_name"
[WHERE "condition"]

ORDER BY "column_name" [ASC, DESC];SELECT * FROM Customers
ORDER BY artist, orderdata,shipdate ASC;
5)SELECT itemid, artist,title, unitprice
FROM table name
ORDER BY price ASC;
6)SELECT itemid, artist, title, unitprice
FROM table name
ORDER BY price >$100.00;
7)SELECT itemid, artist, title, unitprice
FROM table name
ORDER BY price where more tehm $300;
8)SELECT * FROM tabale name;
uitprice,retail pricr;
11)select customers form tabale,artist,tatile,order
13)SELECT Product_ID, Price*Units Revenue
FROM Product_Sales
ORDER BY Price*Units DESC;

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

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