-- Create the table
CREATE TABLE projects (
project_id INT PRIMARY KEY,
employee_name VARCHAR(50),
project_completion_date DATE
);
-- Insert the data
INSERT INTO projects (project_id, employee_name, project_completion_date) VALUES
(100, 'Ankit', '2022-12-15'),
(101, 'Shilpa', '2023-01-03'),
(102, 'Shilpa', '2023-01-15'),
(103, 'Shilpa', '2023-01-22'),
(104, 'Rahul', '2023-01-05'),
(105, 'Rahul', '2023-01-12'),
(106, 'Mukesh', '2023-01-23'),
(108, 'Mukesh', '2023-02-04'),
(109, 'Mukesh', '2023-02-16'),
(110, 'Shilpa', '2023-02-24'),
(112, 'Rahul', '2023-02-25');
select * from projects;
