# data[].attributes.headline
Muhammad Adam Faris Bin Nordin(1161202700)

# data[].attributes.subject
Muhammad Adam Faris Bin Nordin(1161202700)

# data[].attributes.body
16. Select SUM(EMPComission) From EMPLOYEE;
18. Select EmpGender, COUNT(*) as"Total" From EMPLOYEE Group by EmpGender;
19. Select BranchID, SUM(EmpSalary) as "Total Salary" From EMPLOYEE
Where BranchID='2' or BranchID='4' Group by BranchID;
20. Select BranchID as"Total Comission" From EMPLOYEE Where SUM(EmpComission)>7000;

# data[].attributes.headline
Muhammad Amirul Hadi Shaquille Bin Nordin (1161202702

# data[].attributes.subject
Muhammad Amirul Hadi Shaquille Bin Nordin (1161202702

# data[].attributes.body
16. SELECT SUM(EmpComission) FROM EMPLOYEE;
18. SELECT EmpGender, COUNT(*) AS "Total" FROM EMPLOYEE GROUP BY EmpGender;
19. SELECT BranchID, SUM(EmpSalary) AS "Total Salary" FROM EMPLOYEE
WHERE BranchID ='2' OR BranchID ='4' GROUP BY BranchID;
20. SELECT BranchID AS "Total Comission" FROM EMPLOYEE WHERE SUM (EmpComission)>7000;

# data[].attributes.body
16. select  sum(EmpComission) as "Total Comission" from EMPLOYEE;
18. select EmpGender as "Gender",count(*)as 'Total" from EMPLOYEE group by EmpGender;
19. select  BranchID,sum(EmpSalay) as "TOtal Salary" from EMPLOYEE group by BranchID where BranchID='2',BranchID='4';
20. select BranchID as "Total Comisiion" from EMPLOYEE where sum(Empcomission)>7000;

# data[].attributes.headline
Fatin Nabilah binti Mohd Suhaimi (1161202222)

# data[].attributes.subject
Fatin Nabilah binti Mohd Suhaimi (1161202222)

# data[].attributes.body
16. SELECT SUM(EMPCOMMISSION) FROM EMPLOYEE;

18. SELECT EMPGENDER, COUNT(*) AS "TOTAL" FROM EMPLOYEE GROUP BY EMPGENDER;

19. SELECT BRANCHID, SUM(EMPSALARY) AS "TOTAL SALARY" FROM EMPLOYEE
WHERE BRANCHID ='2' OR BRANCHID ='4'GROUP BY BRANCHID;

20. SELECT BRANCHID AS "TOTAL COMMISSION" FROM EMPLOYEE WHERE SUM (EMPCOMMISSION)>7000;

# data[].attributes.headline
Nurul Asyiqin Adriana binti Elmi (1161202185)

# data[].attributes.subject
Nurul Asyiqin Adriana binti Elmi (1161202185)

# data[].attributes.body
16. SELECT SUM(EMPCOMMISSION) FROM EMPLOYEE;

18. SELECT EMPGENDER, COUNT(*) AS "TOTAL" FROM EMPLOYEE GROUP BY EMPGENDER;

19. SELECT BRANCHID, SUM(EMPSALARY) AS "TOTAL SALARY" FROM EMPLOYEE
WHERE BRANCHID ='2' OR BRANCHID ='4'GROUP BY BRANCHID;

20. SELECT BRANCHID AS "TOTAL COMMISSION" FROM EMPLOYEE
WHERE SUM(EMPCOMMISSION)>7000;

# data[].attributes.body
16. select  sum(EmpComission) as "Total Comission" from EMPLOYEE;

18. select EmpGender as "Gender",count(*)as 'Total" from EMPLOYEE        group by EmpGender;

19. select  BranchID,sum(EmpSalay) as "Total Salary" from EMPLOYEE group by BranchID where BranchID='2',BranchID='4';

20. select BranchID as "Total Comisiion" from EMPLOYEE where sum(Empcomission)>7000;

# data[].attributes.body
16. select  sum(EmpComission) as "Total Comission" from EMPLOYEE;

18. select EmpGender as "Gender",count(*)as 'Total" from EMPLOYEE        group by EmpGender;

19. select  BranchID,sum(EmpSalay) as "Total Salary" from EMPLOYEE group by BranchID where BranchID='2',BranchID='4';

20. select BranchID as "Total Comisiion" from EMPLOYEE where sum(Empcomission)>7000;

# data[].attributes.body
16. select  sum(EmpComission) as "Total Comission" from EMPLOYEE;
18. select EmpGender as "Gender",count(*)as 'Total" from EMPLOYEE group by EmpGender;
19. select  BranchID,sum(EmpSalay) as "TOtal Salary" from EMPLOYEE group by BranchID where BranchID='2',BranchID='4';
20. select BranchID as "Total Comisiion" from EMPLOYEE where sum(Empcomission)>7000;

# data[].attributes.body
16. select  sum(EmpComission) as "Total Comission" from EMPLOYEE;
18. select EmpGender as "Gender",count(*)as 'Total" from EMPLOYEE group by EmpGender;
19. select  BranchID,sum(EmpSalay) as "TOtal Salary" from EMPLOYEE group by BranchID where BranchID='2',BranchID='4';
20. select BranchID as "Total Comisiion" from EMPLOYEE where sum(Empcomission)>7000;

# data[].attributes.body
16. select  sum(EmpComission) as "Total Comission" from EMPLOYEE;
18. select EmpGender as "Gender",count(*)as 'Total" from EMPLOYEE        group by EmpGender;
19. select  BranchID,sum(EmpSalay) as "TOtal Salary" from EMPLOYEE group by BranchID where BranchID='2',BranchID='4';
20. select BranchID as "Total Comisiion" from EMPLOYEE where sum(Empcomission)>7000;

# data[].attributes.body
16. select  sum(EmpComission) as "Total Comission" from EMPLOYEE;
18. select EmpGender as "Gender",count(*)as 'Total" from EMPLOYEE group by EmpGender;
19. select  BranchID,sum(EmpSalay) as "TOtal Salary" from EMPLOYEE group by BranchID where BranchID='2',BranchID='4';
20. select BranchID as "Total Comisiion" from EMPLOYEE where sum(Empcomission)>7000;

# data[].attributes.body
16. select  sum(EmpComission) as "Total Comission" from EMPLOYEE;
18. select EmpGender as "Gender",count(*)as 'Total" from EMPLOYEE group by EmpGender;
19. select  BranchID,sum(EmpSalay) as "TOtal Salary" from EMPLOYEE group by BranchID where BranchID='2',BranchID='4';
20. select BranchID as "Total Comisiion" from EMPLOYEE where sum(Empcomission)>7000;

# data[].attributes.body
16. select  sum(EmpComission) as "Total Comission" from EMPLOYEE;
18. select EmpGender as "Gender",count(*)as 'Total" from EMPLOYEE group by EmpGender;
19. select  BranchID,sum(EmpSalay) as "TOtal Salary" from EMPLOYEE group by BranchID where BranchID='2',BranchID='4';
20. select BranchID as "Total Comisiion" from EMPLOYEE where sum(Empcomission)>7000;

# data[].attributes.body
16. select  sum(EmpComission) as "Total Comission" from EMPLOYEE;
18. select EmpGender as "Gender",count(*)as 'Total" from EMPLOYEE group by EmpGender;
19. select  BranchID,sum(EmpSalay) as "TOtal Salary" from EMPLOYEE group by BranchID where BranchID='2',BranchID='4';
20. select BranchID as "Total Comisiion" from EMPLOYEE where sum(Empcomission)>7000;

# data[].attributes.body
16. sellect sum(Emocomission) as "Total Comission" from EMPLOYEE;
18. select EmpGender as "Gender",count (*) as "Total"from EMPLOYEE Group by EmpGender;
19. select BranchID,sum(Empsalary) as "Total Salary"from EMPLOYEE group by BranchID whereBranch='2',BranchID='4';
20. select BranchID as "Total commission"from EMPLOYEE where sum (EmpComission)>7000;

# data[].attributes.body
16. select sum(EmpComission)as"Total Comission" from EMPLOYEE;
18. select Empgender as "Gender",count(*)as "Total"from EMPLOYEE group by EmpGender;
19. select BranchID,sum(EmpSalary)as"Total Salary" from EMPLOYEE group by BranchID where BranchID='2',BranchID'4';
20. select BranchID as"Total Comission" from EMPLOYEE where sum(EmpComission)>7000;

# data[].attributes.body
16. select sum(EmpComission) as "Total Comission" from EMPLOYEE;
18. select Empgender as "Gender", count(*) as "Total" from EMPLOYEE group by EmpGender;
19. select BranchID,sum(EmpSalary) as"Total Salary" from EMPLOYEE group by BranchID as where BranchID='2',BranchID'4';
20. selct BranchId as "TotalComission" from EMPLOYEE where sum(EmComissio >7000;

# data[].attributes.headline
Muhammad Haiqal Helmi Bin Mohd Selleh (1161202336)

# data[].attributes.subject
Muhammad Haiqal Helmi Bin Mohd Selleh (1161202336)

# data[].attributes.body
16. select sum(Empcomission) as “Total Comission” from EMPLOYEE;

18. select EmpGender as “Gender”, count (*) as “Total “from EMPLOYEE Group by EmpGender;

19 select BranchID,sum(Empsalary) as “Total Salary”from EMPLOYEE group by BranchID whereBranchID=’2’,BranchID=’4’;

20. select BranchID as “Total commission”from EMPLOYEEwhere sum (Empcomission)>7000;

# data[].attributes.headline
Muhammad Akmal Haziq Bin Ahmad Azizi(1161202710

# data[].attributes.subject
Muhammad Akmal Haziq Bin Ahmad Azizi(1161202710

# data[].attributes.body
16. select sum(EmpComission)as "Total Comission" from EMPLOYEE;

18. select EmpGeder as "Gender", count (*) as "Total" from EMPLOYEE group by EmpGender;

19. select BranchID, sum(EmpSalary)as "Total Salary" from EMPLOYEE group by BranchID where BranchID='2', BranchID='4';

20. select BranchID as "Total Comission" from EMPLOYEE where sum(EmpComission)>7000;

# data[].attributes.body
16. select sum(EmpComission)as "Total Comission" from EMPLOYEE;
18. select EmpGender as "Gender",count(*)as "Total"from EMPLOYEE group by EmpGender;
19. select BranchID, sum (EmpSalary)as"Total Salary" from EMPLOYEE group by Branch ID where Branch ID='2', Branch ID'4';
20. select Branch ID as "Total Comission" from EMPLOYEE where sum(EmpComission)>7000;