QUESTION 2

Given the database Employee with the following tables:

Staaf and salary

StaffID	Name	Sex	Age	Department	Job
111	Sophia	F	25	Accounts	Accountant
222	Manubay	M	30	Marketing	Manager
333	Zainal	M	28	Computer	Programmer
444	Wong	M	28	Computer	Analyst
555	Balan	M	32	Accounts	Accountant
666	Susila	F	20	Computer	Analyst
777	Mei Ling	F	26	Computer	Programmer

StaffID	Basic	Allowances
111	2300.00	1000.00
222	3000.00	1500.00
333	2300.00	900.00
444	2000.00	800.00
555	2700.00	1200.00
666	2200.00	1000.00
777	1900.00	950.00

Generate reports for the following queries:

(a)List StaffID, Name, Department, Job, Basic for Department = Computer

(b)List StaffID, Name, Department, Job, Basic for Department = Computer and Sex = F

(c)List StaffID, Name, Department, Job, Basic for Age between 25 and 30

(d)List StaffID, Name, Department, Job, GrossPay where GrossPay =Basic + Allowances

(e)List StaffID, Name, Department, Job, GrossPay, Deductions, NetPay where GrossPay = Basic + Allowances Deductions = 0.12 * GrossPay NetPay = Gross Pay Deductions