Right Join Group By.

List all customers -- with or without orders -- and a count of the orders that include a '2kg box with Konbu' (product with Id = 13). Order the results by number of orders.
 
 91 Records
Id Firstname LastName Orders
1 Maria Anders 0
3 Antonio Moreno 0
6 Hanna Moos 0
7 Frédérique Citeaux 0
8 Martín Sommer 0
10 Elizabeth Lincoln 0
12 Patricio Simpson 0
13 Francisco Chang 0
15 Pedro Afonso 0
18 Janine Labrune 0
19 Ann Devon 0
21 Aria Cruz 0
22 Diego Roel 0
23 Martine Rancé 0
24 Maria Larsson 0
25 Peter Franken 0
26 Carine Schmitt 0
27 Paolo Accorti 0
28 Lino Rodriguez 0
29 Eduardo Saavedra 0
30 José Pedro Freyre 0
31 André Fonseca 0
32 Howard Snyder 0
33 Manuel Pereira 0
37 Patricia McKenna 0
40 Daniel Tonini 0
43 John Steel 0
44 Renate Messner 0
45 Jaime Yorres 0
47 Felipe Izquierdo 0
48 Fran Wilson 0
49 Giovanni Rovelli 0
50 Catherine Dewey 0
51 Jean Fresnière 0
53 Simon Crowther 0
55 Rene Phillips 0
57 Marie Bertrand 0
58 Guillermo Fernández 0
59 Georg Pipps 0
60 Isabel de Castro 0
62 Lúcia Carvalho 0
64 Sergio Gutiérrez 0
72 Hari Kumar 0
73 Jytte Petersen 0
74 Dominique Perrier 0
75 Art Braunschweiger 0
76 Pascale Cartrain 0
77 Liz Nixon 0
78 Liu Wong 0
79 Karin Josephs 0
66 Maurizio Moroni 0
69 Alejandra Camino 0
70 Jonas Bergulfsen 0
81 Anabela Domingues 0
82 Helvetius Nagy 0
83 Palle Ibsen 0
84 Mary Saveley 0
86 Rita Müller 0
89 Karl Jablonski 0
90 Matti Karttunen 0
91 Zbyszek Piestrzeniewicz 0
36 Yoshi Latimer 1
88 Paula Parente 1
85 Paul Henriot 1
67 Janete Limeira 1
68 Michael Holz 1
80 Miguel Angel Paolino 1
65 Paula Wilson 1
61 Bernardo Batista 1
56 Henriette Pfalzheim 1
54 Yvonne Moncada 1
52 Alexander Feuer 1
46 Carlos González 1
41 Annette Roulet 1
42 Yoshi Tannamuri 1
38 Helen Bennett 1
34 Mario Pontes 1
16 Elizabeth Brown 1
14 Yang Wang 1
9 Laurence Lebihan 1
4 Thomas Hardy 1
5 Christina Berglund 1
2 Ana Trujillo 1
11 Victoria Ashworth 2
17 Sven Ottlieb 2
20 Roland Mendel 2
35 Carlos Hernández 2
39 Philip Cramer 2
63 Horst Kloss 2
87 Pirkko Koskitalo 2
71 Jose Pavarotti 4
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Licensing       EULA       Sitemap      
© Data & Object Factory, LLC.
Made with    in Austin, Texas.      Vsn 1.2.2