CREATE TABLE EmployeeDetails (
    Empld INT PRIMARY KEY,
    FullName VARCHAR(100),
    Managerid INT,
    DateOfJoining DATE,
    City VARCHAR(100)
);
CREATE TABLE EmployeeSalary (
    Empld INT,
    Project VARCHAR(100),
    Salary INT,
    Variable INT,
    PRIMARY KEY (Empld, Project)  
);

INSERT INTO EmployeeDetails (Empld, FullName, Managerid, DateOfJoining, City)
VALUES (121, 'Jon Snow', 321, '2019-01-31', 'Toronto');
INSERT INTO EmployeeDetails (Empld, FullName, Managerid, DateOfJoining, City) VALUES (321, 'Wa Boewhibo', 936, '2020-01-30', 'California');
INSERT INTO EmployeeDetails (Empld, FullName, Managerid, DateOfJoining, City) VALUES (421, 'Kuldeep Ratua', 876, '2021-11-27', 'New Delhi');

INSERT INTO EmployeeSalary (Empld, Project, Salary, Variable) VALUES (121, 'P1', 8000, 500);
INSERT INTO EmployeeSalary (Empld, Project, Salary, Variable)
VALUES (321, 'P2', 10000, 1000);
INSERT INTO EmployeeSalary (Empld, Project, Salary, Variable)
VALUES (421, 'P1', 12000, 0);

5)SELECT Project, COUNT(Empld) AS EmployeeCount
FROM EmployeeSalary
GROUP BY Project;