9-one SQL statement to add a new branch

B100 at 1 Main Street, houston, post code 77002 11-SQL statement to shows a domain budgetType which is a number with a domain constraint value being between 1 to 1,000,000 13-SQL view definition LondonStaff, which shows the stafflD, fName, IName, and positions of all staffs who works in London 15- SQL statement to show the names and the salaries of the staffs who work at London Help as soon as possible please

Transcribed Image Text:

structions Branch branchNo street B005 B007 B003 B004 B002 Staff 22 Deer Rd 16 Argyll St 163 Main St 32 Manse Rd 56 Clover Dr SA9 SG5 SL41 Julie city London Aberdeen Glasgow Bristol London staffNo fName IName position SL21 John White SG37 Ann Beech SG14 David Ford Mary Howe Susan Brand Lee postCode SV 1 4EH AB2 3SU G11 9QX BS99 1NZ NW10 6EU sex DOB Manager M 1-Oct-45 Assistant F 30000 B005 10-Nov-60 12000 B003 24-Mar-58 18000 B003 19-Feb-70 9000 B007 Manager F 3-Jun-40 24000 B003 Assistant F 13-Jun-65 9000 B005 Supervisor M Assistant F salary branch Answer the following questions for the tables above: structions Branch branchNo street B005 B007 B003 B004 B002 Staff 22 Deer Rd 16 Argyll St 163 Main St 32 Manse Rd 56 Clover Dr SA9 SG5 SL41 Julie city London Aberdeen Glasgow Bristol London staffNo fName IName position SL21 John White SG37 Ann Beech SG14 David Ford Mary Howe Susan Brand Lee postCode SV 1 4EH AB2 3SU G11 9QX BS99 1NZ NW10 6EU sex DOB Manager M 1-Oct-45 Assistant F 30000 B005 10-Nov-60 12000 B003 24-Mar-58 18000 B003 19-Feb-70 9000 B007 Manager F 3-Jun-40 24000 B003 Assistant F 13-Jun-65 9000 B005 Supervisor M Assistant F salary branch Answer the following questions for the tables above: