Table 4: Table OWNER OwnerNoOwner Name TelNo Email 0100 Abu Bakar 012- A.bakar@gmail.com 2213579 0101 Annisa 016- annisa@gmail.com 9753111 0102 Mei Lin 013- LinM@gmail.com 7894561 Meera Kaur 017- Meera@gmail.com 3214569 0103 (a) Give all Sales Assistants a 5% pay increase [3 marks] (b) List all managers and supervisors. Sort the query result in descending order by Branch No. [3 marks) (c) Find the number of Property for each owner. [3 marks] (d) Display Property No, Type and Price for Annisa. [4 marks) (e) List Owner Name, Property No, City and Price for property price greater than 500,000. (4 marks) (6) Display the Name, Position and Salary of staff who earn more than 8,000. [3 marks ] Flog question Question 1 Based on the following tables, STAFF, BRANCH, PROPERTY_FOR_SALE and OWNER; write SQL statements to produce the desired results. Table 1: Table STAFF StaffNoStaffName Position Gender DateOfBirthSalaryBranchNo S1001 Aileen Tan Manager Female 5-Sep-55 8000 B001 S1002 Ahmad Sales Male 30-Jan-70 1500 B003 Ashraff Assistant S1010 Siti Aishah SupervisorFemale23-Dec-68 2500 B003 S1015 Nur Aleeya Sales Female 7-May-80 1200 B002 Assistant S1020 Muthusamy Manager Male 23-Aug-50 10000 1003 S1030 Edleen Sales Female 9-Jan-75 1350 B001 Assistant S1060 Janice Tan Sales Female11-Oct-79 2000 B005 Assistant Table 2: Table BRANCH Pcode State 43000 Selangor 80350 Johor 25200 Pahang BranchNo Street City B001 Jalan Reko Kajang B002 Jalan Larkin Johor Bahru B003 Jalan Putra Kuantan Square 2 B004 Jalan Wong Ah Johor Fook Bahru B005 Jalan SS 6/12 Petaling Jaya 80000 Johor 47301 Selangor Table 3: Table PROPERTY_FOR_SALE PropertyNoStreetCity PcodeType RoomsPrice OwnerNoStaffinBranchNo PO01 7,BDK Kuantan 25200 House 6 400,0000100 S1015 B003 1/15 P002 6,LP Johor 80300 Apartments 550,0000101 S1030 B002 3/2 Bahru P003 89,Jin Johor 80100 House 3 750,000 0102 S1060 B002 Petri Bahru P004 15,Jin Kuantan25100 Flat 3 150,000 0103 S1002 B003 2/32 P005 12,Jin Kajang 43650 House 4 490,0000101 S1002 B001 5/5 P006 37,Jln Kelana 47300 Flat 3 200,000 0103 S1060 B005 40 Jaya