- 12 00 1 Back Assignment Docx Branch Registration Stall Client Property For Rent Figure 1 List Of Tables Note Primar 1 (22.97 KiB) Viewed 32 times
- 12 00 1 Back Assignment Docx Branch Registration Stall Client Property For Rent Figure 1 List Of Tables Note Primar 2 (18.69 KiB) Viewed 32 times
- 12 00 1 Back Assignment Docx Branch Registration Stall Client Property For Rent Figure 1 List Of Tables Note Primar 3 (21.57 KiB) Viewed 32 times
12:00 1 Back Assignment.docx ...Write an SOL query to delete all those tuples from BRANCH where city name contains ris" Write an SQL query to retrieve the Branchno, total number of staff working in each branch from staff table. Write an SQL query to update (increase the salary of those staff by 500 whose position is manger in STAFF table Write an SQL query to retrieve the details of all the staff from STAFF table who are not 'male and are not managers vi Write an SQL query: from each branch with more than member of staff, find the number of staff in each branch and their sum of their salaries and sort by branch no. Use nested questo
12:001 Back Assignment.docx Write an SQL query to retrieve the details of all the staff from STAFF table who are not "male" and are not managers Write an SQL query: from each branch with more than 1 member of staff, find the number of staff in each branch and their sum of their salaries and sort by branch no. Use nested queries/subqueries VEL Write an SQL query to delete tuple in the PROPERTYFORRENT table where property is in city "Aberdeen" staff salary is equal to 9000 I Write an SQL to retrieve the name, Iname, position, salary of those staff who are working in city London or Glasgow *Write an SOL query to update the DATEJOINED 10 31=DEC-99 in Registration Table where registration is handled by the staff name as Ann Beech and client PREFTYPE is 'House"