text: create table Olympics (
  	olympic_id char(7) unique,
  	country_id char(3),
  	city char(50),
  	year integer,
  	startdate date,
  	enddate date,
  	foreign key (country_id) references Countries(country_id)
  );
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Philippines', 'PH', '', 2110564835, '4/8/1924', '1/15/1974');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Bosnia and Herzegovina', 'BA', '', 1643887084, '5/7/1908', '2/28/1929');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('China', 'CN', '', 4835468558, '2/18/1931', '8/9/2007');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('France', 'FR', '', 4470220084, '12/4/1949', '11/7/1948');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Peru', 'PE', '', 6841120952, '3/28/1984', '7/12/2017');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Mexico', 'MX', '', 1834862966, '9/10/1936', '11/16/1973');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('China', 'CN', '', 3388315270, '11/30/2018', '7/3/1924');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('United States', 'US', '', 6891556620, '1/21/1950', '10/15/1998');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Philippines', 'PH', '', 4626443934, '11/29/1999', '1/12/1935');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Russia', 'RU', '', 5650066141, '1/13/1954', '8/24/1985');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Brazil', 'BR', '', 4700449700, '6/24/1979', '11/18/1907');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Malaysia', 'MY', '', 6193927498, '3/25/1991', '1/15/1947');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Portugal', 'PT', '', 5779163594, '11/3/1945', '2/27/1905');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Czech Republic', 'CZ', '', 5700414824, '7/31/2005', '9/7/1909');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('China', 'CN', '', 6207785168, '3/27/1929', '5/13/1940');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Bangladesh', 'BD', '', 1862696943, '1/6/1951', '4/6/1922');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Cuba', 'CU', '', 868936808, '7/6/1930', '8/8/1911');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Russia', 'RU', '', 1619405319, '1/7/2015', '5/20/1902');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Portugal', 'PT', '', 5338384069, '5/6/2011', '11/8/1935');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('United States', 'US', '', 3869663375, '8/5/1984', '2/20/1974');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Argentina', 'AR', '', 5367442505, '9/2/1939', '8/26/1994');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('South Sudan', 'SS', '', 5406916761, '7/19/1970', '3/26/1953');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Ireland', 'IE', '', 4328723185, '6/16/1968', '7/25/1992');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Brazil', 'BR', '', 2188417759, '6/3/1959', '7/24/1963');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Norway', 'NO', '', 6377216652, '3/28/2019', '4/8/1934');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Ukraine', 'UA', '', 4440160426, '1/1/1966', '8/28/1981');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('China', 'CN', '', 6337955271, '10/15/1975', '12/14/1953');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Indonesia', 'ID', '', 280822074, '7/23/1967', '1/24/2017');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Japan', 'JP', '', 4887301499, '12/30/2012', '11/30/1971');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Thailand', 'TH', '', 5688712320, '11/18/2018', '8/14/1916');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Dominican Republic', 'DO', '', 4579576332, '1/26/1909', '2/10/1945');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Brazil', 'BR', '', 955692371, '11/28/1948', '9/22/1995');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('China', 'CN', '', 5735287085, '10/27/2000', '9/16/2019');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Philippines', 'PH', '', 872652786, '3/16/1973', '5/30/2010');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Indonesia', 'ID', '', 5129477355, '5/27/1952', '4/1/1998');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Russia', 'RU', '', 3861207078, '9/13/2005', '8/2/1963');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Russia', 'RU', '', 4983009391, '4/22/1991', '11/16/1994');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Portugal', 'PT', '', 6335279355, '11/27/1993', '9/30/1970');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('China', 'CN', '', 21859740, '6/2/1941', '12/15/1908');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Indonesia', 'ID', '', 5338765322, '3/20/1944', '2/5/1922');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Colombia', 'CO', '', 585336128, '8/11/1940', '10/23/1926');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Equatorial Guinea', 'GQ', '', 1366994394, '2/19/2006', '4/9/1983');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Indonesia', 'ID', '', 2923776380, '6/12/1956', '6/6/1987');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Indonesia', 'ID', '', 5801829914, '11/14/1950', '1/15/1981');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('China', 'CN', '', 6322504824, '3/11/2005', '11/13/1974');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('South Korea', 'KR', '', 1380157189, '2/12/1984', '8/24/1953');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Ukraine', 'UA', '', 3264245576, '3/12/1937', '9/9/1956');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Palestinian Territory', 'PS', '', 6759963269, '8/11/1990', '2/27/2005');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Poland', 'PL', '', 5935375070, '10/31/1961', '7/2/1959');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Indonesia', 'ID', '', 2185145706, '11/26/1940', '8/27/1915');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Portugal', 'PT', '', 748607744, '3/15/2014', '8/18/1975');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('China', 'CN', '', 1994031667, '9/4/1934', '8/13/2010');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Indonesia', 'ID', '', 5221643751, '3/14/1925', '5/19/2010');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Mongolia', 'MN', '', 6753158236, '4/9/1916', '9/15/1939');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('China', 'CN', '', 434358021, '8/5/2020', '3/16/1946');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Peru', 'PE', '', 4798976720, '8/20/1950', '9/7/2008');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Russia', 'RU', '', 5435230534, '2/14/1931', '10/23/1926');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Brazil', 'BR', '', 1968620743, '9/15/1900', '7/8/1924');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Cuba', 'CU', '', 4805963761, '1/11/1984', '8/5/1936');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Indonesia', 'ID', '', 2113271268, '8/7/1986', '1/18/1972');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Indonesia', 'ID', '', 5144948745, '7/20/1981', '11/2/1989');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('United States', 'US', '', 894844369, '10/22/1956', '7/24/1962');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Brazil', 'BR', '', 2338597981, '10/13/1902', '9/25/2004');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('China', 'CN', '', 395385870, '9/3/1966', '4/23/1902');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Portugal', 'PT', '', 6588119833, '7/14/1927', '4/12/1978');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('China', 'CN', '', 5605784370, '9/28/1910', '1/17/1925');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Japan', 'JP', '', 4506358487, '8/23/2000', '7/5/1922');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Colombia', 'CO', '', 5463493950, '1/3/1991', '5/29/1904');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('South Korea', 'KR', '', 5261962063, '2/21/1976', '6/5/2010');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Albania', 'AL', '', 4795496623, '3/18/2003', '10/9/1925');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Indonesia', 'ID', '', 726441539, '5/9/1906', '5/5/1995');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Mexico', 'MX', '', 4110030013, '3/7/2000', '8/27/1934');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Jamaica', 'JM', '', 1461232062, '3/21/1982', '7/5/1988');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Indonesia', 'ID', '', 6272119770, '5/18/1949', '12/9/1965');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('United Kingdom', 'GB', '', 78216192, '4/11/1997', '7/15/1977');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Lithuania', 'LT', '', 5663779939, '3/9/1972', '5/9/1926');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Ghana', 'GH', '', 4608433699, '2/21/1934', '3/8/1928');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('China', 'CN', '', 3682105835, '9/27/2006', '6/3/1976');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Portugal', 'PT', '', 5511496488, '8/21/2015', '1/23/1945');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Netherlands', 'NL', '', 1589729610, '1/4/2011', '12/8/1949');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('China', 'CN', '', 2698878999, '11/4/2013', '7/11/1928');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Chad', 'TD', '', 4214905995, '3/20/2001', '6/21/1951');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('United States', 'US', '', 742161026, '3/10/1969', '7/24/1933');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Vanuatu', 'VU', '', 1294385556, '11/1/1992', '7/8/1915');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Mexico', 'MX', '', 1664034861, '8/28/1918', '4/16/1901');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Brazil', 'BR', '', 5159288204, '6/26/1974', '11/24/1918');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Brazil', 'BR', '', 6371227426, '3/28/1966', '8/2/1964');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Ukraine', 'UA', '', 5738420664, '6/11/1935', '8/1/1905');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Sweden', 'SE', '', 1393511974, '7/5/1991', '3/13/2020');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Honduras', 'HN', '', 3981200123, '12/12/1968', '6/29/1914');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Russia', 'RU', '', 2148937032, '3/17/1918', '9/20/1901');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Portugal', 'PT', '', 5785611899, '10/17/1954', '2/13/1992');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Peru', 'PE', '', 4811053631, '4/4/1941', '7/11/1996');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Canada', 'CA', '', 3999134236, '5/3/1996', '9/2/1959');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Botswana', 'BW', '', 5864576348, '7/24/2007', '4/13/1920');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('China', 'CN', '', 1457833192, '10/11/1965', '1/16/1912');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Serbia', 'RS', '', 5366870307, '12/9/1944', '10/17/2013');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Bosnia and Herzegovina', 'BA', '', 1801427162, '5/22/1923', '1/12/1901');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Botswana', 'BW', '', 4841618857, '8/20/1965', '5/26/2008');
  insert into Olympics (olympic_id, country_id, city, year, startdate, enddate) values ('Sweden', 'SE', '', 4053691112, '8/24/2008', '9/16/1936');
  