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