-- create a table
CREATE TABLE employee (id int, name varchar (30), department varchar (30), Salary int, gender varchar (30), age int, city varchar(30));

-- insert some values
INSERT INTO employee VALUES (1001, 'Jane Doe', 'IT', '35000', 'Male', '25', 'London');
INSERT INTO employee VALUES (1002, 'Mary Smith', 'HR', '45000', 'Female', '27', 'London');
INSERT INTO employee VALUES (1003, 'James Brown', 'Finance', '50000', 'Male', '28', 'London');
INSERT INTO employee VALUES (1004, 'Mike Walker', 'Finance', '50000', 'Male', '28', 'London');
INSERT INTO employee VALUES (1005, 'Linda Jones', 'HR', '75000', 'Female', '26', 'London');
INSERT INTO employee VALUES (1006, 'Anurag Mohanty', 'IT', '35000', 'Male', '25', 'Mumbai');
INSERT INTO employee VALUES (1007, 'Priyania Dewangan', 'HR', '45000', 'Female', '27', 'Mumbai');
INSERT INTO employee VALUES (1008, 'Sambit Mohanty', 'IT', '50000', 'Male', '28', 'Mumbai');
INSERT INTO employee VALUES (1009, 'Pranaya Kumar', 'IT', '50000', 'Male', '28', 'Mumbai');
INSERT INTO employee VALUES (1010, 'Hina Sharma', 'HR', '75000', 'Female', '26', 'Mumbai');
-- fetch some values
SELECT * FROM employee