CREATE TABLE Countries (
    name TEXT PRIMARY KEY,
    capital TEXT NOT NULL,
    area FLOAT,
    population INT,
    continent CHAR(2),
    currency CHAR(3) NOT NULL
);

DROP TABLE Countries;

INSERT INTO Countries VALUES ('Norway', 123456789, 'Oslo', 987654321, 'EU', 'EUR');

DELETE FROM Countries
WHERE continent = ’EU’;

UPDATE Countries
SET population = population + 1
WHERE name = 'Finland';

ALTER TABLE Countries
ADD Test varchar(255);

ALTER TABLE Countries
DROP COLUMN Currency;

SELECT Area, Capital FROM Countries;

SELECT * FROM Countries;

SELECT * FROM Countries WHERE continent = 'EU';

SELECT DISTINCT currency FROM Countries;

SELECT * FROM Countries WHERE name = "Sweden";

SELECT * FROM Countries WHERE continent <> ’EU’;

SELECT * FROM Countries WHERE population/area >= 80;

SELECT * FROM Countries WHERE continent = 'EU' AND
    NOT (currency = 'EUR');