E Branch Registration BRANCHNO STREET CITY POSTCODE B005 22 Deer Rd London SW14EH CLIENTNO BRANCHNO" STAFFNO" DATEJOINED

[answerhappygod]

E Branch Registration Branchno Street City Postcode B005 22 Deer Rd London Sw14eh Clientno Branchno Staffno Datejoined 1 (50.09 KiB) Viewed 32 times

E Branch Registration Branchno Street City Postcode B005 22 Deer Rd London Sw14eh Clientno Branchno Staffno Datejoined 2 (30.58 KiB) Viewed 32 times

E Branch Registration Branchno Street City Postcode B005 22 Deer Rd London Sw14eh Clientno Branchno Staffno Datejoined 3 (27.91 KiB) Viewed 32 times

E Branch Registration Branchno Street City Postcode B005 22 Deer Rd London Sw14eh Clientno Branchno Staffno Datejoined 4 (20.3 KiB) Viewed 32 times

E Branch Registration Branchno Street City Postcode B005 22 Deer Rd London Sw14eh Clientno Branchno Staffno Datejoined 5 (18.69 KiB) Viewed 32 times

E Branch Registration Branchno Street City Postcode B005 22 Deer Rd London Sw14eh Clientno Branchno Staffno Datejoined 6 (21.57 KiB) Viewed 32 times

E Branch Registration BRANCHNO STREET CITY POSTCODE B005 22 Deer Rd London SW14EH CLIENTNO BRANCHNO" STAFFNO" DATEJOINED B007 16 Argyll St Aberdeen AB2 3SU CR76 B005 SL41 02-JAN-01 BOOS 163 Main St Glasgow G11 9QX CR56 B003 SG37 11-APR-00 B004 32 Manse Rd Bristol B599 1NZ CR74 B003 SG37 16-NOV-99 BOO2 56 Clover Dr London NW10 6EU CR62 B007 SAS 07-MAR-00 Staff STAFFNO FNAME LNAME POSITION SEX DOB SALARY BRANCHNO SL21 John White Manager M 01-OCT-45 30000 BOOS SG37 Ann Beech Assistant F 10-NOV-60 12000 B003 SG14 David Ford Supervisor M 24-MAR-58 18000 B003 SAS Mary Howe Assistant F 19-FEB-70 9000 B007 SG5 Susan Brand Manager F 03-JUN-40 24000 BOOS SL41 Julie Lee Assistant F 13-JUN-65 9000 B005 Client CLIENTNO FNAME LNAME TELNO PREFTYPE MAXRENT
1 Assistant F 13-JUN-65 3000 8005 Client CLIENINO TNAME INAME TELNO PRETYPE MARENT CR76 John Kay 0171-774-5632 Flat 425 CR56 Aline Steward 0141-843-1825 Flat 150 OR 74 Mile Ritchie 01475-462178 House 750 CR62 Mary Treger 01224-196720 Fiat 600 Property For Rent PROPERTYNO STREET CITY POSTCODE TYPE ROOMS RENT OWNERO STASINO BRANCO PAL 16 Holhead Aberdeen ABT550 House 650 0046 SAS 3007 Art London NW2 Flat 4 400 COB7 SI BOOS PCE 6 Lawrence St G11CX Het 3 350 00:40 SC14 3003 2. Manor 6:36 PG21 Fiat 3 375 0090 632 403 G12 SGHT 003 18 Dale Rd House 5 C087 SZ som G16 5 Nov Glasgow G12 SAX 600 450 Flat 4 C093 SG14 BOOS Figure 1: list of tables Note: : Primary key * : Foreign Key
12:02 Back Assignment.docx vi.Write an SQL query to retrieve the details of all the staff from STAFF table who are not "male" and are not 'managers vii. 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. se nested queries/subqueries vii. Write an SQL query to delete tuple in the PROPERTYFORRENT table where property is in city "Aberdeen' staff salary is equal to 9000. it. Write an SQL to retrieve the frame, Iname, position, salary of those staff who are working in city London or Glasgow Write an SQL query to update the DATEJOINED to 31-DEC-99 in Registration Table where registration is handled by the staff name as "Ann Beech and client PREFTYPE is "House'.
12:021 Back Assignment.docx Write an SQL query to insert a new tuple into a branch table where branch is located in Kuala Lumpur with B017 and in street '08 Jalan Gombak' with postcode JG53100 mi. Write an SQL 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.
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"