DROP TABLE IF EXISTS student3;

CREATE TABLE student3 ( 
  name     VARCHAR(32) PRIMARY KEY, 
  city     VARCHAR(16) NOT NULL, 
  country  VARCHAR(16) NOT NULL );

INSERT INTO student3 VALUES ( 'Alfreds Futterkiste', 'Berlin', 'Germany' ); 
INSERT INTO student3 VALUES ( 'Berglunds snabbköp', 'Luleå', 'Sweden' ); 
INSERT INTO student3 VALUES ( 'Centro comercial Moctezuma', 'México D.F.', 'Mexico' );
INSERT INTO student3 VALUES ( 'Ernst Handel', 'Graz', 'Austria' ); 
INSERT INTO student3 VALUES ( 'FISSA Fabrica Inter. Salchichas', 'Madrid', 'Spain' );
INSERT INTO student3 VALUES ( 'Galería del gastrónomo', 'Barcelona', 'Spain' );
INSERT INTO student3 VALUES ( 'Island Trading', 'Cowes', 'UK' );
INSERT INTO student3 VALUES ( 'Königlich Essen', 'Brandenburg', 'Germany' );
INSERT INTO student3 VALUES ( 'Laughing Bacchus Wine Cellars', 'Vancouver', 'Canada' );
INSERT INTO student3 VALUES ( 'Magazzini Alimentari Riuniti', 'Bergamo', 'Italy' );
INSERT INTO student3 VALUES ( 'North/South', 'London', 'UK' );
INSERT INTO student3 VALUES ( 'Paris spécialités', 'Paris', 'France' );
INSERT INTO student3 VALUES ( 'Rattlesnake Canyon Grocery', 'Albuquerque', 'USA' );
INSERT INTO student3 VALUES ( 'Simons bistro', 'København', 'Denmark' );
INSERT INTO student3 VALUES ( 'The Big Cheese', 'Portland', 'USA' );
INSERT INTO student3 VALUES ( 'Vaffeljernet', 'Arhus', 'Denmark' );
INSERT INTO student3 VALUES ( 'Wolski Zajazd', 'Warszawa', 'Poland' );