michaelsattler

SQL 2019_most_visited_cities_in_millions

Jun 10th, 2021
510
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.91 KB | None | 0 0
  1. CREATE TABLE 2019_most_visited_cities_in_millions (
  2.     POSITION INT,
  3.     city VARCHAR(33),
  4.     country VARCHAR(33),
  5.     visitors FLOAT ) ;
  6. INSERT INTO
  7.     2019_most_visited_cities_in_millions
  8. VALUES
  9.     ( 1, "Bangkok", "Thailand", 22.78 ),
  10.     ( 2, "Paris", "France", 19.1 ),
  11.     ( 3, "London", "England", 19.09 ),
  12.     ( 4, "Dubai", "United Arab Emirates", 15.93 ),
  13.     ( 5, "Singapore", "Singapore", 14.67 ),
  14.     ( 6, "Kuala Lumpur", "Malaysia", 13.79 ),
  15.     ( 7, "New York City", "USA", 13.6 ),
  16.     ( 8, "Istanbul", "Turkey", 13.4 ),
  17.     ( 9, "Tokyo", "Japan", 12.93 ),
  18.     ( 10, "Antalya", "Turkey", 12.41 ),
  19.     ( 11, "Seoul", "South Korea", 11.25 ),
  20.     ( 12, "Osaka", "Japan", 10.14 ),
  21.     ( 13, "Mecca", "Saudi Arabia", 10 ),
  22.     ( 14, "Phuket", "Thailand", 9.89 ),
  23.     ( 15, "Pattaya", "Thailand", 9.44 ),
  24.     ( 16, "Milan", "Italy", 9.10 ),
  25.     ( 17, "Barcelona", "Spain", 9.09 ),
  26.     ( 18, "Palma de Mallorca", "Spain", 8.96 ),
  27.     ( 19, "Bali", "Indonesia", 8.26 );
Advertisement
Add Comment
Please, Sign In to add comment