Question: Please solve the following sql problem and give the relational algebra type answer for each question and explain it. I will definitely give you helpful
Please solve the following sql problem and give the relational algebra type answer for each question and explain it. I will definitely give you helpful evaluation if you finished it, thank you!
I will definitely give you helpful evaluation if you finished it, thank you!
8. Identify staff with low customer ratings in the last [date]. Display the staff name, number of ratings and average rating. Display 1 row for each staff. 9. Identify the number of transactions performed by staff at the [address] branch in the last [date]. Display 3 columns: staff first name, last name and number of transactions. 10. Identify all accounts that were closed in the [date]. Display the customer's name, account number and final balance. 11. Identify the best bank customers in [location]. Display the customer's name and balance of all accounts. Describe your criteria used to identify the best customers
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
