Consider the following relations:
BRANCH( bno, street, area, city, pcode, Tel_no, Fax_no)
STAFF( Sno, Fname, Lname, address, position , salary, bno)
Express the subsequent queries in SQL:
(i) List the staff who work within the branch at ‘163 main street'
(ii) Find out staff whose salary is larger than the salary of each member of staff at branch B3.
(i) Select Fname, Lname from STAFF, BRANCH where STAFF.bno = BRANCH.bno and street = ‘163 main street'
(ii) Select Fname, Lname from STAFF where salary > ( select max (salary) from Staff where bno='B3'