Q. Consider the table Accounts(branch_id, account_id, balance) that stores the balance of an account in a bank branch. What does the following SQL statement compute and what does it return for the following instance of Accounts.

SELECT A.branch_id, count(*) FROM Accounts A WHERE A.branch_id IN ( SELECT A2.branch_id FROM Accounts A2 GROUP BY A2.branch_id HAVING count(*)>=3) AND A.balance

Question 2 (10 marks). Consider the table Accounts(branch_id, account_id, balance) that stores the balance of an account in a bank branch. What does the following SQL statement compute (7 marks) and what does it return for the following instance of Accounts ( 3 marks). SELECT A.branch_id, count(*) FROM Accounts A WHERE A.branch_id IN ( SELECT A2.branch_id FROM Accounts A2 GROUP BY A2.branch_id HAVING count ()3 ) AND A.balance