1. Retrieve the customer names and contact information of all customers who have placed an order. |
---|
2. List all customers and its ordered products with its price and quantity from the country Sweden. |
---|
3. List all customers that have ordered Tofu product. |
---|
4. List all products ordered by customers from Switzerland. |
---|
5. Identify the customers who have not placed any orders. |
---|
Customer ID | Customer Name | Contact Name | City | Actions |
---|---|---|---|---|
1 | Alfreds Futterkiste | Maria Anders | Berlin | View Cart |
2 | Ana Trujillo Emparedados y helados | Ana Trujillo | M?xico D.F. | View Cart |
3 | Antonio Moreno Taquer?a | Antonio Moreno | M?xico D.F. | View Cart |
4 | Around the Horn | Thomas Hardy | London | View Cart |
5 | Berglunds snabbk?p | Christina Berglund | Lule? | View Cart |
6 | Blauer See Delikatessen | Hanna Moos | Mannheim | View Cart |
7 | Blondel p?re et fils | Fr?d?rique Citeaux | Strasbourg | View Cart |
8 | B?lido Comidas preparadas | Mart?n Sommer | Madrid | View Cart |
9 | Bon app' | Laurence Lebihans | Marseille | View Cart |
10 | Bottom-Dollar Marketse | Elizabeth Lincoln | Tsawassen | View Cart |
11 | B's Beverages | Victoria Ashworth | London | View Cart |
12 | Cactus Comidas para llevar | Patricio Simpson | Buenos Aires | View Cart |
13 | Centro comercial Moctezuma | Francisco Chang | M?xico D.F. | View Cart |
14 | Chop-suey Chinese | Yang Wang | Bern | View Cart |
15 | Com?rcio Mineiro | Pedro Afonso | S?o Paulo | View Cart |
16 | Consolidated Holdings | Elizabeth Brown | London | View Cart |
17 | Drachenblut Delikatessend | Sven Ottlieb | Aachen | View Cart |
18 | Du monde entier | Janine Labrune | Nantes | View Cart |
19 | Eastern Connection | Ann Devon | London | View Cart |
20 | Ernst Handel | Roland Mendel | Graz | View Cart |
21 | Familia Arquibaldo | Aria Cruz | S?o Paulo | View Cart |
22 | FISSA Fabrica Inter. Salchichas S.A. | Diego Roel | Madrid | View Cart |
23 | Folies gourmandes | Martine Ranc? | Lille | View Cart |
24 | Folk och f? HB | Maria Larsson | Br?cke | View Cart |
25 | Frankenversand | Peter Franken | M?nchen | View Cart |
26 | France restauration | Carine Schmitt | Nantes | View Cart |
27 | Franchi S.p.A. | Paolo Accorti | Torino | View Cart |
28 | Furia Bacalhau e Frutos do Mar | Lino Rodriguez | Lisboa | View Cart |
29 | Galer?a del gastr?nomo | Eduardo Saavedra | Barcelona | View Cart |
30 | Godos Cocina T?pica | Jos? Pedro Freyre | Sevilla | View Cart |
31 | Gourmet Lanchonetes | Andr? Fonseca | Campinas | View Cart |
32 | Great Lakes Food Market | Howard Snyder | Eugene | View Cart |
33 | GROSELLA-Restaurante | Manuel Pereira | Caracas | View Cart |
34 | Hanari Carnes | Mario Pontes | Rio de Janeiro | View Cart |
35 | HILARI?N-Abastos | Carlos Hern?ndez | San Crist?bal | View Cart |
36 | Hungry Coyote Import Store | Yoshi Latimer | Elgin | View Cart |
37 | Hungry Owl All-Night Grocers | Patricia McKenna | Cork | View Cart |
38 | Island Trading | Helen Bennett | Cowes | View Cart |
39 | K?niglich Essen | Philip Cramer | Brandenburg | View Cart |
40 | La corne d'abondance | Daniel Tonini | Versailles | View Cart |
41 | La maison d'Asie | Annette Roulet | Toulouse | View Cart |
42 | Laughing Bacchus Wine Cellars | Yoshi Tannamuri | Vancouver | View Cart |
43 | Lazy K Kountry Store | John Steel | Walla Walla | View Cart |
44 | Lehmanns Marktstand | Renate Messner | Frankfurt a.M. | View Cart |
45 | Let's Stop N Shop | Jaime Yorres | San Francisco | View Cart |
46 | LILA-Supermercado | Carlos Gonz?lez | Barquisimeto | View Cart |
47 | LINO-Delicateses | Felipe Izquierdo | I. de Margarita | View Cart |
48 | Lonesome Pine Restaurant | Fran Wilson | Portland | View Cart |
49 | Magazzini Alimentari Riuniti | Giovanni Rovelli | Bergamo | View Cart |
50 | Maison Dewey | Catherine Dewey | Bruxelles | View Cart |
51 | M?re Paillarde | Jean Fresni?re | Montr?al | View Cart |
52 | Morgenstern Gesundkost | Alexander Feuer | Leipzig | View Cart |
53 | North/South | Simon Crowther | London | View Cart |
54 | Oc?ano Atl?ntico Ltda. | Yvonne Moncada | Buenos Aires | View Cart |
55 | Old World Delicatessen | Rene Phillips | Anchorage | View Cart |
56 | Ottilies K?seladen | Henriette Pfalzheim | K?ln | View Cart |
57 | Paris sp?cialit?s | Marie Bertrand | Paris | View Cart |
58 | Pericles Comidas cl?sicas | Guillermo Fern?ndez | M?xico D.F. | View Cart |
59 | Piccolo und mehr | Georg Pipps | Salzburg | View Cart |
60 | Princesa Isabel Vinhoss | Isabel de Castro | Lisboa | View Cart |
61 | Que Del?cia | Bernardo Batista | Rio de Janeiro | View Cart |
62 | Queen Cozinha | L?cia Carvalho | S?o Paulo | View Cart |
63 | QUICK-Stop | Horst Kloss | Cunewalde | View Cart |
64 | Rancho grande | Sergio Guti?rrez | Buenos Aires | View Cart |
65 | Rattlesnake Canyon Grocery | Paula Wilson | Albuquerque | View Cart |
66 | Reggiani Caseifici | Maurizio Moroni | Reggio Emilia | View Cart |
67 | Ricardo Adocicados | Janete Limeira | Rio de Janeiro | View Cart |
68 | Richter Supermarkt | Michael Holz | Gen?ve | View Cart |
69 | Romero y tomillo | Alejandra Camino | Madrid | View Cart |
70 | Sant? Gourmet | Jonas Bergulfsen | Stavern | View Cart |
71 | Save-a-lot Markets | Jose Pavarotti | Boise | View Cart |
72 | Seven Seas Imports | Hari Kumar | London | View Cart |
73 | Simons bistro | Jytte Petersen | K?benhavn | View Cart |
74 | Sp?cialit?s du monde | Dominique Perrier | Paris | View Cart |
75 | Split Rail Beer & Ale | Art Braunschweiger | Lander | View Cart |
76 | Supr?mes d?lices | Pascale Cartrain | Charleroi | View Cart |
77 | The Big Cheese | Liz Nixon | Portland | View Cart |
78 | The Cracker Box | Liu Wong | Butte | View Cart |
79 | Toms Spezialit?ten | Karin Josephs | M?nster | View Cart |
80 | Tortuga Restaurante | Miguel Angel Paolino | M?xico D.F. | View Cart |
81 | Tradi??o Hipermercados | Anabela Domingues | S?o Paulo | View Cart |
82 | Trail's Head Gourmet Provisioners | Helvetius Nagy | Kirkland | View Cart |
83 | Vaffeljernet | Palle Ibsen | ?rhus | View Cart |
84 | Victuailles en stock | Mary Saveley | Lyon | View Cart |
85 | Vins et alcools Chevalier | Paul Henriot | Reims | View Cart |
86 | Die Wandernde Kuh | Rita M?ller | Stuttgart | View Cart |
87 | Wartian Herkku | Pirkko Koskitalo | Oulu | View Cart |
88 | Wellington Importadora | Paula Parente | Resende | View Cart |
89 | White Clover Markets | Karl Jablonski | Seattle | View Cart |
90 | Wilman Kala | Matti Karttunen | Helsinki | View Cart |
91 | Wolski | Zbyszek | Walla | View Cart |