OneCompiler

my first day of my sql

1644


CREATE TABLE EMPLOYEE (
empId INTEGER PRIMARY KEY,
name TEXT NOT NULL,
dept TEXT NOT NULL,
designation TEXT NOT NULL,
salary BIGINT NOT NULL -- Adjust data type if needed
);

-- insert
INSERT INTO EMPLOYEE VALUES (0006, 'Dave', 'Managment', 'Manager', '5000000');
INSERT INTO EMPLOYEE VALUES (0007, 'Ava', 'Sales', 'Manager', '5000000');
INSERT INTO EMPLOYEE VALUES (0002, 'Paarth', 'Board_of_Directors', 'co_founder', '10000000000000');
INSERT INTO EMPLOYEE VALUES (0004, 'Om', 'Sports', 'Head', '10000000');
INSERT INTO EMPLOYEE VALUES (0001, 'Gagan', 'Board_of_Directors', 'co_founder', '100000000000000');
INSERT INTO EMPLOYEE VALUES (0003, 'Bhavy', 'Managment', 'Head', '10000000');
INSERT INTO EMPLOYEE VALUES (0008, 'Arnav', 'Managment', 'Haryana_Manager', '2500000');

-- fetcmu
SELECT * FROM EMPLOYEE;