Worksheet Query Builder select * from staff Worksheet Query Builder select * from place 1 1 2 3 Script Output Query Result SQL | All Rows Fetched: 11 in 0.003 seconds STAFFID FNAME 1 LNAME SALARY 95 Are Abdulla 2400 2 96 ASO ALI 2100 3 97 SARA SAMAN 2100 98 Karwan Osman 2100 5 99 SAZ Bwar 2900 6 100 Steven King 24000 7 101 Neena Kochhar 17000 8 102 Lex De Haan 17000 103 Alexander Hunold 9000 104 Bruce Ernst 6000 11 105 David Austin 4800 Script Output * Query Result * SQL All Rows Fetched: 10 in 0.003 seconds PLACEID CITY COUNTRY_ID 900 Malaysia MY 800 IRAQ 1000 Roma IT 1100 Venice IT 1200 Tokyo JP 1300 Hiroshima JP 1400 Southlake US 1500 South San Francisco US 1600 South Brunswick US 10 1700 Seattle US MANAGER_ID BRANCHID (null) (null) (null) 30 104 30 105 (null) 105 100 (null) 90 100 90 100 90 102 60 103 60 103 60 4 5 6 7 9 10 9 Worksheet Query Builder select * from branch Figure 3: Tables contents 1 Script Output Query Result * SQL All Rows Fetched: 6 in 0.128 seconds BRANCHID BRANCHNAME MANAGER_ID PLACEID 10 Administration 200 1700 30 Purchasing 114 1700 50 shipping 121 1500 60 IT 103 1400 90 Executive 100 1700 100 Finance 108 1700 2 3 4 5 6 Write SQL code to display branch name and manager first name. Write SQL code to display branch name, manager name, and city. Write SQL code to display branch name, manager name, and salary of the manager for all managers whose sallaries greater than 5000. Write SQL code to display branch name, average salary within the branch. Write SQL code to display branch name, manager name, and salary of the manager for all managers whose work at IT branch and lives in IRAQ. Write SQL code to display details of branches in which the maximum salary is more than 10000. . Write SQL code to display details of branches managed by Steven'. . Write SQL code to display details of manager who manages more than one staff. ..Write SQL code to the name, location, and number of staffs for each branch. Make sure that the report also includes branches without staffs. . Write SQL code to display the branch number and lowest salary of the branch with the highest average salary. Write SQL code to display the branch number, branch name, and the number of staffs working in each branch that staffs fewer than ten staffs. Write SQL code to display the branch number, branch name, and the number of staffs working in each branch has the highest number of staffs. . Write SQL code to display the branch number, branch name, and the number of staffs working in each branch has the lowest number of staffs