Advertisement
Guest User

Untitled

a guest
Jun 5th, 2019
34
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.68 KB | None | 0 0
  1. CREATE TABLE flights
  2. (
  3.     from_city VARCHAR(50) NOT NULL,
  4.     to_city   VARCHAR(50) NOT NULL,
  5.     duration  INT         NOT NULL
  6. );
  7.  
  8.  
  9. INSERT INTO flights
  10.     ( from_city, to_city, duration )
  11.     VALUES
  12.         ( 'kharkiv', 'istanbul', 120 )
  13.       ,
  14.         ( 'kharkiv', 'kyiv', 60 )
  15.       ,
  16.         ( 'kharkiv', 'lviv', 90 )
  17.       ,
  18.         ( 'kyiv', 'kharkiv', 30 )
  19.       ,
  20.         ( 'kyiv', 'lviv', 40 )
  21.       ,
  22.         ( 'lviv', 'vancouver', 1500 )
  23.       ,
  24.         ( 'kyiv', 'vancouver', 1400 )      ,
  25.         ( 'istanbul', 'vancouver', 700 )
  26.       -- extra test cases, not part of original task
  27.       , ( 'kyiv', 'plovdiv', 30 )
  28.       , ( 'plovdiv', 'istanbul', 20 )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement