SQL Editor

SQL Group By Join Example

Task:

List the total order amount for each customer, sorted high to low.
Click here for details on Group By.
 
 89 Records
FirstName LastName Total
Horst Kloss 117483.39
Jose Pavarotti 115673.39
Roland Mendel 113236.68
Patricia McKenna 57317.39
Paula Wilson 52245.90
Mario Pontes 34101.15
Maria Larsson 32555.55
Jean Fresnière 32203.90
Philip Cramer 31745.75
Lúcia Carvalho 30226.10
Karl Jablonski 29073.45
Peter Franken 28722.71
Christina Berglund 26968.15
Georg Pipps 26259.95
Pascale Cartrain 24704.40
Laurence Lebihan 23850.95
Carlos Hernández 23611.58
Elizabeth Lincoln 22607.70
Renate Messner 21282.02
Michael Holz 20033.20
Howard Snyder 19711.13
Frédérique Citeaux 19088.00
Jytte Petersen 18138.45
Felipe Izquierdo 17889.55
Carlos González 17825.06
Hari Kumar 17172.05
Palle Ibsen 16643.80
Pirkko Koskitalo 16617.10
Rene Phillips 16325.15
Ann Devon 15033.66
Thomas Hardy 13806.50
Henriette Pfalzheim 13157.50
Janete Limeira 12924.40
Yang Wang 12886.30
Art Braunschweiger 12489.70
José Pedro Freyre 11830.10
Martine Rancé 11666.90
Miguel Angel Paolino 10812.15
Rita Müller 10653.85
Catherine Dewey 10430.58
Annette Roulet 10272.35
Mary Saveley 9937.10
André Fonseca 8702.23
Giovanni Rovelli 7603.85
Maurizio Moroni 7555.60
Antonio Moreno 7515.35
Anabela Domingues 7310.62
Lino Rodriguez 7151.55
Bernardo Batista 6973.63
Paula Parente 6480.70
Helen Bennett 6146.30
Victoria Ashworth 6089.90
Jonas Bergulfsen 5735.15
Isabel de Castro 5317.10
Martín Sommer 5297.80
Alexander Feuer 5042.20
Karin Josephs 4954.00
Maria Anders 4596.20
Aria Cruz 4438.90
Fran Wilson 4258.60
Guillermo Fernández 4242.20
Pedro Afonso 3810.75
Sven Ottlieb 3763.21
Zbyszek Piestrzeniewicz 3531.95
Jaime Yorres 3490.02
Yvonne Moncada 3460.20
Liz Nixon 3361.00
Hanna Moos 3239.80
Carine Schmitt 3172.16
Matti Karttunen 3161.35
Yoshi Latimer 3063.20
Sergio Gutiérrez 2844.10
Dominique Perrier 2423.35
Daniel Tonini 1992.05
Liu Wong 1947.24
Patricio Simpson 1814.80
Elizabeth Brown 1719.10
Janine Labrune 1615.90
Helvetius Nagy 1571.20
Paolo Accorti 1545.70
Manuel Pereira 1488.70
Paul Henriot 1480.00
Alejandra Camino 1467.29
Ana Trujillo 1402.95
Eduardo Saavedra 836.70
Simon Crowther 649.00
Yoshi Tannamuri 522.50
John Steel 357.00
Francisco Chang 100.80
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Cookies       Do Not Sell       Licensing      
Made with    in Austin, Texas.  - vsn 44.0.0
© Data & Object Factory, LLC.