# data[].attributes.headline
MUHAMMAD HAARIS BIN MOHAMAD EZAM (1161203516)

# data[].attributes.subject
MUHAMMAD HAARIS BIN MOHAMAD EZAM (1161203516)

# data[].attributes.body
Submission Question

Question 16

Select sum(Employee_Commission) from Employee;

Question 18

Select sum(case Employee_Gender = “M” then 1 end) as Male, sum(case Employee_Gender = “F” then 1 end) as Female from Employee;

Question 19

Select Employee_Salary from Employee where Brand_ID = 2 and Branch_ID = 4;


Question 20

Select Brand_ID from Employee where Employee_Commission >= 7000;

# data[].attributes.body
(1161203048) : )

# data[].attributes.body
(1161203007)

# data[].attributes.headline
MUHAMMED FAYAZ BIN JAAFARDEN [1161203663]

# data[].attributes.subject
MUHAMMED FAYAZ BIN JAAFARDEN [1161203663]

# data[].attributes.body
LIVINTAN SHAMUGOM 122701108

# data[].attributes.body
Lab 5 Submission Question

# data[].attributes.body
SUBMISSION QUESTION

# data[].attributes.body
Submission Question
Hisham Dean - 1161202900