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.
 
 90 Records
Id Firstname LastName Orders
27 Paolo Accorti 0
15 Pedro Afonso 0
1 Oscar Anders 0
80 Miguel Angel Paolino 0
11 Victoria Ashworth 0
61 Bernardo Batista 0
38 Helen Bennett 0
5 Christina Berglund 0
70 Jonas Bergulfsen 0
75 Art Braunschweiger 0
16 Elizabeth Brown 0
69 Alejandra Camino 0
76 Pascale Cartrain 0
62 Lúcia Carvalho 0
13 Francisco Chang 0
7 Frédérique Citeaux 0
39 Philip Cramer 0
53 Simon Crowther 0
21 Aria Cruz 0
60 Isabel de Castro 0
19 Ann Devon 0
50 Catherine Dewey 0
81 Anabela Domingues 0
58 Guillermo Fernández 0
52 Alexander Feuer 0
31 André Fonseca 0
25 Peter Franken 0
51 Jean Fresnière 0
46 Carlos González 0
64 Sergio Gutiérrez 0
4 Thomas Hardy 0
85 Paul Henriot 0
35 Carlos Hernández 0
68 Michael Holz 0
83 Palle Ibsen 0
47 Felipe Izquierdo 0
89 Karl Jablonski 0
79 Karin Josephs 0
90 Matti Karttunen 0
63 Horst Kloss 0
87 Pirkko Koskitalo 0
72 Hari Kumar 0
18 Janine Labrune 0
24 TEST Larsson 0
36 Yoshi Latimer 0
9 Laurence Lebihan 0
67 Janete Limeira 0
10 Elizabeth Lincoln 0
37 Patricia McKenna 0
20 Roland Mendel 0
44 Renate Messner 0
54 Yvonne Moncada 0
6 Hanna Moos 0
3 lol Moreno 0
66 Maurizio Moroni 0
86 Rita Müller 0
82 Helvetius Nagy 0
77 Liz Nixon 0
17 Sven Ottlieb 0
88 Paula Parente 0
71 Jose Pavarotti 0
30 José Pedro Freyre 0
33 Manuel Pereira 0
74 Dominique Perrier 0
73 Jytte Petersen 0
56 Henriette Pfalzheim 0
55 Rene Phillips 0
91 Zbyszek Piestrzeniewicz 0
59 Georg Pipps 0
34 Mario Pontes 0
23 Martine Rancé 0
28 Lino Rodriguez 0
22 Diego Roel 0
41 Annette Roulet 0
49 Giovanni Rovelli 0
29 Eduardo Saavedra 0
84 Mary Saveley 0
26 Carine Schmitt 0
12 Patricio Simpson 0
32 Howard Snyder 0
8 Martín Sommer 0
43 John Steel 0
42 Yoshi Tannamuri 0
40 Daniel Tonini 0
2 ERWIN Trujillo 0
14 Yang Wang 0
48 Fran Wilson 0
65 Paula Wilson 0
78 Liu Wong 0
45 Jaime Yorres 0
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