Get your own SQL server

SQL Statement:

Result:

 customer_id |            customer_name             |     contact_name     |                    address                     |      city       | postal_code |   country
-------------+--------------------------------------+----------------------+------------------------------------------------+-----------------+-------------+-------------
           1 | Alfreds Futterkiste                  | Maria Anders         | Obere Str. 57                                  | Berlin          | 12209       | Germany
           2 | Ana Trujillo Emparedados y helados   | Ana Trujillo         | Avda. de la Constitucion 2222                  | Mexico D.F.     | 05021       | Mexico
           3 | Antonio Moreno Taquera               | Antonio Moreno       | Mataderos 2312                                 | Mexico D.F.     | 05023       | Mexico
           4 | Around the Horn                      | Thomas Hardy         | 120 Hanover Sq.                                | London          | WA1 1DP     | UK
           5 | Berglunds snabbkoep                  | Christina Berglund   | Berguvsvegen 8                                 | Lulea           | S-958 22    | Sweden
           6 | Blauer See Delikatessen              | Hanna Moos           | Forsterstr. 57                                 | Mannheim        | 68306       | Germany
           7 | Blondel pere et fils                 | Frederique Citeaux   | 24, place Kleber                               | Strasbourg      | 67000       | France
           8 | Bolido Comidas preparadas            | Martin Sommer        | C/ Araquil, 67                                 | Madrid          | 28023       | Spain
           9 | Bon app                              | Laurence Lebihans    | 12, rue des Bouchers                           | Marseille       | 13008       | France
          10 | Bottom-Dollar Marketse               | Elizabeth Lincoln    | 23 Tsawassen Blvd.                             | Tsawassen       | T2F 8M4     | Canada
          11 | Bs Beverages                         | Victoria Ashworth    | Fauntleroy Circus                              | London          | EC2 5NT     | UK
          12 | Cactus Comidas para llevar           | Patricio Simpson     | Cerrito 333                                    | Buenos Aires    | 1010        | Argentina
          13 | Centro comercial Moctezuma           | Francisco Chang      | Sierras de Granada 9993                        | Mexico D.F.     | 05022       | Mexico
          14 | Chop-suey Chinese                    | Yang Wang            | Hauptstr. 29                                   | Bern            | 3012        | Switzerland
          15 | Comercio Mineiro                     | Pedro Afonso         | Av. dos Lusiadas, 23                           | Sao Paulo       | 05432-043   | Brazil
          16 | Consolidated Holdings                | Elizabeth Brown      | Berkeley Gardens 12 Brewery                    | London          | WX1 6LT     | UK
          17 | Drachenblut Delikatessend            | Sven Ottlieb         | Walserweg 21                                   | Aachen          | 52066       | Germany
          18 | Du monde entier                      | Janine Labrune       | 67, rue des Cinquante Otages                   | Nantes          | 44000       | France
          19 | Eastern Connection                   | Ann Devon            | 35 King George                                 | London          | WX3 6FW     | UK
          20 | Ernst Handel                         | Roland Mendel        | Kirchgasse 6                                   | Graz            | 8010        | Austria
          21 | Familia Arquibaldo                   | Aria Cruz            | Rua Oros, 92                                   | Sao Paulo       | 05442-030   | Brazil
          22 | FISSA Fabrica Inter. Salchichas S.A. | Diego Roel           | C/ Moralzarzal, 86                             | Madrid          | 28034       | Spain
          23 | Folies gourmandes                    | Martine Rance        | 184, chaussee de Tournai                       | Lille           | 59000       | France
          24 | Folk och fe HB                       | Maria Larsson        | Akergatan 24                                   | Brecke          | S-844 67    | Sweden
          25 | Frankenversand                       | Peter Franken        | Berliner Platz 43                              | Munchen         | 80805       | Germany
          26 | France restauration                  | Carine Schmitt       | 54, rue Royale                                 | Nantes          | 44000       | France
          27 | Franchi S.p.A.                       | Paolo Accorti        | Via Monte Bianco 34                            | Torino          | 10100       | Italy
          28 | Furia Bacalhau e Frutos do Mar       | Lino Rodriguez       | Jardim das rosas n. 32                         | Lisboa          | 1675        | Portugal
          29 | Galeria del gastronomo               | Eduardo Saavedra     | Rambla de Cataluna, 23                         | Barcelona       | 08022       | Spain
          30 | Godos Cocina Tipica                  | Jose Pedro Freyre    | C/ Romero, 33                                  | Sevilla         | 41101       | Spain
          31 | Gourmet Lanchonetes                  | Andre Fonseca        | Av. Brasil, 442                                | Campinas        | 04876-786   | Brazil
          32 | Great Lakes Food Market              | Howard Snyder        | 2732 Baker Blvd.                               | Eugene          | 97403       | USA
          33 | GROSELLA-Restaurante                 | Manuel Pereira       | 5th Ave. Los Palos Grandes                     | Caracas         | 1081        | Venezuela
          34 | Hanari Carnes                        | Mario Pontes         | Rua do Paco, 67                                | Rio de Janeiro  | 05454-876   | Brazil
          35 | HILARION-Abastos                     | Carlos Hernandez     | Carrera 22 con Ave. Carlos Soublette #8-35     | San Cristobal   | 5022        | Venezuela
          36 | Hungry Coyote Import Store           | Yoshi Latimer        | City Center Plaza 516 Main St.                 | Elgin           | 97827       | USA
          37 | Hungry Owl All-Night Grocers         | Patricia McKenna     | 8 Johnstown Road                               | Cork            |             | Ireland
          38 | Island Trading                       | Helen Bennett        | Garden House Crowther Way                      | Cowes           | PO31 7PJ    | UK
          39 | Koniglich Essen                      | Philip Cramer        | Maubelstr. 90                                  | Brandenburg     | 14776       | Germany
          40 | La corne d abondance                 | Daniel Tonini        | 67, avenue de l Europe                         | Versailles      | 78000       | France
          41 | La maison d Asie                     | Annette Roulet       | 1 rue Alsace-Lorraine                          | Toulouse        | 31000       | France
          42 | Laughing Bacchus Wine Cellars        | Yoshi Tannamuri      | 1900 Oak St.                                   | Vancouver       | V3F 2K1     | Canada
          43 | Lazy K Kountry Store                 | John Steel           | 12 Orchestra Terrace                           | Walla Walla     | 99362       | USA
          44 | Lehmanns Marktstand                  | Renate Messner       | Magazinweg 7                                   | Frankfurt a.M.  | 60528       | Germany
          45 | Lets Stop N Shop                     | Jaime Yorres         | 87 Polk St. Suite 5                            | San Francisco   | 94117       | USA
          46 | LILA-Supermercado                    | Carlos Gonzalez      | Carrera 52 con Ave. Bolivar #65-98 Llano Largo | Barquisimeto    | 3508        | Venezuela
          47 | LINO-Delicateses                     | Felipe Izquierdo     | Ave. 5 de Mayo Porlamar                        | I. de Margarita | 4980        | Venezuela
          48 | Lonesome Pine Restaurant             | Fran Wilson          | 89 Chiaroscuro Rd.                             | Portland        | 97219       | USA
          49 | Magazzini Alimentari Riuniti         | Giovanni Rovelli     | Via Ludovico il Moro 22                        | Bergamo         | 24100       | Italy
          50 | Maison Dewey                         | Catherine Dewey      | Rue Joseph-Bens 532                            | Bruxelles       | B-1180      | Belgium
          51 | Mere Paillarde                       | Jean Fresniere       | 43 rue St. Laurent                             | Montreal        | H1J 1C3     | Canada
          52 | Morgenstern Gesundkost               | Alexander Feuer      | Heerstr. 22                                    | Leipzig         | 04179       | Germany
          53 | North/South                          | Simon Crowther       | South House 300 Queensbridge                   | London          | SW7 1RZ     | UK
          54 | Oceano Atlantico Ltda.               | Yvonne Moncada       | Ing. Gustavo Moncada 8585 Piso 20-A            | Buenos Aires    | 1010        | Argentina
          55 | Old World Delicatessen               | Rene Phillips        | 2743 Bering St.                                | Anchorage       | 99508       | USA
          56 | Ottilies Keseladen                   | Henriette Pfalzheim  | Mehrheimerstr. 369                             | Koln            | 50739       | Germany
          57 | Paris specialites                    | Marie Bertrand       | 265, boulevard Charonne                        | Paris           | 75012       | France
          58 | Pericles Comidas clasicas            | Guillermo Fernandez  | Calle Dr. Jorge Cash 321                       | Mexico D.F.     | 05033       | Mexico
          59 | Piccolo und mehr                     | Georg Pipps          | Geislweg 14                                    | Salzburg        | 5020        | Austria
          60 | Princesa Isabel Vinhoss              | Isabel de Castro     | Estrada da saude n. 58                         | Lisboa          | 1756        | Portugal
          61 | Que Delicia                          | Bernardo Batista     | Rua da Panificadora, 12                        | Rio de Janeiro  | 02389-673   | Brazil
          62 | Queen Cozinha                        | Lucia Carvalho       | Alameda dos Canarios, 891                      | Sao Paulo       | 05487-020   | Brazil
          63 | QUICK-Stop                           | Horst Kloss          | Taucherstrasse 10                              | Cunewalde       | 01307       | Germany
          64 | Rancho grande                        | Sergio Gutiarrez     | Av. del Libertador 900                         | Buenos Aires    | 1010        | Argentina
          65 | Rattlesnake Canyon Grocery           | Paula Wilson         | 2817 Milton Dr.                                | Albuquerque     | 87110       | USA
          66 | Reggiani Caseifici                   | Maurizio Moroni      | Strada Provinciale 124                         | Reggio Emilia   | 42100       | Italy
          67 | Ricardo Adocicados                   | Janete Limeira       | Av. Copacabana, 267                            | Rio de Janeiro  | 02389-890   | Brazil
          68 | Richter Supermarkt                   | Michael Holz         | Grenzacherweg 237                              | Genève          | 1203        | Switzerland
          69 | Romero y tomillo                     | Alejandra Camino     | Gran Via, 1                                    | Madrid          | 28001       | Spain
          70 | Santa Gourmet                        | Jonas Bergulfsen     | Erling Skakkes gate 78                         | Stavern         | 4110        | Norway
          71 | Save-a-lot Markets                   | Jose Pavarotti       | 187 Suffolk Ln.                                | Boise           | 83720       | USA
          72 | Seven Seas Imports                   | Hari Kumar           | 90 Wadhurst Rd.                                | London          | OX15 4NB    | UK
          73 | Simons bistro                        | Jytte Petersen       | Vinbeltet 34                                   | Kobenhavn       | 1734        | Denmark
          74 | Specialites du monde                 | Dominique Perrier    | 25, rue Lauriston                              | Paris           | 75016       | France
          75 | Split Rail Beer & Ale                | Art Braunschweiger   | P.O. Box 555                                   | Lander          | 82520       | USA
          76 | Supremes delices                     | Pascale Cartrain     | Boulevard Tirou, 255                           | Charleroi       | B-6000      | Belgium
          77 | The Big Cheese                       | Liz Nixon            | 89 Jefferson Way Suite 2                       | Portland        | 97201       | USA
          78 | The Cracker Box                      | Liu Wong             | 55 Grizzly Peak Rd.                            | Butte           | 59801       | USA
          79 | Toms Spezialiteten                   | Karin Josephs        | Luisenstr. 48                                  | Manster         | 44087       | Germany
          80 | Tortuga Restaurante                  | Miguel Angel Paolino | Avda. Azteca 123                               | Mexico D.F.     | 05033       | Mexico
          81 | Tradicao Hipermercados               | Anabela Domingues    | Av. Ines de Castro, 414                        | Sao Paulo       | 05634-030   | Brazil
          82 | Trails Head Gourmet Provisioners     | Helvetius Nagy       | 722 DaVinci Blvd.                              | Kirkland        | 98034       | USA
          83 | Vaffeljernet                         | Palle Ibsen          | Smagsloget 45                                  | Arhus           | 8200        | Denmark
          84 | Victuailles en stock                 | Mary Saveley         | 2, rue du Commerce                             | Lyon            | 69004       | France
          85 | Vins et alcools Chevalier            | Paul Henriot         | 59 rue de l Abbaye                             | Reims           | 51100       | France
          86 | Die Wandernde Kuh                    | Rita Moller          | Adenauerallee 900                              | Stuttgart       | 70563       | Germany
          87 | Wartian Herkku                       | Pirkko Koskitalo     | Torikatu 38                                    | Oulu            | 90110       | Finland
          88 | Wellington Importadora               | Paula Parente        | Rua do Mercado, 12                             | Resende         | 08737-363   | Brazil
          89 | White Clover Markets                 | Karl Jablonski       | 305 - 14th Ave. S. Suite 3B                    | Seattle         | 98128       | USA
          90 | Wilman Kala                          | Matti Karttunen      | Keskuskatu 45                                  | Helsinki        | 21240       | Finland
          91 | Wolski                               | Zbyszek              | ul. Filtrowa 68                                | Walla           | 01-012      | Poland
(91 rows)
Demo Database:

categories
customers
products
orders
order_details
testproducts