drop table  students;

create table  students ( 
  name     varchar(32)  not null, 
  city     varchar(16)  not null, 
  country  varchar(16)  not null ); 

desc students; 

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

select * from students; 

commit;