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, Bno$)$

PROPERTY$\_$FOR$\_$RENT $($Pno$,$ Street, Suburb, Pcode, Type, Rooms, Rent, Ono, Sno, Bno$)$

CLIENT $($Cn$,$ Fname, Lname, Address, Tel$\_$No$,$ Pref$\_$Type, Max$\_$Rent, Bno$)$

OWNER $($Ono$,$ Fname, Lname, $$ ddress, Tel$\_$No$)$

VIEWING $($Cno$.$ Pno, Date, Comment$)$

The data for tables BRANCH, STAFF, and PROPERTY$\_$FOR$\_$RENT are as follows:

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 propertics handled by that staff, which rental

price is not more than the specified rental price.