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	sekar	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	Dupa	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	yuka	Mantri	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

SQL Editor

Task: