Task:

List the total amount ordered by customer with easy to read column headers.

Click here for details on Alias.

89 Records

Id	Customer	Total Spent
71	Pavarotti, Pavarotti	115673.39
63	Kloss, Kloss	114233.39
20	Mendel, Mendel	113236.68
37	McKenna, McKenna	57317.39
65	Wilson, Wilson	52245.90
24	Larsson, Larsson	32555.55
34	Pontes, Pontes	32291.15
51	Fresnière, Fresnière	32203.90
62	Carvalho, Carvalho	31944.90
39	Cramer, Cramer	31745.75
89	Jablonski, Jablonski	29073.45
25	Franken, Franken	28722.71
5	Berglund, Berglund	26968.15
59	Pipps, Pipps	26259.95
76	Cartrain, Cartrain	24704.40
9	Lebihan, Lebihan	23850.95
35	Hernández, Hernández	23611.58
10	Lincoln, Lincoln	22607.70
44	Messner, Messner	21282.02
73	Petersen, Petersen	20855.25
68	Holz, Holz	20033.20
32	Snyder, Snyder	19711.13
7	Citeaux, Citeaux	19088.00
47	Izquierdo, Izquierdo	17889.55
46	González, González	17825.06
72	Kumar, Black	17172.05
83	Ibsen, Ibsen	16643.80
87	Koskitalo, Koskitalo	16617.10
55	Phillips, Phillips	16325.15
19	Devon, Black	15033.66
4	Hardy, jhon	13806.50
56	Pfalzheim, Pfalzheim	13157.50
67	Limeira, Limeira	12924.40
14	Wang, Wang	12886.30
75	Braunschweiger, Braunschweiger	12489.70
30	Pedro Freyre, Pedro Freyre	11830.10
23	Rancé, Rancé	11666.90
80	Angel Paolino, Angel Paolino	10812.15
86	Müller, Müller	10653.85
50	Dewey, Dewey	10430.58
41	Roulet, Roulet	10272.35
84	Saveley, Saveley	9937.10
31	Fonseca, Fonseca	8702.23
49	Rovelli, Rovelli	7603.85
66	Moroni, Moroni	7555.60
3	kraków, kraków	7515.35
81	Domingues, Domingues	7310.62
28	Rodriguez, Rodriguez	7151.55
61	Batista, Batista	6973.63
88	Parente, Parente	6480.70
38	Bennett, Black	6146.30
11	Ashworth, muter	6089.90
70	Bergulfsen, Bergulfsen	5735.15
60	de Castro, de Castro	5317.10
8	Sommer, Sommer	5297.80
52	Feuer, Feuer	5042.20
79	Josephs, Josephs	4954.00
1	Mantri, sekar	4596.20
21	Cruz, Cruz	4438.90
48	Wilson, Wilson	4258.60
58	Fernández, Fernández	4242.20
15	Afonso, Afonso	3810.75
17	Ottlieb, Ottlieb	3763.21
91	Piestrzeniewicz, Piestrzeniewicz	3531.95
45	Yorres, Yorres	3490.02
54	Moncada, Moncada	3460.20
77	Nixon, Nixon	3361.00
6	Moos, Moos	3239.80
26	Schmitt, Schmitt	3172.16
90	Karttunen, Karttunen	3161.35
36	Latimer, Latimer	3063.20
64	Gutiérrez, Gutiérrez	2844.10
74	Perrier, Perrier	2423.35
40	Tonini, Tonini	1992.05
78	Wong, Wong	1947.24
12	Simpson, Simpson	1814.80
16	Brown, Black	1719.10
18	Labrune, Labrune	1615.90
82	Nagy, Nagy	1571.20
27	Accorti, Dupa	1545.70
33	Pereira, Pereira	1488.70
85	Henriot, Henriot	1480.00
69	Camino, Camino	1467.29
2	Mantri, yuka	1402.95
29	Saavedra, Saavedra	836.70
53	Crowther, Black	649.00
42	Tannamuri, Tannamuri	522.50
43	Steel, Steel	357.00
13	Chang, Chang	100.80

SQL Editor

Task: