I am trying to run the following queries and the total does not sum up correctly, pls. HELP! I am Jr.
Queries required:
Total Unique Employees not using CPU Projects
Total Unique employees using exactly one non-CPU project
Total Unique employees using exactly two non-CPU projects
Total Unique SQL users on non CPU projects
total unique SQL users using exactly one non-CPU project
Project SQL Ver CPU based? Emp ID. Emp Name
ABC MSSQL 2000 ENT NO 123 A
CDE MSSQL 2000 STD YES 123 A
FGH MSSQL 7.0 ENT NO 789 C
ABC MSSQL 2000 ENT YES 102 D
CDE MSSQL 2000 STD YES 789 C
FGH MSSQL 7.0 ENT NO 108 F
IJK MSSQL 7.0 STD YES 110 G
Queries required:
Total Unique Employees not using CPU Projects
Total Unique employees using exactly one non-CPU project
Total Unique employees using exactly two non-CPU projects
Total Unique SQL users on non CPU projects
total unique SQL users using exactly one non-CPU project
Project SQL Ver CPU based? Emp ID. Emp Name
ABC MSSQL 2000 ENT NO 123 A
CDE MSSQL 2000 STD YES 123 A
FGH MSSQL 7.0 ENT NO 789 C
ABC MSSQL 2000 ENT YES 102 D
CDE MSSQL 2000 STD YES 789 C
FGH MSSQL 7.0 ENT NO 108 F
IJK MSSQL 7.0 STD YES 110 G
