Task:

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.
Click here for details on Right Join.
 
 91 Records
Id Firstname LastName Orders
1 Binod Mantri 0
3 kraków kraków 0
6 Moos Moos 0
7 Citeaux Citeaux 0
8 Sommer Sommer 0
10 Lincoln Lincoln 0
12 Simpson Simpson 0
13 Chang Chang 0
15 Afonso Afonso 0
18 Labrune Labrune 0
19 Black Devon 0
21 Cruz Cruz 0
22 Roel Roel 0
23 Rancé Rancé 0
24 Larsson Larsson 0
25 Franken Franken 0
26 Schmitt Schmitt 0
27 Accorti Accorti 0
28 Rodriguez Rodriguez 0
29 Saavedra Saavedra 0
30 Pedro Freyre Pedro Freyre 0
31 Fonseca Fonseca 0
32 Snyder Snyder 0
33 Pereira Pereira 0
37 McKenna McKenna 0
40 Tonini Tonini 0
43 Steel Steel 0
44 Messner Messner 0
45 Yorres Yorres 0
47 Izquierdo Izquierdo 0
48 Wilson Wilson 0
49 Rovelli Rovelli 0
50 Dewey Dewey 0
51 Fresnière Fresnière 0
53 Black Crowther 0
55 Phillips Phillips 0
57 Bertrand Bertrand 0
58 Fernández Fernández 0
59 Pipps Pipps 0
60 de Castro de Castro 0
62 Carvalho Carvalho 0
64 Gutiérrez Gutiérrez 0
72 Black Kumar 0
73 Petersen Petersen 0
74 Perrier Perrier 0
75 Braunschweiger Braunschweiger 0
76 Cartrain Cartrain 0
77 Nixon Nixon 0
78 Wong Wong 0
79 Josephs Josephs 0
66 Moroni Moroni 0
69 Camino Camino 0
70 Bergulfsen Bergulfsen 0
81 Domingues Domingues 0
82 Nagy Nagy 0
83 Ibsen Ibsen 0
84 Saveley Saveley 0
86 Müller Müller 0
89 Jablonski Jablonski 0
90 Karttunen Karttunen 0
91 Piestrzeniewicz Piestrzeniewicz 0
36 Latimer Latimer 1
88 Parente Parente 1
85 Henriot Henriot 1
67 Limeira Limeira 1
68 Holz Holz 1
80 Angel Paolino Angel Paolino 1
65 Wilson Wilson 1
61 Batista Batista 1
56 Pfalzheim Pfalzheim 1
54 Moncada Moncada 1
52 Feuer Feuer 1
46 González González 1
41 Roulet Roulet 1
42 Tannamuri Tannamuri 1
38 Black Bennett 1
34 Pontes Pontes 1
16 Black Brown 1
14 Wang Wang 1
9 Lebihan Lebihan 1
4 jhon Hardy 1
5 Berglund Berglund 1
2 clovis Trujillo 1
11 muter Ashworth 2
17 Ottlieb Ottlieb 2
20 Mendel Mendel 2
35 Hernández Hernández 2
39 Cramer Cramer 2
63 Kloss Kloss 2
87 Koskitalo Koskitalo 2
71 Pavarotti 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.3.0