-- Question 1

CREATE TABLE Countries (
  id TEXT COUNTRY_ID,
  name TEXT COUNTRY_NAME,
  region INT REGION_ID
);
describe Countries

-- insert some values
INSERT INTO Countries VALUES ('CA', 'Canada', 2);
INSERT INTO Countries VALUES ('DE', 'Germany', 1);
INSERT INTO Countries VALUES ('UK', 'United Kingdom', 1);
INSERT INTO Countries VALUES ('US', 'United States of America', 2);

-- fetch some values
SELECT * FROM Countries;