Please use the provided tables.
customer zip 28210 TABLES: customers customer id customer name customer-add 1000 Cora Blanca 1555 Seminole Ct 1100 Yash Reed 878 Madison Ave. 1200 John Mills 4200 Olive Ave. 1300 David Cox 608 Old Post Rd. 1400 Tina Evans 235 Easton Ave. 1500 Will Allen 2508 W. Shaw Rd. 1600 James Boyd 200 Pembury Ln. 1700 Will Parsons 4990 S. Pine St. 1800 Walter Kelly 1200 Little St. 1900 Ann Damian 7822 N. Ridge Rd. 2000 Grace Hull 4090Caldweld St. 2100 Jane Brown 3320 W. Main St. 2200 Betty Draper 1600 Sardis Rd. customer state NC NC SC GA FL NC 27407 29206 30030 customer city Charlotte Greensboro Columbia Decatur Jacksonville Raleigh Columbia Raleigh Columbia Jacksonville Charlotte Charlotte Sarasota 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 704/365.7655 704/372/9000 918/941-9121 SC 32221 27542 29206 27545 29206 32216 28205 NC SC FL NC NC 28210 32441 FL unit price 46.80 items item_id 100 200 300 350 400 Title Under the Sun Dark Lady Happy Days Top of the Mountain Streets from Old The Hunt Rainbow Row Skies Above The Seas and Moon Greek Isles artist Donald Arley Keith Morris Andrea Reid Janice Jones Sharon Brune Walter Alford Judy Ford Alexander Wilson Susan Beeler Benjamin Caudle on hand 340 250 210 290 320 450 120.99 78.00 110.00 123.00 39.99 46.00 98.00 67.81 76.00 600 700 800 850 390 350 275 235 300 orders order_id 1 2 customer id 1200 1500 1500 2100 1600 3 4 5 6 1900 7 2200 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 ship_date 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 1600 8 9 1000 10 11 2200 1500 1400 1100 12 13 14 1400 orderline order_id 1 1 2 2 3 4 4 4 5 6 7 7 8 9 10 10 10 11 12 12 13 13 13 14 item id 800 600 700 300 850 200 100 850 450 800 300 600 100 100 450 600 200 700 300 700 200 600 450 700 200 800 450 order qty 2 1 3 2 1 4 1 1 1 2 2 2 1 3 6 8 4 GN 2 10 4 8 6 14 14 NA PRETTY PRINTS II ? ASSIGNMENT DESCRIPTION: SQL statements should be created to execute a set of queries that the Pretty Prints Company executes each month to better manage their business. Use the database created for Pretty Prints that was created in Pretty Prints I. The SQL statements can be created within the MySQL Workbench. Give the SQL commands necessary to perform the following queries: 1. List all customer along with their address, city, state and zip 2. List all customers and their phone numbers that live in GA 3. List all customers along with their zip codes that live in NC or SC 4. List all titles that have been sold along with the artist, order date and ship date 5. List all item id, title, artist, unit price, and on hand in ascending order by price 6. List all item id, title, artist, unit price, and on hand for all items with a unit price that is more than $100.00 7. List all item id, title, artist, unit price, and on hand for all items where there are more than 300 on hand 8. List all titles along with their unit price and retail price (retail price is unit price doubled) 9. List all customers that have placed an order in 2014 along with their phone numbers 10. List all artists with the number of their prints that have been sold 11. List all titles that have a unit price between $40.00 and $100.00. 12. List all customers, title, artist, quantity ordered 13. List all customers along with the total revenue received from that customer (revenue would be total retail Enter Full Screen 14. List each state and the number of customers from that state REQUIREMENTS: Each student must work independently on this assignment. No group work is allowed. Submit a document containing the SQL statements for the above queries. Submit completed work into Canvas. Take a screenshot of the submission verification in the event you need proof of submission
