SQL Practice Questions - Level-1
@LearnWithRD0529
Scripts:
-- Create the "employ" table
CREATE TABLE employ (
employee_id INT PRIMARY KEY,
name VARCHAR(50),
age INT,
department VARCHAR(50),
salary DECIMAL(10, 2),
join_date DATE
);
-- Insert sample data into the "employ" table
INSERT INTO employ VALUES (101, 'John Smith', 30, 'IT', 60000.00, '01-JAN-22');
INSERT INTO employ VALUES (102, 'Jane Doe', 25, 'Sales', 55000.00, '15-FEB-22');
INSERT INTO employ VALUES (103, 'Bob Johnson', 35, 'Marketing', 70000.00, '20-MAR-22');
INSERT INTO employ VALUES (104, 'Alice Brown', 28, 'IT', 65000.00, '10-APR-22');
INSERT INTO employ VALUES (105, 'Charlie Wilson', 32, 'Sales', 60000.00, '05-MAY-22');
INSERT INTO employ VALUES (106, 'Eva Davis', 40, 'Marketing', 75000.00, '15-JUN-22');
INSERT INTO employ VALUES (107, 'Frank Miller', 27, 'IT', 62000.00, '01-JUL-22');
INSERT INTO employ VALUES (108, 'Grace Taylor', 38, 'Sales', 58000.00, '10-AUG-22');
INSERT INTO employ VALUES (109, 'Harry Anderson', 29, 'Marketing', 72000.00, '25-SEP-22');
INSERT INTO employ VALUES (110, 'Ivy Clark', 33, 'IT', 63000.00, '15-OCT-22');