sql live plz

EXERCISES Consider the following tables for the RENTAL_PROPERTY database: BRANCH (Bno Street, Suburb, Pcode. Tel_No, Fax_No) STAFF (Sno, Fname, Lname, Address, Tel_No, Position, Sex, DOB, Salary, Bro) PROPERTY_FOR_RENT (Pno, Street , Suburb, Poode, Type, Rooms, Rent, Ono Soo Boo) CLIENT (Cno. FnameLname, address, Tel_No, Pref Type, Max_Rent, Bno) OWNER (Ono, Frame, name, Address, Tol_No) VIEWING (Cno. Pro Date, Comment) The data for tables BRANCH, STAFF, and PROPERTY_FOR_RENT are as follows: Misses Access the DRY Bear Teddo line 200 3101 Street Suburb e Clover Mbowe 163 Mai 2 How Mansed under 22 De Melbourne 16 Ay Hawthom Tel No 627720 6980 1479 1204 628733 0107444 Fax No 96627724 1 9479 1212 0624056 30 312 She TNAM NAME Miren Pin See BON Salary Ai M . Howel Hantom 3122 19770 700000 8014 Ford 3 Aby w3101 041130 Duly M 24 MB 1000000 50 An Dec 01 3101 0413 ) Siste 10 Nov 35200 000 506 Um Westem 1101 0411.412242 Manager 02.0000069 5021 John White 19 Tyler, Melboume 0000418-444 234 Mange M 01.090 000 000 LAI 20 Male Rd, E1020411002. Asi 15 127 000 00 06 One Sno SAD 5014 Street Suburb Poder Type Rooms Rent PA14 56 H Hawthom 3132 Houte 6:50.00 C016 PGH 5 New Rd Kew 3101 4 50000 con PG21 18 De Red How 3101 House 5 000 coe POSE 2 Minor Rd Kuw 3101 Flat 3 337500 C093 PG4 6 Low 3101 Ft 35390 00 0040 PLSA BA Melbourne 3000 F 4 SODO CORP Recorder ht HIRE Bina 3 BO B0 B BO 35 SGU SG14 SLI Based on the above tables a. Write a stored procedure which receives a staff number (Sno) and a rental price (Rent) as inputs, and displays the list of properties handled by that staff, which rental price is not more than the specified rental price. EXERCISES Consider the following tables for the RENTAL_PROPERTY database: BRANCH (Bno Street, Suburb, Pcode. Tel_No, Fax_No) STAFF (Sno, Fname, Lname, Address, Tel_No, Position, Sex, DOB, Salary, Bro) PROPERTY_FOR_RENT (Pno, Street , Suburb, Poode, Type, Rooms, Rent, Ono Soo Boo) CLIENT (Cno. FnameLname, address, Tel_No, Pref Type, Max_Rent, Bno) OWNER (Ono, Frame, name, Address, Tol_No) VIEWING (Cno. Pro Date, Comment) The data for tables BRANCH, STAFF, and PROPERTY_FOR_RENT are as follows: Misses Access the DRY Bear Teddo line 200 3101 Street Suburb e Clover Mbowe 163 Mai 2 How Mansed under 22 De Melbourne 16 Ay Hawthom Tel No 627720 6980 1479 1204 628733 0107444 Fax No 96627724 1 9479 1212 0624056 30 312 She TNAM NAME Miren Pin See BON Salary Ai M . Howel Hantom 3122 19770 700000 8014 Ford 3 Aby w3101 041130 Duly M 24 MB 1000000 50 An Dec 01 3101 0413 ) Siste 10 Nov 35200 000 506 Um Westem 1101 0411.412242 Manager 02.0000069 5021 John White 19 Tyler, Melboume 0000418-444 234 Mange M 01.090 000 000 LAI 20 Male Rd, E1020411002. Asi 15 127 000 00 06 One Sno SAD 5014 Street Suburb Poder Type Rooms Rent PA14 56 H Hawthom 3132 Houte 6:50.00 C016 PGH 5 New Rd Kew 3101 4 50000 con PG21 18 De Red How 3101 House 5 000 coe POSE 2 Minor Rd Kuw 3101 Flat 3 337500 C093 PG4 6 Low 3101 Ft 35390 00 0040 PLSA BA Melbourne 3000 F 4 SODO CORP Recorder ht HIRE Bina 3 BO B0 B BO 35 SGU SG14 SLI Based on the above tables a. Write a stored procedure which receives a staff number (Sno) and a rental price (Rent) as inputs, and displays the list of properties handled by that staff, which rental price is not more than the specified rental price