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	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

SQL Right Join Group By Example

Task: