drop table people;

create table people (
id int primary key,
name char( 50 ),
city char( 30 ),
birthday date
);


-- This is just needed for LocalSql:

-- create index people_idx_1 on people( name );
-- create index people_idx_2 on people( city );
-- create index people_idx_3 on people( birthday );


insert into people values( 1, 'Alexander', 'Paris', '1971-11-03' );
insert into people values( 2, 'Johannes', 'Paris', '1968-03-06' );
insert into people values( 3, 'Martin', 'New York', '1923-09-22' );
insert into people values( 4, 'Matthias', 'Los Angeles', '1932-01-14' );
insert into people values( 5, 'Andreas', 'Santa Fe', '1958-12-03' );
insert into people values( 6, 'Hugo', 'Oslo', '1961-06-19' );
insert into people values( 7, 'Theodor', 'Nice', '1972-07-23' );
insert into people values( 8, 'Egon', 'Berlin', '1975-08-01' );
insert into people values( 9, 'Helmut', 'London', '1980-03-03' );
insert into people values( 10, 'Franz', 'Vienna', '1940-11-07' );
insert into people values( 11, 'Markus', 'Berne', '1964-12-06' );
insert into people values( 12, 'Tim', 'Madrid', '1979-08-27' );
insert into people values( 13, 'Josef', 'Munich', '1963-04-17' );