Employee - Employees

The Employee table containing employee data for a company is described as follows:

where employee_id is an employee's ID number, name is their name, months is the total number of months they've been working for the company, and salary is their monthly salary.

Sample Input

CREATE TABLE IF NOT EXISTS employee(
	employee_id INT,
	name TEXT,
	months INT,
	salary INT);

INSERT INTO employee VALUES (330, 'Rose', 5, 2248);
INSERT INTO employee VALUES (1233, 'Angela', 7, 1296);
INSERT INTO employee VALUES (1901, 'Frank', 10, 2763);
INSERT INTO employee VALUES (2035, 'Patrick', 1, 4583);
INSERT INTO employee VALUES (2405, 'Lisa', 7, 4350);
INSERT INTO employee VALUES (2974, 'Kimberly', 11, 2874);
INSERT INTO employee VALUES (3190, 'Bonnie', 11, 3758);
INSERT INTO employee VALUES (3506, 'Michael', 9, 1936);
INSERT INTO employee VALUES (3708, 'Todd', 22, 4046);
INSERT INTO employee VALUES (4428, 'Joe', 22, 3802);
INSERT INTO employee VALUES (5962, 'Earl', 11, 2958);
INSERT INTO employee VALUES (6060, 'Robert', 22, 4128);
INSERT INTO employee VALUES (6418, 'Amy', 2, 4832);
INSERT INTO employee VALUES (7466, 'Pamela', 1, 4199);
INSERT INTO employee VALUES (9102, 'Maria', 11, 2958);
INSERT INTO employee VALUES (11863, 'Joe', 18, 1721);
INSERT INTO employee VALUES (12004, 'Linda', 15, 2306);
INSERT INTO employee VALUES (12387, 'Melissa', 20, 1854);
INSERT INTO employee VALUES (13835, 'Carol', 20, 4340);
INSERT INTO employee VALUES (15151, 'Paula', 15, 1526);
INSERT INTO employee VALUES (15286, 'Marilyn', 10, 3087);
INSERT INTO employee VALUES (15675, 'Jennifer', 2, 2336);
INSERT INTO employee VALUES (16493, 'Harry', 14, 4755);
INSERT INTO employee VALUES (17858, 'David', 13, 3658);
INSERT INTO employee VALUES (19035, 'Julia', 4, 2195);
INSERT INTO employee VALUES (19172, 'Kevin', 1, 2113);
INSERT INTO employee VALUES (21638, 'Paul', 6, 3120);
INSERT INTO employee VALUES (22684, 'James', 14, 1370);
INSERT INTO employee VALUES (23621, 'Kelly', 7, 1923);
INSERT INTO employee VALUES (24011, 'Robin', 22, 1880);
INSERT INTO employee VALUES (24611, 'Ralph', 22, 1495);
INSERT INTO employee VALUES (25109, 'Gloria', 2, 1979);
INSERT INTO employee VALUES (25120, 'Victor', 20, 1557);
INSERT INTO employee VALUES (28247, 'David', 23, 2212);
INSERT INTO employee VALUES (30183, 'Joyce', 20, 2748);
INSERT INTO employee VALUES (30712, 'Donna', 8, 2604);
INSERT INTO employee VALUES (32502, 'Michelle', 1, 2086);
INSERT INTO employee VALUES (32654, 'Stephanie', 17, 1444);
INSERT INTO employee VALUES (33086, 'Gerald', 23, 2206);
INSERT INTO employee VALUES (33132, 'Walter', 11, 4180);
INSERT INTO employee VALUES (37008, 'Christina', 8, 3100);
INSERT INTO employee VALUES (38246, 'Brandon', 3, 4339);
INSERT INTO employee VALUES (38272, 'Elizabeth', 23, 3967);
INSERT INTO employee VALUES (38964, 'Joseph', 4, 2194);
INSERT INTO employee VALUES (39789, 'Lawrence', 9, 1872);
INSERT INTO employee VALUES (40797, 'Marilyn', 15, 2112);
INSERT INTO employee VALUES (41228, 'Lori', 13, 4350);
INSERT INTO employee VALUES (44436, 'Matthew', 15, 4673);
INSERT INTO employee VALUES (45285, 'Jesse', 1, 3768);
INSERT INTO employee VALUES (47458, 'John', 13, 3104);
INSERT INTO employee VALUES (47496, 'Martha', 15, 4020);
INSERT INTO employee VALUES (47920, 'Timothy', 10, 1745);
INSERT INTO employee VALUES (48129, 'Christine', 22, 3738);
INSERT INTO employee VALUES (50664, 'Anthony', 22, 4912);
INSERT INTO employee VALUES (51741, 'Paula', 1, 2492);
INSERT INTO employee VALUES (52923, 'Kimberly', 17, 1955);
INSERT INTO employee VALUES (55238, 'Louise', 1, 2717);
INSERT INTO employee VALUES (56775, 'Martin', 16, 1385);
INSERT INTO employee VALUES (57065, 'Paul', 23, 3379);
INSERT INTO employee VALUES (58343, 'Antonio', 21, 3268);
INSERT INTO employee VALUES (59256, 'Jacqueline', 14, 3913);
INSERT INTO employee VALUES (60119, 'Diana', 13, 5149);
INSERT INTO employee VALUES (61191, 'John', 5, 1775);
INSERT INTO employee VALUES (65288, 'Dorothy', 22, 3792);
INSERT INTO employee VALUES (65375, 'Evelyn', 6, 4079);
INSERT INTO employee VALUES (66442, 'Phillip', 9, 1894);
INSERT INTO employee VALUES (67137, 'Evelyn', 15, 1311);
INSERT INTO employee VALUES (68942, 'Debra', 20, 3704);
INSERT INTO employee VALUES (69085, 'David', 11, 1845);
INSERT INTO employee VALUES (69234, 'Willie', 12, 5088);
INSERT INTO employee VALUES (69475, 'Brandon', 19, 2279);
INSERT INTO employee VALUES (69787, 'Ann', 9, 1311);
INSERT INTO employee VALUES (70963, 'Emily', 8, 5247);
INSERT INTO employee VALUES (71569, 'Dorothy', 22, 4088);
INSERT INTO employee VALUES (72030, 'Jonathan', 4, 5009);
INSERT INTO employee VALUES (72370, 'Dorothy', 18, 3174);
INSERT INTO employee VALUES (72785, 'Marilyn', 1, 1860);
INSERT INTO employee VALUES (72974, 'Norma', 21, 1558);
INSERT INTO employee VALUES (74662, 'Nancy', 6, 3223);
INSERT INTO employee VALUES (76876, 'Andrew', 11, 1746);
INSERT INTO employee VALUES (77609, 'Keith', 2, 1219);
INSERT INTO employee VALUES (78101, 'Benjamin', 7, 4414);
INSERT INTO employee VALUES (79744, 'Charles', 11, 1911);
INSERT INTO employee VALUES (80475, 'Alan', 16, 1853);
INSERT INTO employee VALUES (80895, 'Tammy', 8, 1591);
INSERT INTO employee VALUES (81381, 'Anna', 16, 1569);
INSERT INTO employee VALUES (82828, 'James', 23, 4398);
INSERT INTO employee VALUES (85287, 'Robin', 23, 2078);
INSERT INTO employee VALUES (87170, 'Jean', 18, 3895);
INSERT INTO employee VALUES (87355, 'Andrew', 15, 1446);
INSERT INTO employee VALUES (89017, 'Roy', 8, 3443);
INSERT INTO employee VALUES (90507, 'Diana', 9, 5101);
INSERT INTO employee VALUES (90558, 'Christina', 23, 3498);
INSERT INTO employee VALUES (92908, 'Jesse', 13, 4753);
INSERT INTO employee VALUES (95322, 'Joyce', 18, 1577);
INSERT INTO employee VALUES (95983, 'Patricia', 23, 1469);
INSERT INTO employee VALUES (96963, 'Gregory', 16, 5071);
INSERT INTO employee VALUES (97178, 'Brian', 19, 3144);
INSERT INTO employee VALUES (98271, 'Christine', 3, 3796);
INSERT INTO employee VALUES (98491, 'Lillian', 3, 1920);

