query

update table name set colname = 'new data' where colname ='old date'
insert into table name (colums) values ('','','','','') where blah2x
select column name from tablename where blah
Delete from table name where blah
 select street from Branch where branchno = (Select branchno from staff group by branchno having COUNT (branchno)!>1)

select branchno,(select count(staffno) as noofstaff from staff where branchno=branchno),
(select avg(salary) as average from staff where branchno=branchno)from branch

B005	22 Dear Rd
B007	16 Argyll St.
B003	163 Main St.
B004	32 Manse Rd.
B002	56 Claver Dr.

staffno	fname	salary	branchno
SL21	John	30000	B005
SL37	Ann	12000	B003
SL14	David	18000	B003
SA9	Mary	9000	B007
SG5	Susan	24000	B003
SL41	julie	9000	B005