create table samolet (
  nomer_s int,
  tip_s varchar(25),
  mest_s int,
  s_s int,
  primary key (nomer_s)
 );
create table route (
  nomer_m int,
  distance_m int,
  departure varchar(25),
  destination varchar(25),
  primary key (nomer_m)
 );
 create table box_office (
  nomer_s int,
  nomer_m int,
  kollvo_prod_tickets int,
  dat_vrem_vilet datetime,
  dat_vrem_prilet datetime,
  primary key (nomer_m)
 );
insert into samolet values
  (1,'ТУ-154', 180, 950),
  (2,'Як-42', 120, 810),
  (3,'Як-40', 32, 550);
insert into route values
  (1, 1067, 'Чугуев','Мерефа'),
  (2, 2811, 'Новосибирск','Москва'),  
  (3, 635, 'Санкт-Петербург','Москва'),
  (4, 635, 'Москва','Санкт-Петербург'),
  (5, 1067, 'Чугуев','Мерефа'),
  (6, 1434, 'Новосибирск','Иркутск'),
  (7, 1067, 'Чугуев','Мерефа'),
  (870, 1179, 'Новосибирск','Братск');
 insert into box_office values
  (1,1, 180, '2021-04-01 15:30', '2021-04-01 17:45'),
  (1,5, 140, '2021-09-05 10:30', '2021-09-05 12:45'), 
  (1,7, 155, '2021-08-03 17:30', '2021-08-03 19:45'),
  (2,3, 40, '2021-04-07 13:25', '2021-04-07 14:45'),
  (3,4, 10, '2021-02-03 11:15', '2021-02-03 15:55'),
  (2,870, 100, '2010-12-31 14:35', '2010-12-31 17:35');