SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table MOCK_DATA (
	dt VARCHAR(50),
	customer VARCHAR(50),
	typejo VARCHAR(4),
	amount VARCHAR(50),
	status VARCHAR(9)
);
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('20/05/2022', 'ldeares0@mozilla.com', 'BUY', '37.70', 'CANCELED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('06/12/2021', 'cbras1@t.co', 'SELL', '44.81', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('11/10/2021', 'ccoushe2@over-blog.com', 'SELL', '40.66', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('06/09/2021', 'akalderon3@etsy.com', 'SELL', '13.34', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('02/06/2022', 'arigate4@squidoo.com', 'SELL', '17.20', 'CANCELED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('25/11/2021', 'ggreensitt5@histats.com', 'SELL', '10.03', 'COMPLETED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('15/02/2022', 'broizn6@sbwire.com', 'SELL', '53.67', 'CANCELED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('27/10/2021', 'dmarsay7@w3.org', 'BUY', '32.20', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('03/05/2022', 'csnodden8@friendfeed.com', 'BUY', '0.42', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('05/04/2022', 'abows9@ifeng.com', 'BUY', '59.72', 'COMPLETED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('29/09/2021', 'bcesarica@statcounter.com', 'SELL', '64.07', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('18/09/2021', 'mjendasb@yandex.ru', 'BUY', '42.10', 'CANCELED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('31/12/2021', 'vfentonc@e-recht24.de', 'SELL', '16.13', 'CANCELED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('15/08/2021', 'rguield@bloomberg.com', 'SELL', '9.51', 'CANCELED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('17/09/2021', 'smaccleaye@apple.com', 'BUY', '65.91', 'COMPLETED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('06/12/2021', 'frosendalef@discuz.net', 'SELL', '10.16', 'CANCELED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('06/02/2022', 'ubeaneyg@jugem.jp', 'SELL', '63.87', 'CANCELED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('17/06/2021', 'jdobbisonh@si.edu', 'BUY', '31.53', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('27/07/2021', 'chaldeni@linkedin.com', 'SELL', '59.04', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('14/10/2021', 'otimmisj@ifeng.com', 'SELL', '8.37', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('02/04/2022', 'ggoakesk@arstechnica.com', 'BUY', '56.14', 'CANCELED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('28/02/2022', 'nfifootl@google.com.au', 'SELL', '61.03', 'CANCELED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('08/01/2022', 'gstreetleym@forbes.com', 'BUY', '28.83', 'CANCELED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('05/01/2022', 'ddavisonn@hc360.com', 'SELL', '0.33', 'CANCELED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('28/12/2021', 'gaindriuo@weather.com', 'SELL', '15.04', 'COMPLETED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('07/08/2021', 'wgodierp@huffingtonpost.com', 'BUY', '10.27', 'CANCELED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('13/01/2022', 'bdartnellq@google.ru', 'SELL', '43.53', 'COMPLETED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('16/10/2021', 'skilshallr@plala.or.jp', 'BUY', '46.48', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('27/11/2021', 'hbaldaccos@symantec.com', 'BUY', '56.27', 'CANCELED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('30/08/2021', 'gsutort@feedburner.com', 'BUY', '43.24', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('10/09/2021', 'gbriersu@multiply.com', 'SELL', '38.30', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('23/01/2022', 'psmalcombev@typepad.com', 'SELL', '31.58', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('09/08/2021', 'rpettegreew@cnbc.com', 'BUY', '45.67', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('03/05/2022', 'sdechelettex@google.es', 'SELL', '17.55', 'CANCELED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('07/07/2021', 'tchatell14@google.cn', 'BUY', '9.03', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('21/05/2022', 'tchatell14@google.cn', 'SELL', '3.43', 'COMPLETED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('26/01/2022', 'bbenny10@e-recht24.de', 'BUY', '2.97', 'CANCELED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('24/06/2021', 'ecockley11@rediff.com', 'BUY', '10.30', 'COMPLETED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('19/03/2022', 'eiozefovich12@goo.ne.jp', 'BUY', '54.33', 'COMPLETED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('09/04/2022', 'bcolly13@51.la', 'BUY', '65.11', 'CANCELED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('05/10/2021', 'tchatell14@google.cn', 'BUY', '57.35', 'COMPLETED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('23/07/2021', 'vsailor15@ning.com', 'SELL', '58.18', 'COMPLETED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('08/01/2022', 'ebriat16@edublogs.org', 'SELL', '42.70', 'CANCELED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('09/12/2021', 'klipman17@yellowpages.com', 'BUY', '40.80', 'CANCELED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('26/02/2022', 'tsantoro18@elpais.com', 'BUY', '28.74', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('03/06/2022', 'nbassil19@scribd.com', 'SELL', '14.21', 'COMPLETED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('20/06/2021', 'clangrish1a@elegantthemes.com', 'SELL', '24.52', 'COMPLETED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('24/03/2022', 'chouldin1b@whitehouse.gov', 'SELL', '29.54', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('10/12/2021', 'emachan1c@statcounter.com', 'SELL', '4.41', 'COMPLETED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('12/08/2021', 'yweine1d@yelp.com', 'BUY', '42.88', 'COMPLETED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('02/01/2022', 'vwhitley1e@baidu.com', 'SELL', '13.21', 'COMPLETED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('16/12/2021', 'agilliard1f@ucla.edu', 'SELL', '2.11', 'COMPLETED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('14/12/2021', 'gbalcers1g@blog.com', 'SELL', '16.54', 'COMPLETED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('21/08/2021', 'mhug1h@dmoz.org', 'BUY', '17.98', 'CANCELED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('18/10/2021', 'gbagniuk1i@unesco.org', 'BUY', '68.92', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('15/08/2021', 'kbartocci1j@last.fm', 'SELL', '26.71', 'CANCELED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('05/01/2022', 'lsnarr1k@tumblr.com', 'BUY', '31.68', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('01/09/2021', 'gwoakes1l@latimes.com', 'BUY', '19.01', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('06/09/2021', 'sterbeck1m@symantec.com', 'SELL', '54.67', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('15/09/2021', 'oshrive1n@xrea.com', 'BUY', '14.46', 'COMPLETED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('05/06/2022', 'mduddy1o@amazonaws.com', 'SELL', '34.18', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('28/06/2021', 'rsteketee1p@forbes.com', 'SELL', '32.02', 'CANCELED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('08/08/2021', 'aaimer1q@ox.ac.uk', 'SELL', '62.44', 'COMPLETED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('04/12/2021', 'gcaress1r@usnews.com', 'BUY', '44.86', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('24/01/2022', 'cmularkey1s@cbslocal.com', 'SELL', '2.35', 'COMPLETED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('30/10/2021', 'fmears1t@google.nl', 'SELL', '53.35', 'CANCELED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('21/03/2022', 'mforsdike1u@blog.com', 'SELL', '66.08', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('11/12/2021', 'ksouthouse1v@g.co', 'SELL', '63.90', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('08/10/2021', 'cellwood2r@taobao.com', 'BUY', '35.47', 'COMPLETED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('25/03/2022', 'mkmicicki1x@qq.com', 'BUY', '31.15', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('01/03/2022', 'tdyton1y@quantcast.com', 'SELL', '33.21', 'CANCELED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('24/12/2021', 'wfowgies1z@ftc.gov', 'BUY', '38.63', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('16/07/2021', 'cellwood2r@taobao.com', 'SELL', '15.37', 'COMPLETED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('19/12/2021', 'lfaich21@ft.com', 'SELL', '54.13', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('12/05/2022', 'sstepto22@un.org', 'SELL', '69.53', 'CANCELED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('20/04/2022', 'agrevel23@java.com', 'BUY', '29.55', 'CANCELED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('13/08/2021', 'ucannings24@mtv.com', 'BUY', '62.14', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('18/11/2021', 'sewell25@cisco.com', 'SELL', '12.91', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('10/12/2021', 'hguinness26@networksolutions.com', 'BUY', '0.54', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('23/04/2022', 'pquilkin27@house.gov', 'BUY', '45.98', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('14/11/2021', 'lifill28@salon.com', 'BUY', '49.98', 'CANCELED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('14/09/2021', 'hstpaul29@wikia.com', 'SELL', '17.56', 'COMPLETED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('21/06/2021', 'ltaggett2a@amazonaws.com', 'BUY', '23.47', 'CANCELED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('01/07/2021', 'smuckle2b@shinystat.com', 'SELL', '60.69', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('14/12/2021', 'hgianuzzi2c@t-online.de', 'SELL', '24.28', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('11/07/2021', 'lmclenahan2d@shutterfly.com', 'BUY', '6.89', 'COMPLETED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('26/11/2021', 'fbrockie2e@wikia.com', 'SELL', '37.92', 'COMPLETED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('24/02/2022', 'rcicero2f@hao123.com', 'SELL', '27.89', 'COMPLETED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('11/01/2022', 'krosone2g@theatlantic.com', 'SELL', '40.76', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('11/07/2021', 'emccorkell2h@odnoklassniki.ru', 'BUY', '5.86', 'CANCELED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('02/01/2022', 'tphipp2i@symantec.com', 'BUY', '68.55', 'CANCELED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('29/07/2021', 'jtribbeck2j@nature.com', 'BUY', '6.19', 'CANCELED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('13/02/2022', 'mcromblehome2k@yelp.com', 'SELL', '55.08', 'COMPLETED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('23/04/2022', 'cellwood2r@taobao.com', 'BUY', '61.38', 'COMPLETED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('04/06/2022', 'dmoney2m@bloglines.com', 'BUY', '3.66', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('04/12/2021', 'rmackness2n@xrea.com', 'SELL', '63.71', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('02/07/2021', 'lferryn2o@engadget.com', 'SELL', '22.68', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('25/02/2022', 'jmarousek2p@house.gov', 'SELL', '57.27', 'PENDING');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('08/01/2022', 'fmesnard2q@opera.com', 'BUY', '66.04', 'CANCELED');
insert into MOCK_DATA (dt, customer, typejo, amount, status) values ('30/04/2022', 'cellwood2r@taobao.com', 'SELL', '19.90', 'PENDING');
100 rows affected

SELECT *
FROM MOCK_DATA


dt
customer
typejo
amount
status


20/05/2022
ldeares0@mozilla.com
BUY
37.70
CANCELED

06/12/2021
cbras1@t.co
SELL
44.81
PENDING

11/10/2021
ccoushe2@over-blog.com
SELL
40.66
PENDING

06/09/2021
akalderon3@etsy.com
SELL
13.34
PENDING

02/06/2022
arigate4@squidoo.com
SELL
17.20
CANCELED

25/11/2021
ggreensitt5@histats.com
SELL
10.03
COMPLETED

15/02/2022
broizn6@sbwire.com
SELL
53.67
CANCELED

27/10/2021
dmarsay7@w3.org
BUY
32.20
PENDING

03/05/2022
csnodden8@friendfeed.com
BUY
0.42
PENDING

05/04/2022
abows9@ifeng.com
BUY
59.72
COMPLETED

29/09/2021
bcesarica@statcounter.com
SELL
64.07
PENDING

18/09/2021
mjendasb@yandex.ru
BUY
42.10
CANCELED

31/12/2021
vfentonc@e-recht24.de
SELL
16.13
CANCELED

15/08/2021
rguield@bloomberg.com
SELL
9.51
CANCELED

17/09/2021
smaccleaye@apple.com
BUY
65.91
COMPLETED

06/12/2021
frosendalef@discuz.net
SELL
10.16
CANCELED

06/02/2022
ubeaneyg@jugem.jp
SELL
63.87
CANCELED

17/06/2021
jdobbisonh@si.edu
BUY
31.53
PENDING

27/07/2021
chaldeni@linkedin.com
SELL
59.04
PENDING

14/10/2021
otimmisj@ifeng.com
SELL
8.37
PENDING

02/04/2022
ggoakesk@arstechnica.com
BUY
56.14
CANCELED

28/02/2022
nfifootl@google.com.au
SELL
61.03
CANCELED

08/01/2022
gstreetleym@forbes.com
BUY
28.83
CANCELED

05/01/2022
ddavisonn@hc360.com
SELL
0.33
CANCELED

28/12/2021
gaindriuo@weather.com
SELL
15.04
COMPLETED

07/08/2021
wgodierp@huffingtonpost.com
BUY
10.27
CANCELED

13/01/2022
bdartnellq@google.ru
SELL
43.53
COMPLETED

16/10/2021
skilshallr@plala.or.jp
BUY
46.48
PENDING

27/11/2021
hbaldaccos@symantec.com
BUY
56.27
CANCELED

30/08/2021
gsutort@feedburner.com
BUY
43.24
PENDING

10/09/2021
gbriersu@multiply.com
SELL
38.30
PENDING

23/01/2022
psmalcombev@typepad.com
SELL
31.58
PENDING

09/08/2021
rpettegreew@cnbc.com
BUY
45.67
PENDING

03/05/2022
sdechelettex@google.es
SELL
17.55
CANCELED

07/07/2021
tchatell14@google.cn
BUY
9.03
PENDING

21/05/2022
tchatell14@google.cn
SELL
3.43
COMPLETED

26/01/2022
bbenny10@e-recht24.de
BUY
2.97
CANCELED

24/06/2021
ecockley11@rediff.com
BUY
10.30
COMPLETED

19/03/2022
eiozefovich12@goo.ne.jp
BUY
54.33
COMPLETED

09/04/2022
bcolly13@51.la
BUY
65.11
CANCELED

05/10/2021
tchatell14@google.cn
BUY
57.35
COMPLETED

23/07/2021
vsailor15@ning.com
SELL
58.18
COMPLETED

08/01/2022
ebriat16@edublogs.org
SELL
42.70
CANCELED

09/12/2021
klipman17@yellowpages.com
BUY
40.80
CANCELED

26/02/2022
tsantoro18@elpais.com
BUY
28.74
PENDING

03/06/2022
nbassil19@scribd.com
SELL
14.21
COMPLETED

20/06/2021
clangrish1a@elegantthemes.com
SELL
24.52
COMPLETED

24/03/2022
chouldin1b@whitehouse.gov
SELL
29.54
PENDING

10/12/2021
emachan1c@statcounter.com
SELL
4.41
COMPLETED

12/08/2021
yweine1d@yelp.com
BUY
42.88
COMPLETED

02/01/2022
vwhitley1e@baidu.com
SELL
13.21
COMPLETED

16/12/2021
agilliard1f@ucla.edu
SELL
2.11
COMPLETED

14/12/2021
gbalcers1g@blog.com
SELL
16.54
COMPLETED

21/08/2021
mhug1h@dmoz.org
BUY
17.98
CANCELED

18/10/2021
gbagniuk1i@unesco.org
BUY
68.92
PENDING

15/08/2021
kbartocci1j@last.fm
SELL
26.71
CANCELED

05/01/2022
lsnarr1k@tumblr.com
BUY
31.68
PENDING

01/09/2021
gwoakes1l@latimes.com
BUY
19.01
PENDING

06/09/2021
sterbeck1m@symantec.com
SELL
54.67
PENDING

15/09/2021
oshrive1n@xrea.com
BUY
14.46
COMPLETED

05/06/2022
mduddy1o@amazonaws.com
SELL
34.18
PENDING

28/06/2021
rsteketee1p@forbes.com
SELL
32.02
CANCELED

08/08/2021
aaimer1q@ox.ac.uk
SELL
62.44
COMPLETED

04/12/2021
gcaress1r@usnews.com
BUY
44.86
PENDING

24/01/2022
cmularkey1s@cbslocal.com
SELL
2.35
COMPLETED

30/10/2021
fmears1t@google.nl
SELL
53.35
CANCELED

21/03/2022
mforsdike1u@blog.com
SELL
66.08
PENDING

11/12/2021
ksouthouse1v@g.co
SELL
63.90
PENDING

08/10/2021
cellwood2r@taobao.com
BUY
35.47
COMPLETED

25/03/2022
mkmicicki1x@qq.com
BUY
31.15
PENDING

01/03/2022
tdyton1y@quantcast.com
SELL
33.21
CANCELED

24/12/2021
wfowgies1z@ftc.gov
BUY
38.63
PENDING

16/07/2021
cellwood2r@taobao.com
SELL
15.37
COMPLETED

19/12/2021
lfaich21@ft.com
SELL
54.13
PENDING

12/05/2022
sstepto22@un.org
SELL
69.53
CANCELED

20/04/2022
agrevel23@java.com
BUY
29.55
CANCELED

13/08/2021
ucannings24@mtv.com
BUY
62.14
PENDING

18/11/2021
sewell25@cisco.com
SELL
12.91
PENDING

10/12/2021
hguinness26@networksolutions.com
BUY
0.54
PENDING

23/04/2022
pquilkin27@house.gov
BUY
45.98
PENDING

14/11/2021
lifill28@salon.com
BUY
49.98
CANCELED

14/09/2021
hstpaul29@wikia.com
SELL
17.56
COMPLETED

21/06/2021
ltaggett2a@amazonaws.com
BUY
23.47
CANCELED

01/07/2021
smuckle2b@shinystat.com
SELL
60.69
PENDING

14/12/2021
hgianuzzi2c@t-online.de
SELL
24.28
PENDING

11/07/2021
lmclenahan2d@shutterfly.com
BUY
6.89
COMPLETED

26/11/2021
fbrockie2e@wikia.com
SELL
37.92
COMPLETED

24/02/2022
rcicero2f@hao123.com
SELL
27.89
COMPLETED

11/01/2022
krosone2g@theatlantic.com
SELL
40.76
PENDING

11/07/2021
emccorkell2h@odnoklassniki.ru
BUY
5.86
CANCELED

02/01/2022
tphipp2i@symantec.com
BUY
68.55
CANCELED

29/07/2021
jtribbeck2j@nature.com
BUY
6.19
CANCELED

13/02/2022
mcromblehome2k@yelp.com
SELL
55.08
COMPLETED

23/04/2022
cellwood2r@taobao.com
BUY
61.38
COMPLETED

04/06/2022
dmoney2m@bloglines.com
BUY
3.66
PENDING

04/12/2021
rmackness2n@xrea.com
SELL
63.71
PENDING

02/07/2021
lferryn2o@engadget.com
SELL
22.68
PENDING

25/02/2022
jmarousek2p@house.gov
SELL
57.27
PENDING

08/01/2022
fmesnard2q@opera.com
BUY
66.04
CANCELED

30/04/2022
cellwood2r@taobao.com
SELL
19.90
PENDING


ALTER TABLE MOCK_DATA ALTER COLUMN amount DECIMAL (4, 2);  
SELECT  customer, 
isnull((select sum(amount) FROM MOCK_DATA where customer=MG.customer AND typejo='BUY'), 0) BUY, 
isnull((select sum(amount) FROM MOCK_DATA where customer=MG.customer AND typejo='SELL'), 0) SELL,

( isnull((select sum(amount) FROM MOCK_DATA where customer=MG.customer AND typejo='BUY'), 0) - 
isnull((select sum(amount) FROM MOCK_DATA where customer=MG.customer AND typejo='SELL'), 0) ) TOTAL
FROM MOCK_DATA MG
GROUP BY customer 



customer
BUY
SELL
TOTAL


aaimer1q@ox.ac.uk
0.00
62.44
-62.44

abows9@ifeng.com
59.72
0.00
59.72

agilliard1f@ucla.edu
0.00
2.11
-2.11

agrevel23@java.com
29.55
0.00
29.55

akalderon3@etsy.com
0.00
13.34
-13.34

arigate4@squidoo.com
0.00
17.20
-17.20

bbenny10@e-recht24.de
2.97
0.00
2.97

bcesarica@statcounter.com
0.00
64.07
-64.07

bcolly13@51.la
65.11
0.00
65.11

bdartnellq@google.ru
0.00
43.53
-43.53

broizn6@sbwire.com
0.00
53.67
-53.67

cbras1@t.co
0.00
44.81
-44.81

ccoushe2@over-blog.com
0.00
40.66
-40.66

cellwood2r@taobao.com
96.85
35.27
61.58

chaldeni@linkedin.com
0.00
59.04
-59.04

chouldin1b@whitehouse.gov
0.00
29.54
-29.54

clangrish1a@elegantthemes.com
0.00
24.52
-24.52

cmularkey1s@cbslocal.com
0.00
2.35
-2.35

csnodden8@friendfeed.com
0.42
0.00
0.42

ddavisonn@hc360.com
0.00
0.33
-0.33

dmarsay7@w3.org
32.20
0.00
32.20

dmoney2m@bloglines.com
3.66
0.00
3.66

ebriat16@edublogs.org
0.00
42.70
-42.70

ecockley11@rediff.com
10.30
0.00
10.30

eiozefovich12@goo.ne.jp
54.33
0.00
54.33

emachan1c@statcounter.com
0.00
4.41
-4.41

emccorkell2h@odnoklassniki.ru
5.86
0.00
5.86

fbrockie2e@wikia.com
0.00
37.92
-37.92

fmears1t@google.nl
0.00
53.35
-53.35

fmesnard2q@opera.com
66.04
0.00
66.04

frosendalef@discuz.net
0.00
10.16
-10.16

gaindriuo@weather.com
0.00
15.04
-15.04

gbagniuk1i@unesco.org
68.92
0.00
68.92

gbalcers1g@blog.com
0.00
16.54
-16.54

gbriersu@multiply.com
0.00
38.30
-38.30

gcaress1r@usnews.com
44.86
0.00
44.86

ggoakesk@arstechnica.com
56.14
0.00
56.14

ggreensitt5@histats.com
0.00
10.03
-10.03

gstreetleym@forbes.com
28.83
0.00
28.83

gsutort@feedburner.com
43.24
0.00
43.24

gwoakes1l@latimes.com
19.01
0.00
19.01

hbaldaccos@symantec.com
56.27
0.00
56.27

hgianuzzi2c@t-online.de
0.00
24.28
-24.28

hguinness26@networksolutions.com
0.54
0.00
0.54

hstpaul29@wikia.com
0.00
17.56
-17.56

jdobbisonh@si.edu
31.53
0.00
31.53

jmarousek2p@house.gov
0.00
57.27
-57.27

jtribbeck2j@nature.com
6.19
0.00
6.19

kbartocci1j@last.fm
0.00
26.71
-26.71

klipman17@yellowpages.com
40.80
0.00
40.80

krosone2g@theatlantic.com
0.00
40.76
-40.76

ksouthouse1v@g.co
0.00
63.90
-63.90

ldeares0@mozilla.com
37.70
0.00
37.70

lfaich21@ft.com
0.00
54.13
-54.13

lferryn2o@engadget.com
0.00
22.68
-22.68

lifill28@salon.com
49.98
0.00
49.98

lmclenahan2d@shutterfly.com
6.89
0.00
6.89

lsnarr1k@tumblr.com
31.68
0.00
31.68

ltaggett2a@amazonaws.com
23.47
0.00
23.47

mcromblehome2k@yelp.com
0.00
55.08
-55.08

mduddy1o@amazonaws.com
0.00
34.18
-34.18

mforsdike1u@blog.com
0.00
66.08
-66.08

mhug1h@dmoz.org
17.98
0.00
17.98

mjendasb@yandex.ru
42.10
0.00
42.10

mkmicicki1x@qq.com
31.15
0.00
31.15

nbassil19@scribd.com
0.00
14.21
-14.21

nfifootl@google.com.au
0.00
61.03
-61.03

oshrive1n@xrea.com
14.46
0.00
14.46

otimmisj@ifeng.com
0.00
8.37
-8.37

pquilkin27@house.gov
45.98
0.00
45.98

psmalcombev@typepad.com
0.00
31.58
-31.58

rcicero2f@hao123.com
0.00
27.89
-27.89

rguield@bloomberg.com
0.00
9.51
-9.51

rmackness2n@xrea.com
0.00
63.71
-63.71

rpettegreew@cnbc.com
45.67
0.00
45.67

rsteketee1p@forbes.com
0.00
32.02
-32.02

sdechelettex@google.es
0.00
17.55
-17.55

sewell25@cisco.com
0.00
12.91
-12.91

skilshallr@plala.or.jp
46.48
0.00
46.48

smaccleaye@apple.com
65.91
0.00
65.91

smuckle2b@shinystat.com
0.00
60.69
-60.69

sstepto22@un.org
0.00
69.53
-69.53

sterbeck1m@symantec.com
0.00
54.67
-54.67

tchatell14@google.cn
66.38
3.43
62.95

tdyton1y@quantcast.com
0.00
33.21
-33.21

tphipp2i@symantec.com
68.55
0.00
68.55

tsantoro18@elpais.com
28.74
0.00
28.74

ubeaneyg@jugem.jp
0.00
63.87
-63.87

ucannings24@mtv.com
62.14
0.00
62.14

vfentonc@e-recht24.de
0.00
16.13
-16.13

vsailor15@ning.com
0.00
58.18
-58.18

vwhitley1e@baidu.com
0.00
13.21
-13.21

wfowgies1z@ftc.gov
38.63
0.00
38.63

wgodierp@huffingtonpost.com
10.27
0.00
10.27

yweine1d@yelp.com
42.88
0.00
42.88

dt	customer	typejo	amount	status
20/05/2022	ldeares0@mozilla.com	BUY	37.70	CANCELED
06/12/2021	cbras1@t.co	SELL	44.81	PENDING
11/10/2021	ccoushe2@over-blog.com	SELL	40.66	PENDING
06/09/2021	akalderon3@etsy.com	SELL	13.34	PENDING
02/06/2022	arigate4@squidoo.com	SELL	17.20	CANCELED
25/11/2021	ggreensitt5@histats.com	SELL	10.03	COMPLETED
15/02/2022	broizn6@sbwire.com	SELL	53.67	CANCELED
27/10/2021	dmarsay7@w3.org	BUY	32.20	PENDING
03/05/2022	csnodden8@friendfeed.com	BUY	0.42	PENDING
05/04/2022	abows9@ifeng.com	BUY	59.72	COMPLETED
29/09/2021	bcesarica@statcounter.com	SELL	64.07	PENDING
18/09/2021	mjendasb@yandex.ru	BUY	42.10	CANCELED
31/12/2021	vfentonc@e-recht24.de	SELL	16.13	CANCELED
15/08/2021	rguield@bloomberg.com	SELL	9.51	CANCELED
17/09/2021	smaccleaye@apple.com	BUY	65.91	COMPLETED
06/12/2021	frosendalef@discuz.net	SELL	10.16	CANCELED
06/02/2022	ubeaneyg@jugem.jp	SELL	63.87	CANCELED
17/06/2021	jdobbisonh@si.edu	BUY	31.53	PENDING
27/07/2021	chaldeni@linkedin.com	SELL	59.04	PENDING
14/10/2021	otimmisj@ifeng.com	SELL	8.37	PENDING
02/04/2022	ggoakesk@arstechnica.com	BUY	56.14	CANCELED
28/02/2022	nfifootl@google.com.au	SELL	61.03	CANCELED
08/01/2022	gstreetleym@forbes.com	BUY	28.83	CANCELED
05/01/2022	ddavisonn@hc360.com	SELL	0.33	CANCELED
28/12/2021	gaindriuo@weather.com	SELL	15.04	COMPLETED
07/08/2021	wgodierp@huffingtonpost.com	BUY	10.27	CANCELED
13/01/2022	bdartnellq@google.ru	SELL	43.53	COMPLETED
16/10/2021	skilshallr@plala.or.jp	BUY	46.48	PENDING
27/11/2021	hbaldaccos@symantec.com	BUY	56.27	CANCELED
30/08/2021	gsutort@feedburner.com	BUY	43.24	PENDING
10/09/2021	gbriersu@multiply.com	SELL	38.30	PENDING
23/01/2022	psmalcombev@typepad.com	SELL	31.58	PENDING
09/08/2021	rpettegreew@cnbc.com	BUY	45.67	PENDING
03/05/2022	sdechelettex@google.es	SELL	17.55	CANCELED
07/07/2021	tchatell14@google.cn	BUY	9.03	PENDING
21/05/2022	tchatell14@google.cn	SELL	3.43	COMPLETED
26/01/2022	bbenny10@e-recht24.de	BUY	2.97	CANCELED
24/06/2021	ecockley11@rediff.com	BUY	10.30	COMPLETED
19/03/2022	eiozefovich12@goo.ne.jp	BUY	54.33	COMPLETED
09/04/2022	bcolly13@51.la	BUY	65.11	CANCELED
05/10/2021	tchatell14@google.cn	BUY	57.35	COMPLETED
23/07/2021	vsailor15@ning.com	SELL	58.18	COMPLETED
08/01/2022	ebriat16@edublogs.org	SELL	42.70	CANCELED
09/12/2021	klipman17@yellowpages.com	BUY	40.80	CANCELED
26/02/2022	tsantoro18@elpais.com	BUY	28.74	PENDING
03/06/2022	nbassil19@scribd.com	SELL	14.21	COMPLETED
20/06/2021	clangrish1a@elegantthemes.com	SELL	24.52	COMPLETED
24/03/2022	chouldin1b@whitehouse.gov	SELL	29.54	PENDING
10/12/2021	emachan1c@statcounter.com	SELL	4.41	COMPLETED
12/08/2021	yweine1d@yelp.com	BUY	42.88	COMPLETED
02/01/2022	vwhitley1e@baidu.com	SELL	13.21	COMPLETED
16/12/2021	agilliard1f@ucla.edu	SELL	2.11	COMPLETED
14/12/2021	gbalcers1g@blog.com	SELL	16.54	COMPLETED
21/08/2021	mhug1h@dmoz.org	BUY	17.98	CANCELED
18/10/2021	gbagniuk1i@unesco.org	BUY	68.92	PENDING
15/08/2021	kbartocci1j@last.fm	SELL	26.71	CANCELED
05/01/2022	lsnarr1k@tumblr.com	BUY	31.68	PENDING
01/09/2021	gwoakes1l@latimes.com	BUY	19.01	PENDING
06/09/2021	sterbeck1m@symantec.com	SELL	54.67	PENDING
15/09/2021	oshrive1n@xrea.com	BUY	14.46	COMPLETED
05/06/2022	mduddy1o@amazonaws.com	SELL	34.18	PENDING
28/06/2021	rsteketee1p@forbes.com	SELL	32.02	CANCELED
08/08/2021	aaimer1q@ox.ac.uk	SELL	62.44	COMPLETED
04/12/2021	gcaress1r@usnews.com	BUY	44.86	PENDING
24/01/2022	cmularkey1s@cbslocal.com	SELL	2.35	COMPLETED
30/10/2021	fmears1t@google.nl	SELL	53.35	CANCELED
21/03/2022	mforsdike1u@blog.com	SELL	66.08	PENDING
11/12/2021	ksouthouse1v@g.co	SELL	63.90	PENDING
08/10/2021	cellwood2r@taobao.com	BUY	35.47	COMPLETED
25/03/2022	mkmicicki1x@qq.com	BUY	31.15	PENDING
01/03/2022	tdyton1y@quantcast.com	SELL	33.21	CANCELED
24/12/2021	wfowgies1z@ftc.gov	BUY	38.63	PENDING
16/07/2021	cellwood2r@taobao.com	SELL	15.37	COMPLETED
19/12/2021	lfaich21@ft.com	SELL	54.13	PENDING
12/05/2022	sstepto22@un.org	SELL	69.53	CANCELED
20/04/2022	agrevel23@java.com	BUY	29.55	CANCELED
13/08/2021	ucannings24@mtv.com	BUY	62.14	PENDING
18/11/2021	sewell25@cisco.com	SELL	12.91	PENDING
10/12/2021	hguinness26@networksolutions.com	BUY	0.54	PENDING
23/04/2022	pquilkin27@house.gov	BUY	45.98	PENDING
14/11/2021	lifill28@salon.com	BUY	49.98	CANCELED
14/09/2021	hstpaul29@wikia.com	SELL	17.56	COMPLETED
21/06/2021	ltaggett2a@amazonaws.com	BUY	23.47	CANCELED
01/07/2021	smuckle2b@shinystat.com	SELL	60.69	PENDING
14/12/2021	hgianuzzi2c@t-online.de	SELL	24.28	PENDING
11/07/2021	lmclenahan2d@shutterfly.com	BUY	6.89	COMPLETED
26/11/2021	fbrockie2e@wikia.com	SELL	37.92	COMPLETED
24/02/2022	rcicero2f@hao123.com	SELL	27.89	COMPLETED
11/01/2022	krosone2g@theatlantic.com	SELL	40.76	PENDING
11/07/2021	emccorkell2h@odnoklassniki.ru	BUY	5.86	CANCELED
02/01/2022	tphipp2i@symantec.com	BUY	68.55	CANCELED
29/07/2021	jtribbeck2j@nature.com	BUY	6.19	CANCELED
13/02/2022	mcromblehome2k@yelp.com	SELL	55.08	COMPLETED
23/04/2022	cellwood2r@taobao.com	BUY	61.38	COMPLETED
04/06/2022	dmoney2m@bloglines.com	BUY	3.66	PENDING
04/12/2021	rmackness2n@xrea.com	SELL	63.71	PENDING
02/07/2021	lferryn2o@engadget.com	SELL	22.68	PENDING
25/02/2022	jmarousek2p@house.gov	SELL	57.27	PENDING
08/01/2022	fmesnard2q@opera.com	BUY	66.04	CANCELED
30/04/2022	cellwood2r@taobao.com	SELL	19.90	PENDING

customer	BUY	SELL	TOTAL
aaimer1q@ox.ac.uk	0.00	62.44	-62.44
abows9@ifeng.com	59.72	0.00	59.72
agilliard1f@ucla.edu	0.00	2.11	-2.11
agrevel23@java.com	29.55	0.00	29.55
akalderon3@etsy.com	0.00	13.34	-13.34
arigate4@squidoo.com	0.00	17.20	-17.20
bbenny10@e-recht24.de	2.97	0.00	2.97
bcesarica@statcounter.com	0.00	64.07	-64.07
bcolly13@51.la	65.11	0.00	65.11
bdartnellq@google.ru	0.00	43.53	-43.53
broizn6@sbwire.com	0.00	53.67	-53.67
cbras1@t.co	0.00	44.81	-44.81
ccoushe2@over-blog.com	0.00	40.66	-40.66
cellwood2r@taobao.com	96.85	35.27	61.58
chaldeni@linkedin.com	0.00	59.04	-59.04
chouldin1b@whitehouse.gov	0.00	29.54	-29.54
clangrish1a@elegantthemes.com	0.00	24.52	-24.52
cmularkey1s@cbslocal.com	0.00	2.35	-2.35
csnodden8@friendfeed.com	0.42	0.00	0.42
ddavisonn@hc360.com	0.00	0.33	-0.33
dmarsay7@w3.org	32.20	0.00	32.20
dmoney2m@bloglines.com	3.66	0.00	3.66
ebriat16@edublogs.org	0.00	42.70	-42.70
ecockley11@rediff.com	10.30	0.00	10.30
eiozefovich12@goo.ne.jp	54.33	0.00	54.33
emachan1c@statcounter.com	0.00	4.41	-4.41
emccorkell2h@odnoklassniki.ru	5.86	0.00	5.86
fbrockie2e@wikia.com	0.00	37.92	-37.92
fmears1t@google.nl	0.00	53.35	-53.35
fmesnard2q@opera.com	66.04	0.00	66.04
frosendalef@discuz.net	0.00	10.16	-10.16
gaindriuo@weather.com	0.00	15.04	-15.04
gbagniuk1i@unesco.org	68.92	0.00	68.92
gbalcers1g@blog.com	0.00	16.54	-16.54
gbriersu@multiply.com	0.00	38.30	-38.30
gcaress1r@usnews.com	44.86	0.00	44.86
ggoakesk@arstechnica.com	56.14	0.00	56.14
ggreensitt5@histats.com	0.00	10.03	-10.03
gstreetleym@forbes.com	28.83	0.00	28.83
gsutort@feedburner.com	43.24	0.00	43.24
gwoakes1l@latimes.com	19.01	0.00	19.01
hbaldaccos@symantec.com	56.27	0.00	56.27
hgianuzzi2c@t-online.de	0.00	24.28	-24.28
hguinness26@networksolutions.com	0.54	0.00	0.54
hstpaul29@wikia.com	0.00	17.56	-17.56
jdobbisonh@si.edu	31.53	0.00	31.53
jmarousek2p@house.gov	0.00	57.27	-57.27
jtribbeck2j@nature.com	6.19	0.00	6.19
kbartocci1j@last.fm	0.00	26.71	-26.71
klipman17@yellowpages.com	40.80	0.00	40.80
krosone2g@theatlantic.com	0.00	40.76	-40.76
ksouthouse1v@g.co	0.00	63.90	-63.90
ldeares0@mozilla.com	37.70	0.00	37.70
lfaich21@ft.com	0.00	54.13	-54.13
lferryn2o@engadget.com	0.00	22.68	-22.68
lifill28@salon.com	49.98	0.00	49.98
lmclenahan2d@shutterfly.com	6.89	0.00	6.89
lsnarr1k@tumblr.com	31.68	0.00	31.68
ltaggett2a@amazonaws.com	23.47	0.00	23.47
mcromblehome2k@yelp.com	0.00	55.08	-55.08
mduddy1o@amazonaws.com	0.00	34.18	-34.18
mforsdike1u@blog.com	0.00	66.08	-66.08
mhug1h@dmoz.org	17.98	0.00	17.98
mjendasb@yandex.ru	42.10	0.00	42.10
mkmicicki1x@qq.com	31.15	0.00	31.15
nbassil19@scribd.com	0.00	14.21	-14.21
nfifootl@google.com.au	0.00	61.03	-61.03
oshrive1n@xrea.com	14.46	0.00	14.46
otimmisj@ifeng.com	0.00	8.37	-8.37
pquilkin27@house.gov	45.98	0.00	45.98
psmalcombev@typepad.com	0.00	31.58	-31.58
rcicero2f@hao123.com	0.00	27.89	-27.89
rguield@bloomberg.com	0.00	9.51	-9.51
rmackness2n@xrea.com	0.00	63.71	-63.71
rpettegreew@cnbc.com	45.67	0.00	45.67
rsteketee1p@forbes.com	0.00	32.02	-32.02
sdechelettex@google.es	0.00	17.55	-17.55
sewell25@cisco.com	0.00	12.91	-12.91
skilshallr@plala.or.jp	46.48	0.00	46.48
smaccleaye@apple.com	65.91	0.00	65.91
smuckle2b@shinystat.com	0.00	60.69	-60.69
sstepto22@un.org	0.00	69.53	-69.53
sterbeck1m@symantec.com	0.00	54.67	-54.67
tchatell14@google.cn	66.38	3.43	62.95
tdyton1y@quantcast.com	0.00	33.21	-33.21
tphipp2i@symantec.com	68.55	0.00	68.55
tsantoro18@elpais.com	28.74	0.00	28.74
ubeaneyg@jugem.jp	0.00	63.87	-63.87
ucannings24@mtv.com	62.14	0.00	62.14
vfentonc@e-recht24.de	0.00	16.13	-16.13
vsailor15@ning.com	0.00	58.18	-58.18
vwhitley1e@baidu.com	0.00	13.21	-13.21
wfowgies1z@ftc.gov	38.63	0.00	38.63
wgodierp@huffingtonpost.com	10.27	0.00	10.27
yweine1d@yelp.com	42.88	0.00	42.88