QY Consider the following relations: BRANCH (branch no, street, area, city, degree, Tel_no, Fax_no) STAFF (Staff_no, Frame, Luame. address. position, salary. branch_no) Write the following queries in SQL: 1. Find all the branches that number less than 453 and found in area ‘34 east’ 2. Find staff whose salary is greater than the salary of every member of staff at branch 71 3. List all stlf who their last name ends with ‘it 4. Find allthe staff that works in branch 345 and have salary between 15000 and 45000.
Extracted text: Q2/ Consider the following relations: BRANCH (branch no, street, area, city, degree, Tel_no, Fax_no) STAFF (Staff no, Fname, Lname. address, position, salary, branch_no) Write the following queries in SQL: 1. Find all the branches that number less than 453 and found in area '34 east 2. Find staff whose salary is greater than the salary of evcry member of staff at branch 71. 3. List all stalf who their last name ends with 'ith'. 4. Find all the staff that works in branch 345 and have salary between 15000 and 45000.