The script file can be created within the MySQL Workbench. Any SQL commands used

ID: 641133 • Letter: T

Question

The script file can be created within the MySQL Workbench. Any SQL commands used to prepare the database for queries must be included in the script.

Pictures of the tables used are at the buttom

The following queries should be included in the script:

List all customer along with their address, city, state and zip

List all customers and their phone numbers that live in GA

List all customers along with their zip codes that live in NC or SC

List all titles that have been sold along with the artist, order date and ship date

List all item id, title, artist, unit price, and on hand in ascending order by price

List all item id, title, artist, unit price, and on hand for all items with a unit price that is more than $100.00

List all item id, title, artist, unit price, and on hand for all items where there are more than 300 on hand

List all titles along with their unit price and retail price (retail price is unit price doubled)

List all customers that have placed an order in 2014 along with their phone numbers

List all artists with the number of their prints that have been sold

List all titles that have a unit price between $40.00 and $100.00.

List all customers, title, artist, quantity ordered

List all customers along with the total revenue received from that customer (revenue would be total retail price)

List each state and the number of customers from that state

Select customer_name , Customer-add, customer_city,customer_state,customer_zip from customers

--------------------------------------------------------------------2--------------------------------------------------------------------

Select customer_name,customer_phone from customers where customer_state=