Table 1: Table STAFF + StafingstaffName Position Gender DateOfBirth Salary Branching S100i Aileen Tan Manager Female5-Sep-55 8000 BOOI S1002 Ahmad Sales Male 30-Jan-70 1500 B003 Ashraft Assistant Siti Aishah Supervisor Female23-Dec-68 2500 3003 S1015 Nur Aleeya Sales Female7-May-80 1200 B002 Assistant S1020 Muthusamy Manager Male 23-Aug-50 10000 B003 S1030 Edleen Sales Female 9-Jan-75 1350 B001 Assistant S1060 Janice Tan Sales Female 11-Oct-79 2000 B005 Assistant Table 2: Table BRANCH Psode State 43000 Selangor 80350 Johor 25200 Pahang Branch No Street City BOO1 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 Propertyno Street City Pcode Type Rooms Price OwnerNo StaffiD BranchNo PO01 7,BDK Kuantan 25200 House 6 400,0000100 s1015 B003 1/15 P002 6,LP Johor 80300 Apartment4 550,000 oloi S1030 B002 3/2 Bahru P003 89,Jin Johor 80100 House 3 750,000 0102 S1060 B002 Petri Bahru P004 15,Jin Kuantan 25100 Flat 3 150,000 0103 S1002 B003 2/32 P005 Jln Kajang 43650 House 4 490,000 0101 S1002 B001 5/5 P006 37,Jin Kelana 47300 Flat 3 200,000 0103 S1060 B005 40 Jaya Table 4: Table OWNER OwnerNo OwnerName TelNo Email O100 Abu Bakar 012-2213579 0101 Annisa 016-9753111 A.bakar@gmail.com annisa@gmail.com Linm@gmail.com Meera@gmail.com Mei Lin 0102 0103 013-7894561 017-3214569 Meera Kaur (a) Give all Sales Assistants a 5% pay increase. (b) List all managers and supervisors. Sort the query result in descending order by Branch No. (c) Find the number of Property for each owner. (d) Display Property No, Type and Price for Annisa. (e) List Owner Name, Property No, City and Price for property price greater than 500,000. (f) Display the Name, Position and Salary of staff who earn more than 8,000