Input Format

The EMPLOYEES table is described as follows:

CREATE TABLE IF NOT EXISTS employees (
	employee_id INT,
	name TEXT,
	salary INT);
	
INSERT INTO employees VALUES (1, 'Ashley', 2340);
INSERT INTO employees VALUES (2, 'Julia', 1198);
INSERT INTO employees VALUES (3, 'Britney', 9009);
INSERT INTO employees VALUES (4, 'Kristeen', 2341);
INSERT INTO employees VALUES (5, 'Dyana', 9990);
INSERT INTO employees VALUES (6, 'Diana', 8011);
INSERT INTO employees VALUES (7, 'Jenny', 2341);
INSERT INTO employees VALUES (8, 'Christeen', 2342);
INSERT INTO employees VALUES (9, 'Meera', 2343);
INSERT INTO employees VALUES (10, 'Priya', 2344);
INSERT INTO employees VALUES (11, 'Priyanka', 2345);
INSERT INTO employees VALUES (12, 'Paige', 2346);
INSERT INTO employees VALUES (13, 'Jane', 2347);
INSERT INTO employees VALUES (14, 'Belvet', 2348);
INSERT INTO employees VALUES (15, 'Scarlet', 2349);
INSERT INTO employees VALUES (16, 'Salma', 9087);
INSERT INTO employees VALUES (17, 'Amanda', 7777);
INSERT INTO employees VALUES (18, 'Aamina', 5500);
INSERT INTO employees VALUES (19, 'Amina', 2570);
INSERT INTO employees VALUES (20, 'Ketty', 2007);

