About Maurice Tutor

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:

Algebra,Applied Sciences See all

Algebra,Applied Sciences,Biology,Calculus,Chemistry,Economics,English,Essay writing,Geography,Geology,Health & Medical,Physics,Science Hide all

Teaching Since:	May 2017
Last Sign in:	398 Weeks Ago, 4 Days Ago
Questions Answered:	66690
Tutorials Posted:	66688

Education

MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011

Experience

Professor
Phoniex University
Oct-2001 - Nov-2016

Category > Computer Science Posted 14 Jul 2017 My Price 12.00

MySQL Workbench

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.

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.

TABLES:

customers

customer_id	customer_name	customer-add	customer_city	customer_state	customer_zip	customer_phone
1000	Cora Blanca	1555 Seminole Ct.	Charlotte	NC	28210	704/552.1810
1100	Yash Reed	878 Madison Ave.	Greensboro	NC	27407	336/316-5434
1200	John Mills	4200 Olive Ave.	Columbia	SC	29206	803/432.6225
1300	David Cox	608 Old Post Rd.	Decatur	GA	30030	404/243.7379
1400	Tina Evans	235 Easton Ave.	Jacksonville	FL	32221	904/992-7234
1500	Will Allen	2508 W. Shaw Rd.	Raleigh	NC	27542	919/809.2545
1600	James Boyd	200 Pembury Ln.	Columbia	SC	29206	803/432-7600
1700	Will Parsons	4990 S. Pine St.	Raleigh	NC	27545	919/355/0034
1800	Walter Kelly	1200 Little St.	Columbia	SC	29206	803/432-1987
1900	Ann Damian	7822 N. Ridge Rd.	Jacksonville	FL	32216	904/725-4672
2000	Grace Hull	4090Caldweld St.	Charlotte	NC	28205	704/365.7655
2100	Jane Brown	3320 W. Main St.	Charlotte	NC	28210	704/372/9000
2200	Betty Draper	1600 Sardis Rd.	Sarasota	FL	32441	918/941-9121
item_id	title	artist	unit_price	on_hand
100	Under the Sun	Donald Arley	46.80	340
200	Dark Lady	Keith Morris	120.99	250
300	Happy Days	Andrea Reid	78.00	210
350	Top of the Mountain	Janice Jones	110.00	290
400	Streets from Old	Sharon Brune	123.00	320
450	The Hunt	Walter Alford	39.99	390
600	Rainbow Row	Judy Ford	46.00	350
700	Skies Above	Alexander Wilson	98.00	275
800	The Seas and Moon	Susan Beeler	67.81	235
850	Greek Isles	Benjamin Caudle	76.00	300

orders

order_id

customer_id

order_date

ship_date

1200

2013-10-23

2013-10-28

1500

2013-10-30

2013-11-03

1500

2013-11-09

2013-11-14

2100

2013-11-15

2013-11-20

1600

2013-11-15

2013-11-20

1900

2013-12-15

2013-12-19

2200

2013-12-18

2013-12-22

1600

2013-12-20

2013-12-22

1000

2014-01-18

2014-01-23

2200

2014-01-31

2014-02-04

1500

2014-02-01

2014-02-06

1400

2014-02-27

2014-03-02

1100

2014-03-10

2014-03-15

1400

2014-03-14

2014-03-19

Orderline

order_id	item_id	order_qty
1	800	2
1	600	1
2	700	3
2	300	2
3	850	1
4	200	4
4	100	1
4	850	1
5	450	1
6	800	2
7	300	2
7	600	2
8	100	1
9	100	3
10	450	6
10	600	8
10	200	4
11	700	2
12	300	3
12	700	4
13	200	2
13	600	10
13	450	4
14	700	8
14	200	6
14	800	4
14	450	2

Answers

Maurice Tutor

(5)

Status NEW Posted 14 Jul 2017 09:07 PM My Price 12.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- �-----------�Th-----------ank----------- Yo-----------u f-----------or -----------usi-----------ng -----------our----------- we-----------bsi-----------te -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill-----------

Not Rated(0)

Buy Answer

Relevent Questions

MySQL Workbench

Hire Dedicated Virtual Team / Business Solution for SMEs.

Maurice Tutor

(5)

About Maurice Tutor

Education

Experience

MySQL Workbench

Answers

Are You a Business Owner?