SQLize | PHPize | SQLtest

-- 1. Create EMPLOYEE table CREATE TABLE EMPLOYEE ( EMP_ID NUMBER PRIMARY KEY, EMP_NAME VARCHAR2(100), EMP_ADDRESS VARCHAR2(200), SKILL VARCHAR2(100), PROJ_ID NUMBER ); -- 2. Create EQUIPMENT table CREATE TABLE EQUIPMENT ( EQP_ID NUMBER PRIMARY KEY, EMP_ID NUMBER, EQP_TYPE VARCHAR2(100), PROJECT VARCHAR2(100), FOREIGN KEY (EMP_ID) REFERENCES EMPLOYEE(EMP_ID) ); -- 3. Insert sample data into EMPLOYEE table INSERT INTO EMPLOYEE VALUES (1, 'Wahid', 'New York', 'Java', 101); INSERT INTO EMPLOYEE VALUES (2, 'Bob', 'Chicago', 'Python', 102); INSERT INTO EMPLOYEE VALUES (3, 'Charlie', 'Los Angeles', 'C++', 103); INSERT INTO EMPLOYEE VALUES (4, 'Diana', 'Miami', 'SQL', 104); INSERT INTO EMPLOYEE VALUES (5, 'Rahul', 'Delhi', 'Welding', 105); -- 4. Insert sample data into EQUIPMENT table (with valid EMP_IDs) INSERT INTO EQUIPMENT VALUES (1001, 1, 'Laptop', 'Mumbai'); INSERT INTO EQUIPMENT VALUES (1002, 2, 'Desktop', 'Dubai'); INSERT INTO EQUIPMENT VALUES (1003, 3, 'Tablet', 'Pakistan'); INSERT INTO EQUIPMENT VALUES (1004, 4, 'Monitor', 'India'); INSERT INTO EQUIPMENT VALUES (1010, 5, 'Welding machine', 'Saudia'); -- 5. Commit changes COMMIT; -- 6. Query to find all employees working on the same project as equipment with EQP_ID = 1001 SELECT DISTINCT e.EMP_ID, e.EMP_NAME, e.EMP_ADDRESS, e.SKILL, e.PROJ_ID FROM EMPLOYEE e JOIN EQUIPMENT eq1 ON e.EMP_ID = eq1.EMP_ID WHERE eq1.PROJECT = ( SELECT PROJECT FROM EQUIPMENT WHERE EQP_ID = 1001 );