pls correcr the sql errors

please correct the errors and create the tables: CREATE TABLE Branch branch No varchar(10) PRIMARY KEY. street varchar(20), city varchar(20), postcode varchar(10) ); CREATE TABLE Staff Staftno varchar(10) PRIMARY KEY, FName nvarchar(20), LName nvarchar(20). position varchar(15), gender char(1). DOB datetime, salary numeric(8,2). branchNo varchar(10) FOREIGN KEY REFERENCES Branch): CREATE TABLE Private Owner owner No varchar(10) PRIMARY KEY, fName nvarchar(20), IName nvarchar(20) Address varchar(40), telo varchar(15)): CREATE TABLE Property For Rent property o varchar(10) PRIMARY KEY, Street varchar(20), city varchar(20), postcode varchar(10), type varchar(10) not null rooms numeric2) default 4, rent numeric(5.2) default o, ownerno varchar(90) FOREIGN KEY REFERENCES Private Owner staffNo varchar(10) FOREIGN KEY REFERENCES Staft branchNo varchar(10) FOREIGN KEY REFERENCES Branch ): CREATE TABLE Client clientNo varchar(10) PRIMARY KEY, tName nvarchar(20), IName nvarchar(20), telno varchar(15), prefType varchar(10). maxRent numeric(6,2), eMail varchar(40)); CREATE TABLE Viewing clientNo varchar(10) constraint clientNo_fk FOREIGN KEY[clientNo) REFERENCES Client, property No varchar(10) FOREIGN KEY REFERENCES Property For Rent viewDate datetime, comment varchar(100). constraint viewing_pk PRIMARY KEY (clientNo, propertyNo) 1 SET NOCOUNT ON INSERT INTO Branch VALUES ('B002":56 Cover Drive London W10 6EU'); INSERT INTO Branch VALUES ('BO03163 Main Street, Glasgow'G11 9OX": INSERT INTO Branch VALUES ('B00432 Manse Road', Bristol, BS99 INZ"); INSERT INTO Branch VALUES ('BO05:22 Deer Road, London SW14EH"): INSERT INTO Branch VALUES ('B007:16 Argyll Street Aberdeen AB2 35U"); INSERT INTO Branch VALUES ('B008: 30 Rose Street, 'Rockdale''SW2 4EH"); INSERT INTO Stat VALUES ('5193, Mary. Howe'Assistant F. 19/2/1970,9000, INSERT INTO Staff VALUES