scripts:
SQL Practice Session 2
====================
-- Table Creation
CREATE TABLE emp(
emp_id INT PRIMARY KEY,
name VARCHAR(255),
join_date DATE,
salary DECIMAL(10,2),
department VARCHAR(50)
);
-- Insert Data
INSERT INTO emp VALUES(1, 'John Doe', '15-JAN-23', 60000, 'IT');
INSERT INTO emp VALUES(2, 'Jane Smith', '20-FEB-23', 70000, 'HR');
INSERT INTO emp VALUES(3, 'Bob Johnson', '10-MAR-23', 55000, 'Marketing');
INSERT INTO emp VALUES(4, 'Alice Williams', '05-OCT-23', 80000, 'IT');
INSERT INTO emp VALUES(5, 'Charlie Brown', '12-NOV-23', 75000, 'HR');
INSERT INTO emp VALUES(6, 'Michael Johnson', '10-APR-23', 50000, '');
INSERT INTO emp VALUES(7, 'Benette Clark', '25-MAY-23', 55000, 'Marketing');