Last updated 2 years ago

Was this helpful?

CREATE TABLE IF NOT EXISTS employee( employee_id INT, name TEXT, months INT, salary INT); INSERT INTO employee VALUES (330, 'Rose', 5, 2248); INSERT INTO employee VALUES (1233, 'Angela', 7, 1296); INSERT INTO employee VALUES (1901, 'Frank', 10, 2763); INSERT INTO employee VALUES (2035, 'Patrick', 1, 4583); INSERT INTO employee VALUES (2405, 'Lisa', 7, 4350); INSERT INTO employee VALUES (2974, 'Kimberly', 11, 2874); INSERT INTO employee VALUES (3190, 'Bonnie', 11, 3758); INSERT INTO employee VALUES (3506, 'Michael', 9, 1936); INSERT INTO employee VALUES (3708, 'Todd', 22, 4046); INSERT INTO employee VALUES (4428, 'Joe', 22, 3802); INSERT INTO employee VALUES (5962, 'Earl', 11, 2958); INSERT INTO employee VALUES (6060, 'Robert', 22, 4128); INSERT INTO employee VALUES (6418, 'Amy', 2, 4832); INSERT INTO employee VALUES (7466, 'Pamela', 1, 4199); INSERT INTO employee VALUES (9102, 'Maria', 11, 2958); INSERT INTO employee VALUES (11863, 'Joe', 18, 1721); INSERT INTO employee VALUES (12004, 'Linda', 15, 2306); INSERT INTO employee VALUES (12387, 'Melissa', 20, 1854); INSERT INTO employee VALUES (13835, 'Carol', 20, 4340); INSERT INTO employee VALUES (15151, 'Paula', 15, 1526); INSERT INTO employee VALUES (15286, 'Marilyn', 10, 3087); INSERT INTO employee VALUES (15675, 'Jennifer', 2, 2336); INSERT INTO employee VALUES (16493, 'Harry', 14, 4755); INSERT INTO employee VALUES (17858, 'David', 13, 3658); INSERT INTO employee VALUES (19035, 'Julia', 4, 2195); INSERT INTO employee VALUES (19172, 'Kevin', 1, 2113); INSERT INTO employee VALUES (21638, 'Paul', 6, 3120); INSERT INTO employee VALUES (22684, 'James', 14, 1370); INSERT INTO employee VALUES (23621, 'Kelly', 7, 1923); INSERT INTO employee VALUES (24011, 'Robin', 22, 1880); INSERT INTO employee VALUES (24611, 'Ralph', 22, 1495); INSERT INTO employee VALUES (25109, 'Gloria', 2, 1979); INSERT INTO employee VALUES (25120, 'Victor', 20, 1557); INSERT INTO employee VALUES (28247, 'David', 23, 2212); INSERT INTO employee VALUES (30183, 'Joyce', 20, 2748); INSERT INTO employee VALUES (30712, 'Donna', 8, 2604); INSERT INTO employee VALUES (32502, 'Michelle', 1, 2086); INSERT INTO employee VALUES (32654, 'Stephanie', 17, 1444); INSERT INTO employee VALUES (33086, 'Gerald', 23, 2206); INSERT INTO employee VALUES (33132, 'Walter', 11, 4180); INSERT INTO employee VALUES (37008, 'Christina', 8, 3100); INSERT INTO employee VALUES (38246, 'Brandon', 3, 4339); INSERT INTO employee VALUES (38272, 'Elizabeth', 23, 3967); INSERT INTO employee VALUES (38964, 'Joseph', 4, 2194); INSERT INTO employee VALUES (39789, 'Lawrence', 9, 1872); INSERT INTO employee VALUES (40797, 'Marilyn', 15, 2112); INSERT INTO employee VALUES (41228, 'Lori', 13, 4350); INSERT INTO employee VALUES (44436, 'Matthew', 15, 4673); INSERT INTO employee VALUES (45285, 'Jesse', 1, 3768); INSERT INTO employee VALUES (47458, 'John', 13, 3104); INSERT INTO employee VALUES (47496, 'Martha', 15, 4020); INSERT INTO employee VALUES (47920, 'Timothy', 10, 1745); INSERT INTO employee VALUES (48129, 'Christine', 22, 3738); INSERT INTO employee VALUES (50664, 'Anthony', 22, 4912); INSERT INTO employee VALUES (51741, 'Paula', 1, 2492); INSERT INTO employee VALUES (52923, 'Kimberly', 17, 1955); INSERT INTO employee VALUES (55238, 'Louise', 1, 2717); INSERT INTO employee VALUES (56775, 'Martin', 16, 1385); INSERT INTO employee VALUES (57065, 'Paul', 23, 3379); INSERT INTO employee VALUES (58343, 'Antonio', 21, 3268); INSERT INTO employee VALUES (59256, 'Jacqueline', 14, 3913); INSERT INTO employee VALUES (60119, 'Diana', 13, 5149); INSERT INTO employee VALUES (61191, 'John', 5, 1775); INSERT INTO employee VALUES (65288, 'Dorothy', 22, 3792); INSERT INTO employee VALUES (65375, 'Evelyn', 6, 4079); INSERT INTO employee VALUES (66442, 'Phillip', 9, 1894); INSERT INTO employee VALUES (67137, 'Evelyn', 15, 1311); INSERT INTO employee VALUES (68942, 'Debra', 20, 3704); INSERT INTO employee VALUES (69085, 'David', 11, 1845); INSERT INTO employee VALUES (69234, 'Willie', 12, 5088); INSERT INTO employee VALUES (69475, 'Brandon', 19, 2279); INSERT INTO employee VALUES (69787, 'Ann', 9, 1311); INSERT INTO employee VALUES (70963, 'Emily', 8, 5247); INSERT INTO employee VALUES (71569, 'Dorothy', 22, 4088); INSERT INTO employee VALUES (72030, 'Jonathan', 4, 5009); INSERT INTO employee VALUES (72370, 'Dorothy', 18, 3174); INSERT INTO employee VALUES (72785, 'Marilyn', 1, 1860); INSERT INTO employee VALUES (72974, 'Norma', 21, 1558); INSERT INTO employee VALUES (74662, 'Nancy', 6, 3223); INSERT INTO employee VALUES (76876, 'Andrew', 11, 1746); INSERT INTO employee VALUES (77609, 'Keith', 2, 1219); INSERT INTO employee VALUES (78101, 'Benjamin', 7, 4414); INSERT INTO employee VALUES (79744, 'Charles', 11, 1911); INSERT INTO employee VALUES (80475, 'Alan', 16, 1853); INSERT INTO employee VALUES (80895, 'Tammy', 8, 1591); INSERT INTO employee VALUES (81381, 'Anna', 16, 1569); INSERT INTO employee VALUES (82828, 'James', 23, 4398); INSERT INTO employee VALUES (85287, 'Robin', 23, 2078); INSERT INTO employee VALUES (87170, 'Jean', 18, 3895); INSERT INTO employee VALUES (87355, 'Andrew', 15, 1446); INSERT INTO employee VALUES (89017, 'Roy', 8, 3443); INSERT INTO employee VALUES (90507, 'Diana', 9, 5101); INSERT INTO employee VALUES (90558, 'Christina', 23, 3498); INSERT INTO employee VALUES (92908, 'Jesse', 13, 4753); INSERT INTO employee VALUES (95322, 'Joyce', 18, 1577); INSERT INTO employee VALUES (95983, 'Patricia', 23, 1469); INSERT INTO employee VALUES (96963, 'Gregory', 16, 5071); INSERT INTO employee VALUES (97178, 'Brian', 19, 3144); INSERT INTO employee VALUES (98271, 'Christine', 3, 3796); INSERT INTO employee VALUES (98491, 'Lillian', 3, 1920);