Occupations

Input Format

The OCCUPATIONS table is described as follows: Occupation will only contain one of the following values: Doctor, Professor, Singer or Actor.

CREATE TABLE IF NOT EXISTS occupations (
	name TEXT,
	occupation TEXT);

INSERT INTO occupations VALUES ('Ashley', 'Professor');
INSERT INTO occupations VALUES ('Samantha', 'Actor');
INSERT INTO occupations VALUES ('Julia', 'Doctor');
INSERT INTO occupations VALUES ('Britney', 'Professor');
INSERT INTO occupations VALUES ('Maria', 'Professor');
INSERT INTO occupations VALUES ('Meera', 'Professor');
INSERT INTO occupations VALUES ('Priya', 'Doctor');
INSERT INTO occupations VALUES ('Priyanka', 'Professor');
INSERT INTO occupations VALUES ('Jennifer', 'Actor');
INSERT INTO occupations VALUES ('Ketty', 'Actor');
INSERT INTO occupations VALUES ('Belvet', 'Professor');
INSERT INTO occupations VALUES ('Naomi', 'Professor');
INSERT INTO occupations VALUES ('Jane', 'Singer');
INSERT INTO occupations VALUES ('Jenny', 'Singer');
INSERT INTO occupations VALUES ('Kristeen', 'Singer');
INSERT INTO occupations VALUES ('Christeen', 'Singer');
INSERT INTO occupations VALUES ('Eve', 'Actor');
INSERT INTO occupations VALUES ('Aamina', 'Doctor');