a) Assume the following table- Degree (degcode, name, subject) Candidate (seatno, degcode, name, semester, month, year, result) Marks (seatno, degcode, semester, month, year, papcode, marks) [degcode - degree code, name - name of the degree (Eg. BSc.), subject subject of the course (Eg. DBMS), papcode paper code (Eg. CSE-3105)] Solve the following queries using SQL; i. The name, subject and number of candidates for MSc degrees ii. The names of all the candidate who have got greater than 60 marks in BSc. DBMS. b) Considering the relational schema given below. Write the following queries in SQL: Loan(loan_number ,branch_name, amount) Borrower(customer_name, loan_number) Account(account_number, branch_name,balance) i. ii. Find the largest account balance in the bank. Find the names of all customers who have either an account or a loan or both