-- create a table
CREATE TABLE customer (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  country TEXT NOT NULL
);
-- insert some values
INSERT INTO customer VALUES (1, 'Ryan', 'America');
INSERT INTO customer VALUES (2, 'Joanna', 'France');
INSERT INTO customer VALUES (3, 'Tom', 'United Kindom');
INSERT INTO customer VALUES (4,  'Ron', 'India');
INSERT INTO customer VALUES (5,  'Jerry','Itly');
INSERT INTO customer VALUES (6,  'Spike', 'Germany');
INSERT INTO customer VALUES (7,  'Harry', 'Rome');
-- fetch some values  
SELECT * FROM customer ORDER BY country;