--1

PROPE
-----
PG16
PG21
PG36
PG4
PL94

--2

BRANC
-----
B002
B004
B007

--3

STAFF LNAME      FNAME      NO_CLIENTS_REG
----- ---------- ---------- --------------
SA9   Howe       Mary                    1
SG14  Ford       David                   0
SG37  Beech      Ann                     2
SG5   Brand      Susan                   0
SL21  White      John                    0
SL41  Lee        Julie                   1

6 rows selected.


--4

TYPE
----------
Flat

--5

BRANC CITY
----- ----------
B003  Glasgow


--6

STAFF LNAME      FNAME
----- ---------- ----------
SG37  Beech      Ann

--7

no rows selected


--8

BRANC CITY
----- ----------
B004  Bristol
B002  London


--9

PROPE TYPE
----- ----------
PL94  Flat
PG16  Flat


--10

STAFF LNAME      FNAME      POSITION
----- ---------- ---------- ----------
SL21  White      John       Manager
SG37  Beech      Ann        Assistant
SG14  Ford       David      Supervisor


--11

POSITION
----------
Manager


--12

OWNER
-----
CO87


--13

BRANC CITY
----- ----------
B007  Aberdeen


--14
BRANC CITY
----- ----------
B005  London
B007  Aberdeen