Manish_SQL_11_dec
|
customer_id |
cust_name |
cnt1 |
1 |
3002 |
Nick Rimando |
3 |
2 |
3005 |
Graham Zusi |
2 |
3 |
3001 |
Brad Guzan |
1 |
4 |
3004 |
Fabian Johns |
1 |
5 |
3007 |
Brad Davis |
1 |
6 |
3050 |
BradGuzanNEW |
0 |
7 |
3009 |
Geoff Camero |
2 |
8 |
3008 |
Julian Green |
1 |
9 |
3003 |
Jozy Altidor |
1 |
|
customer_id |
cust_name |
num_ord |
1 |
3002 |
Nick Rimando |
3 |
2 |
3005 |
Graham Zusi |
2 |
3 |
3001 |
Brad Guzan |
1 |
4 |
3004 |
Fabian Johns |
1 |
5 |
3007 |
Brad Davis |
1 |
6 |
3050 |
BradGuzanNEW |
0 |
7 |
3009 |
Geoff Camero |
2 |
8 |
3008 |
Julian Green |
1 |
9 |
3003 |
Jozy Altidor |
1 |
|
cust_name |
customer_id |
(No column name) |
1 |
Brad Guzan |
3001 |
1 |
2 |
Nick Rimando |
3002 |
3 |
3 |
Jozy Altidor |
3003 |
1 |
4 |
Fabian Johns |
3004 |
1 |
5 |
Graham Zusi |
3005 |
2 |
6 |
Brad Davis |
3007 |
1 |
7 |
Julian Green |
3008 |
1 |
8 |
Geoff Camero |
3009 |
2 |
9 |
BradGuzanNEW |
3050 |
0 |
|
cust_name |
city |
ord_no |
ord_date |
purch_amt |
name |
commission |
1 |
Nick Rimando |
New York |
70002 |
05.10.2012 00:00:00 |
65,26 |
James Hoog |
0,15 |
2 |
Nick Rimando |
New York |
70008 |
10.09.2012 00:00:00 |
5760,00 |
James Hoog |
0,15 |
3 |
Nick Rimando |
New York |
70013 |
25.04.2012 00:00:00 |
3045,60 |
James Hoog |
0,15 |
4 |
Graham Zusi |
California |
70001 |
05.10.2012 00:00:00 |
150,50 |
Nail Knite |
0,13 |
5 |
Graham Zusi |
California |
70007 |
10.09.2012 00:00:00 |
948,50 |
Nail Knite |
0,13 |
6 |
Brad Guzan |
London |
70009 |
10.09.2012 00:00:00 |
270,65 |
Pit Alex |
0,11 |
7 |
Fabian Johns |
Paris |
70010 |
10.10.2012 00:00:00 |
1983,43 |
Mc Lyon |
0,14 |
8 |
Brad Davis |
New York |
70005 |
27.07.2012 00:00:00 |
2400,60 |
James Hoog |
0,15 |
9 |
BradGuzanNEW |
London |
NULL |
NULL |
NULL |
Pit Alex |
0,11 |
10 |
Geoff Camero |
Berlin |
70004 |
17.08.2012 00:00:00 |
110,50 |
Lauson Hen |
0,12 |
11 |
Geoff Camero |
Berlin |
70003 |
10.10.2012 00:00:00 |
2480,40 |
Lauson Hen |
0,12 |
12 |
Julian Green |
London |
70012 |
27.06.2012 00:00:00 |
250,45 |
Nail Knite |
0,13 |
13 |
Jozy Altidor |
Moscow |
70011 |
17.08.2012 00:00:00 |
75,29 |
Paul Adam |
0,13 |
|
salesman_id |
name |
city |
commission |
1 |
5001 |
James Hoog |
New York |
0,15 |
2 |
5002 |
Nail Knite |
Paris |
0,13 |
3 |
5005 |
Pit Alex |
london |
0,11 |
4 |
5003 |
Lauson Hen |
|
0,12 |
5 |
5006 |
Mc Lyon |
Paris |
0,14 |
6 |
5007 |
Paul Adam |
Romes |
0,13 |
7 |
9007 |
Paul Adam |
Romes |
0,13 |
|
customer_id |
cust_name |
city |
grade |
salesman_id |
1 |
3002 |
Nick Rimando |
New York |
100 |
5001 |
2 |
3005 |
Graham Zusi |
California |
200 |
5002 |
3 |
3001 |
Brad Guzan |
London |
0 |
5005 |
4 |
3004 |
Fabian Johns |
Paris |
300 |
5006 |
5 |
3007 |
Brad Davis |
New York |
200 |
5001 |
6 |
3050 |
BradGuzanNEW |
London |
350 |
5005 |
7 |
3009 |
Geoff Camero |
Berlin |
100 |
5003 |
8 |
3008 |
Julian Green |
London |
300 |
5002 |
9 |
3003 |
Jozy Altidor |
Moscow |
200 |
5007 |
10 |
3060 |
TestGuzanNEW |
London |
350 |
|
|
ord_no |
purch_amt |
ord_date |
customer_id |
salesman_id |
1 |
70001 |
150,50 |
05.10.2012 00:00:00 |
3005 |
5002 |
2 |
70009 |
270,65 |
10.09.2012 00:00:00 |
3001 |
5005 |
3 |
70002 |
65,26 |
05.10.2012 00:00:00 |
3002 |
5001 |
4 |
70007 |
948,50 |
10.09.2012 00:00:00 |
3005 |
5002 |
5 |
70004 |
110,50 |
17.08.2012 00:00:00 |
3009 |
5003 |
6 |
70005 |
2400,60 |
27.07.2012 00:00:00 |
3007 |
5001 |
7 |
70008 |
5760,00 |
10.09.2012 00:00:00 |
3002 |
5001 |
8 |
70010 |
1983,43 |
10.10.2012 00:00:00 |
3004 |
5006 |
9 |
70003 |
2480,40 |
10.10.2012 00:00:00 |
3009 |
5003 |
10 |
70012 |
250,45 |
27.06.2012 00:00:00 |
3008 |
5002 |
11 |
70011 |
75,29 |
17.08.2012 00:00:00 |
3003 |
5007 |
12 |
70013 |
3045,60 |
25.04.2012 00:00:00 |
3002 |
5001 |
|
salesman_id |
name |
city |
commission |
customer_id |
cust_name |
salesman_id |
ord_no |
1 |
5001 |
James Hoog |
New York |
0,15 |
3002 |
Nick Rimando |
5001 |
70002 |
2 |
5001 |
James Hoog |
New York |
0,15 |
3002 |
Nick Rimando |
5001 |
70008 |
3 |
5001 |
James Hoog |
New York |
0,15 |
3002 |
Nick Rimando |
5001 |
70013 |
4 |
5001 |
James Hoog |
New York |
0,15 |
3007 |
Brad Davis |
5001 |
70005 |
5 |
5002 |
Nail Knite |
Paris |
0,13 |
3005 |
Graham Zusi |
5002 |
70001 |
6 |
5002 |
Nail Knite |
Paris |
0,13 |
3005 |
Graham Zusi |
5002 |
70007 |
7 |
5002 |
Nail Knite |
Paris |
0,13 |
3008 |
Julian Green |
5002 |
70012 |
8 |
5005 |
Pit Alex |
london |
0,11 |
3001 |
Brad Guzan |
5005 |
70009 |
9 |
5005 |
Pit Alex |
london |
0,11 |
3050 |
BradGuzanNEW |
5005 |
NULL |
10 |
5003 |
Lauson Hen |
|
0,12 |
3009 |
Geoff Camero |
5003 |
70004 |
11 |
5003 |
Lauson Hen |
|
0,12 |
3009 |
Geoff Camero |
5003 |
70003 |
12 |
5006 |
Mc Lyon |
Paris |
0,14 |
3004 |
Fabian Johns |
5006 |
70010 |
13 |
5007 |
Paul Adam |
Romes |
0,13 |
3003 |
Jozy Altidor |
5007 |
70011 |
14 |
9007 |
Paul Adam |
Romes |
0,13 |
NULL |
NULL |
NULL |
NULL |
|
salesman_Id |
name |
city |
Customer Id |
Cust Name |
(No column name) |
Order No |
Purchase Amt |
1 |
5001 |
James Hoog |
New York |
3002 |
Nick Rimando |
NULL |
70002 |
65,26 |
2 |
5001 |
James Hoog |
New York |
3002 |
Nick Rimando |
NULL |
70008 |
5760,00 |
3 |
5001 |
James Hoog |
New York |
3002 |
Nick Rimando |
NULL |
70013 |
3045,60 |
4 |
5001 |
James Hoog |
New York |
3007 |
Brad Davis |
NULL |
70005 |
2400,60 |
5 |
5002 |
Nail Knite |
Paris |
3005 |
Graham Zusi |
NULL |
70001 |
150,50 |
6 |
5002 |
Nail Knite |
Paris |
3005 |
Graham Zusi |
NULL |
70007 |
948,50 |
7 |
5002 |
Nail Knite |
Paris |
3008 |
Julian Green |
NULL |
70012 |
250,45 |
8 |
5005 |
Pit Alex |
london |
3001 |
Brad Guzan |
NULL |
70009 |
270,65 |
9 |
5005 |
Pit Alex |
london |
3050 |
BradGuzanNEW |
NoOrder |
0 |
0,00 |
10 |
5003 |
Lauson Hen |
|
3009 |
Geoff Camero |
NULL |
70004 |
110,50 |
11 |
5003 |
Lauson Hen |
|
3009 |
Geoff Camero |
NULL |
70003 |
2480,40 |
12 |
5006 |
Mc Lyon |
Paris |
3004 |
Fabian Johns |
NULL |
70010 |
1983,43 |
13 |
5007 |
Paul Adam |
Romes |
3003 |
Jozy Altidor |
NULL |
70011 |
75,29 |
14 |
9007 |
Paul Adam |
Romes |
|
NoOrdByLinkd |
NoOrder |
0 |
0,00 |
|
salesman_Id |
name |
city |
Customer Id |
Cust Name |
(No column name) |
Order No |
Purchase Amt |
1 |
5001 |
James Hoog |
New York |
3002 |
Nick Rimando |
NULL |
70008 |
5760,00 |
2 |
5001 |
James Hoog |
New York |
3002 |
Nick Rimando |
NULL |
70013 |
3045,60 |
3 |
5001 |
James Hoog |
New York |
3007 |
Brad Davis |
NULL |
70005 |
2400,60 |
4 |
5002 |
Nail Knite |
Paris |
|
NoOrdByLinkd |
NoOrder |
0 |
0,00 |
5 |
5005 |
Pit Alex |
london |
|
NoOrdByLinkd |
NoOrder |
0 |
0,00 |
6 |
5003 |
Lauson Hen |
|
3009 |
Geoff Camero |
NULL |
70003 |
2480,40 |
7 |
5006 |
Mc Lyon |
Paris |
|
NoOrdByLinkd |
NoOrder |
0 |
0,00 |
8 |
5007 |
Paul Adam |
Romes |
|
NoOrdByLinkd |
NoOrder |
0 |
0,00 |
9 |
9007 |
Paul Adam |
Romes |
|
NoOrdByLinkd |
NoOrder |
0 |
0,00 |
|
customer_id |
cust_name |
city |
grade |
salesman_id |
1 |
3002 |
Nick Rimando |
New York |
100 |
5001 |
2 |
3005 |
Graham Zusi |
California |
200 |
5002 |
3 |
3001 |
Brad Guzan |
London |
0 |
5005 |
4 |
3004 |
Fabian Johns |
Paris |
300 |
5006 |
5 |
3007 |
Brad Davis |
New York |
200 |
5001 |
6 |
3050 |
BradGuzanNEW |
London |
350 |
5005 |
7 |
3009 |
Geoff Camero |
Berlin |
100 |
5003 |
8 |
3008 |
Julian Green |
London |
300 |
5002 |
9 |
3003 |
Jozy Altidor |
Moscow |
200 |
5007 |
10 |
3060 |
TestGuzanNEW |
London |
350 |
|
|
ord_no |
purch_amt |
ord_date |
customer_id |
salesman_id |
1 |
70001 |
150,50 |
05.10.2012 00:00:00 |
3005 |
5002 |
2 |
70009 |
270,65 |
10.09.2012 00:00:00 |
3001 |
5005 |
3 |
70002 |
65,26 |
05.10.2012 00:00:00 |
3002 |
5001 |
4 |
70007 |
948,50 |
10.09.2012 00:00:00 |
3005 |
5002 |
5 |
70004 |
110,50 |
17.08.2012 00:00:00 |
3009 |
5003 |
6 |
70005 |
2400,60 |
27.07.2012 00:00:00 |
3007 |
5001 |
7 |
70008 |
5760,00 |
10.09.2012 00:00:00 |
3002 |
5001 |
8 |
70010 |
1983,43 |
10.10.2012 00:00:00 |
3004 |
5006 |
9 |
70003 |
2480,40 |
10.10.2012 00:00:00 |
3009 |
5003 |
10 |
70012 |
250,45 |
27.06.2012 00:00:00 |
3008 |
5002 |
11 |
70011 |
75,29 |
17.08.2012 00:00:00 |
3003 |
5007 |
12 |
70013 |
3045,60 |
25.04.2012 00:00:00 |
3002 |
5001 |
|
ord_no |
purch_amt |
ord_date |
customer_id |
salesman_id |
1 |
70001 |
150,50 |
05.10.2012 00:00:00 |
3005 |
5002 |
2 |
70009 |
270,65 |
10.09.2012 00:00:00 |
3001 |
5005 |
3 |
70002 |
65,26 |
05.10.2012 00:00:00 |
3002 |
5001 |
4 |
70007 |
948,50 |
10.09.2012 00:00:00 |
3005 |
5002 |
5 |
70004 |
110,50 |
17.08.2012 00:00:00 |
3009 |
5003 |
6 |
70005 |
2400,60 |
27.07.2012 00:00:00 |
3007 |
5001 |
7 |
70008 |
5760,00 |
10.09.2012 00:00:00 |
3002 |
5001 |
8 |
70010 |
1983,43 |
10.10.2012 00:00:00 |
3004 |
5006 |
9 |
70003 |
2480,40 |
10.10.2012 00:00:00 |
3009 |
5003 |
10 |
70012 |
250,45 |
27.06.2012 00:00:00 |
3008 |
5002 |
11 |
70011 |
75,29 |
17.08.2012 00:00:00 |
3003 |
5007 |
12 |
70013 |
3045,60 |
25.04.2012 00:00:00 |
3002 |
5001 |
13 |
70014 |
150,50 |
05.10.2012 00:00:00 |
3060 |
|
|
customer_id |
cust_name |
city |
grade |
salesman_id |
1 |
3002 |
Nick Rimando |
New York |
100 |
5001 |
2 |
3005 |
Graham Zusi |
California |
200 |
5002 |
3 |
3001 |
Brad Guzan |
London |
0 |
5005 |
4 |
3004 |
Fabian Johns |
Paris |
300 |
5006 |
5 |
3007 |
Brad Davis |
New York |
200 |
5001 |
6 |
3050 |
BradGuzanNEW |
London |
350 |
5005 |
7 |
3009 |
Geoff Camero |
Berlin |
100 |
5003 |
8 |
3008 |
Julian Green |
London |
300 |
5002 |
9 |
3003 |
Jozy Altidor |
Moscow |
200 |
5007 |
10 |
3060 |
TestGuzanNEW |
London |
350 |
|
11 |
3011 |
Green |
London |
300 |
5002 |
|
ord_no |
purch_amt |
ord_date |
customer_id |
salesman_id |
1 |
70001 |
150,50 |
05.10.2012 00:00:00 |
3005 |
5002 |
2 |
70009 |
270,65 |
10.09.2012 00:00:00 |
3001 |
5005 |
3 |
70002 |
65,26 |
05.10.2012 00:00:00 |
3002 |
5001 |
4 |
70007 |
948,50 |
10.09.2012 00:00:00 |
3005 |
5002 |
5 |
70004 |
110,50 |
17.08.2012 00:00:00 |
3009 |
5003 |
6 |
70005 |
2400,60 |
27.07.2012 00:00:00 |
3007 |
5001 |
7 |
70008 |
5760,00 |
10.09.2012 00:00:00 |
3002 |
5001 |
8 |
70010 |
1983,43 |
10.10.2012 00:00:00 |
3004 |
5006 |
9 |
70003 |
2480,40 |
10.10.2012 00:00:00 |
3009 |
5003 |
10 |
70012 |
250,45 |
27.06.2012 00:00:00 |
3008 |
5002 |
11 |
70011 |
75,29 |
17.08.2012 00:00:00 |
3003 |
5007 |
12 |
70013 |
3045,60 |
25.04.2012 00:00:00 |
3002 |
5001 |
13 |
70014 |
150,50 |
05.10.2012 00:00:00 |
3060 |
|
14 |
70015 |
150,50 |
05.10.2012 00:00:00 |
3011 |
5006 |
|
customer_id |
cust_name |
salesman_id |
ord_no |
purch_amt |
1 |
3002 |
Nick Rimando |
5001 |
70002 |
65,26 |
2 |
3002 |
Nick Rimando |
5001 |
70008 |
5760,00 |
3 |
3002 |
Nick Rimando |
5001 |
70013 |
3045,60 |
4 |
3005 |
Graham Zusi |
5002 |
70001 |
150,50 |
5 |
3005 |
Graham Zusi |
5002 |
70007 |
948,50 |
6 |
3001 |
Brad Guzan |
5005 |
70009 |
270,65 |
7 |
3004 |
Fabian Johns |
5006 |
70010 |
1983,43 |
8 |
3007 |
Brad Davis |
5001 |
70005 |
2400,60 |
9 |
3050 |
BradGuzanNEW |
5005 |
NULL |
NULL |
10 |
3009 |
Geoff Camero |
5003 |
70004 |
110,50 |
11 |
3009 |
Geoff Camero |
5003 |
70003 |
2480,40 |
12 |
3008 |
Julian Green |
5002 |
70012 |
250,45 |
13 |
3003 |
Jozy Altidor |
5007 |
70011 |
75,29 |
14 |
3060 |
TestGuzanNEW |
|
70014 |
150,50 |
15 |
3011 |
Green |
5002 |
NULL |
NULL |
|
salesman_Id |
name |
city |
Customer Id |
Cust Name |
(No column name) |
Order No |
Purchase Amt |
1 |
5001 |
James Hoog |
New York |
3002 |
Nick Rimando |
NULL |
70002 |
65,26 |
2 |
5001 |
James Hoog |
New York |
3002 |
Nick Rimando |
NULL |
70008 |
5760,00 |
3 |
5001 |
James Hoog |
New York |
3002 |
Nick Rimando |
NULL |
70013 |
3045,60 |
4 |
5001 |
James Hoog |
New York |
3007 |
Brad Davis |
NULL |
70005 |
2400,60 |
5 |
5002 |
Nail Knite |
Paris |
3005 |
Graham Zusi |
NULL |
70001 |
150,50 |
6 |
5002 |
Nail Knite |
Paris |
3005 |
Graham Zusi |
NULL |
70007 |
948,50 |
7 |
5002 |
Nail Knite |
Paris |
3008 |
Julian Green |
NULL |
70012 |
250,45 |
8 |
5002 |
Nail Knite |
Paris |
3011 |
Green |
NoOrder |
0 |
0,00 |
9 |
5005 |
Pit Alex |
london |
3001 |
Brad Guzan |
NULL |
70009 |
270,65 |
10 |
5005 |
Pit Alex |
london |
3050 |
BradGuzanNEW |
NoOrder |
0 |
0,00 |
11 |
5003 |
Lauson Hen |
|
3009 |
Geoff Camero |
NULL |
70004 |
110,50 |
12 |
5003 |
Lauson Hen |
|
3009 |
Geoff Camero |
NULL |
70003 |
2480,40 |
13 |
5006 |
Mc Lyon |
Paris |
3004 |
Fabian Johns |
NULL |
70010 |
1983,43 |
14 |
5007 |
Paul Adam |
Romes |
3003 |
Jozy Altidor |
NULL |
70011 |
75,29 |
15 |
9007 |
Paul Adam |
Romes |
|
NoOrdByLinkd |
NoOrder |
0 |
0,00 |
|
customer_id |
cust_name |
grade |
ord_no |
purch_amt |
1 |
3002 |
Nick Rimando |
100 |
70008 |
5760,00 |
2 |
3002 |
Nick Rimando |
100 |
70013 |
3045,60 |
3 |
3007 |
Brad Davis |
200 |
70005 |
2400,60 |
4 |
3009 |
Geoff Camero |
100 |
70003 |
2480,40 |
|
salesman_id |
name |
city |
commission |
customer_id |
cust_name |
grade |
ord_no |
purch_amt |
salesman_id |
1 |
5001 |
James Hoog |
New York |
0,15 |
3002 |
Nick Rimando |
100 |
70008 |
5760,00 |
5001 |
2 |
5001 |
James Hoog |
New York |
0,15 |
3002 |
Nick Rimando |
100 |
70013 |
3045,60 |
5001 |
3 |
5001 |
James Hoog |
New York |
0,15 |
3007 |
Brad Davis |
200 |
70005 |
2400,60 |
5001 |
4 |
5002 |
Nail Knite |
Paris |
0,13 |
NULL |
NULL |
NULL |
NULL |
NULL |
NULL |
5 |
5005 |
Pit Alex |
london |
0,11 |
NULL |
NULL |
NULL |
NULL |
NULL |
NULL |
6 |
5003 |
Lauson Hen |
|
0,12 |
3009 |
Geoff Camero |
100 |
70003 |
2480,40 |
5003 |
7 |
5006 |
Mc Lyon |
Paris |
0,14 |
NULL |
NULL |
NULL |
NULL |
NULL |
NULL |
8 |
5007 |
Paul Adam |
Romes |
0,13 |
NULL |
NULL |
NULL |
NULL |
NULL |
NULL |
9 |
9007 |
Paul Adam |
Romes |
0,13 |
NULL |
NULL |
NULL |
NULL |
NULL |
NULL |
|
customer_id |
cust_name |
grade |
ord_no |
purch_amt |
1 |
3002 |
Nick Rimando |
100 |
70002 |
65,26 |
2 |
3002 |
Nick Rimando |
100 |
70008 |
5760,00 |
3 |
3002 |
Nick Rimando |
100 |
70013 |
3045,60 |
4 |
3005 |
Graham Zusi |
200 |
70001 |
150,50 |
5 |
3005 |
Graham Zusi |
200 |
70007 |
948,50 |
6 |
3004 |
Fabian Johns |
300 |
70010 |
1983,43 |
7 |
3007 |
Brad Davis |
200 |
70005 |
2400,60 |
8 |
3050 |
BradGuzanNEW |
350 |
NULL |
NULL |
9 |
3009 |
Geoff Camero |
100 |
70004 |
110,50 |
10 |
3009 |
Geoff Camero |
100 |
70003 |
2480,40 |
11 |
3008 |
Julian Green |
300 |
70012 |
250,45 |
12 |
3003 |
Jozy Altidor |
200 |
70011 |
75,29 |
13 |
3060 |
TestGuzanNEW |
350 |
70014 |
150,50 |
14 |
3011 |
Green |
300 |
70015 |
150,50 |
|
salesman_id |
name |
customer_id |
cust_name |
grade |
ord_no |
purch_amt |
salesman_id |
1 |
5002 |
Nail Knite |
3005 |
Graham Zusi |
200 |
70001 |
150,50 |
5002 |
2 |
5001 |
James Hoog |
3002 |
Nick Rimando |
100 |
70002 |
65,26 |
5001 |
3 |
5002 |
Nail Knite |
3005 |
Graham Zusi |
200 |
70007 |
948,50 |
5002 |
4 |
5003 |
Lauson Hen |
3009 |
Geoff Camero |
100 |
70004 |
110,50 |
5003 |
5 |
5001 |
James Hoog |
3007 |
Brad Davis |
200 |
70005 |
2400,60 |
5001 |
6 |
5001 |
James Hoog |
3002 |
Nick Rimando |
100 |
70008 |
5760,00 |
5001 |
7 |
5006 |
Mc Lyon |
3004 |
Fabian Johns |
300 |
70010 |
1983,43 |
5006 |
8 |
5003 |
Lauson Hen |
3009 |
Geoff Camero |
100 |
70003 |
2480,40 |
5003 |
9 |
5002 |
Nail Knite |
3008 |
Julian Green |
300 |
70012 |
250,45 |
5002 |
10 |
5007 |
Paul Adam |
3003 |
Jozy Altidor |
200 |
70011 |
75,29 |
5007 |
11 |
5001 |
James Hoog |
3002 |
Nick Rimando |
100 |
70013 |
3045,60 |
5001 |
12 |
5006 |
Mc Lyon |
3011 |
Green |
300 |
70015 |
150,50 |
5006 |
|
salesman_id |
name |
city |
commission |
customer_id |
cust_name |
grade |
ord_no |
purch_amt |
salesman_id |
1 |
5001 |
James Hoog |
New York |
0,15 |
3002 |
Nick Rimando |
100 |
70002 |
65,26 |
5001 |
2 |
5001 |
James Hoog |
New York |
0,15 |
3007 |
Brad Davis |
200 |
70005 |
2400,60 |
5001 |
3 |
5001 |
James Hoog |
New York |
0,15 |
3002 |
Nick Rimando |
100 |
70008 |
5760,00 |
5001 |
4 |
5001 |
James Hoog |
New York |
0,15 |
3002 |
Nick Rimando |
100 |
70013 |
3045,60 |
5001 |
5 |
5002 |
Nail Knite |
Paris |
0,13 |
3005 |
Graham Zusi |
200 |
70001 |
150,50 |
5002 |
6 |
5002 |
Nail Knite |
Paris |
0,13 |
3005 |
Graham Zusi |
200 |
70007 |
948,50 |
5002 |
7 |
5002 |
Nail Knite |
Paris |
0,13 |
3008 |
Julian Green |
300 |
70012 |
250,45 |
5002 |
8 |
5005 |
Pit Alex |
london |
0,11 |
3001 |
Brad Guzan |
0 |
70009 |
270,65 |
5005 |
9 |
5003 |
Lauson Hen |
|
0,12 |
3009 |
Geoff Camero |
100 |
70004 |
110,50 |
5003 |
10 |
5003 |
Lauson Hen |
|
0,12 |
3009 |
Geoff Camero |
100 |
70003 |
2480,40 |
5003 |
11 |
5006 |
Mc Lyon |
Paris |
0,14 |
3004 |
Fabian Johns |
300 |
70010 |
1983,43 |
5006 |
12 |
5006 |
Mc Lyon |
Paris |
0,14 |
3011 |
Green |
300 |
70015 |
150,50 |
5006 |
13 |
5007 |
Paul Adam |
Romes |
0,13 |
3003 |
Jozy Altidor |
200 |
70011 |
75,29 |
5007 |
14 |
9007 |
Paul Adam |
Romes |
0,13 |
NULL |
NULL |
NULL |
NULL |
NULL |
NULL |
|
salesman_id |
name |
customer_id |
cust_name |
grade |
ord_no |
purch_amt |
salesman_id |
1 |
5001 |
James Hoog |
3002 |
Nick Rimando |
100 |
70002 |
65,26 |
5001 |
2 |
5001 |
James Hoog |
3007 |
Brad Davis |
200 |
70005 |
2400,60 |
5001 |
3 |
5001 |
James Hoog |
3002 |
Nick Rimando |
100 |
70008 |
5760,00 |
5001 |
4 |
5001 |
James Hoog |
3002 |
Nick Rimando |
100 |
70013 |
3045,60 |
5001 |
5 |
5002 |
Nail Knite |
3005 |
Graham Zusi |
200 |
70001 |
150,50 |
5002 |
6 |
5002 |
Nail Knite |
3005 |
Graham Zusi |
200 |
70007 |
948,50 |
5002 |
7 |
5002 |
Nail Knite |
3008 |
Julian Green |
300 |
70012 |
250,45 |
5002 |
8 |
5005 |
Pit Alex |
3001 |
Brad Guzan |
0 |
70009 |
270,65 |
5005 |
9 |
5003 |
Lauson Hen |
3009 |
Geoff Camero |
100 |
70004 |
110,50 |
5003 |
10 |
5003 |
Lauson Hen |
3009 |
Geoff Camero |
100 |
70003 |
2480,40 |
5003 |
11 |
5006 |
Mc Lyon |
3004 |
Fabian Johns |
300 |
70010 |
1983,43 |
5006 |
12 |
5006 |
Mc Lyon |
3011 |
Green |
300 |
70015 |
150,50 |
5006 |
13 |
5007 |
Paul Adam |
3003 |
Jozy Altidor |
200 |
70011 |
75,29 |
5007 |
14 |
9007 |
Paul Adam |
NULL |
NULL |
NULL |
NULL |
NULL |
NULL |
|
salesman_id |
name |
city |
commission |
customer_id |
cust_name |
grade |
ord_no |
purch_amt |
salesman_id |
1 |
5001 |
James Hoog |
New York |
0,15 |
3002 |
Nick Rimando |
100 |
70008 |
5760,00 |
5001 |
2 |
5001 |
James Hoog |
New York |
0,15 |
3002 |
Nick Rimando |
100 |
70013 |
3045,60 |
5001 |
3 |
5001 |
James Hoog |
New York |
0,15 |
3007 |
Brad Davis |
200 |
70005 |
2400,60 |
5001 |
4 |
5002 |
Nail Knite |
Paris |
0,13 |
NULL |
NULL |
NULL |
NULL |
NULL |
NULL |
5 |
5005 |
Pit Alex |
london |
0,11 |
NULL |
NULL |
NULL |
NULL |
NULL |
NULL |
6 |
5003 |
Lauson Hen |
|
0,12 |
3009 |
Geoff Camero |
100 |
70003 |
2480,40 |
5003 |
7 |
5006 |
Mc Lyon |
Paris |
0,14 |
NULL |
NULL |
NULL |
NULL |
NULL |
NULL |
8 |
5007 |
Paul Adam |
Romes |
0,13 |
NULL |
NULL |
NULL |
NULL |
NULL |
NULL |
9 |
9007 |
Paul Adam |
Romes |
0,13 |
NULL |
NULL |
NULL |
NULL |
NULL |
NULL |
|
|