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

$)$

PROPERTYFORRENT

$($

Pno

$,$

$$Street$,$ Suburb, Pcode, Type, Rooms, Rent, Ono, Sno, Bno

$)$

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.