Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
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:
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started