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!
RelationalAlgebraGenerate relational algebra to answer the queries below. Create descriptive attribute labels.Replaceany value in brackets. For instance, [customer], [day] and [state] or other items in brackets with your own values. For instance:[customer] Identifies the customersname such as Bob Smith. [state] Identifies the statename such as New Jersey.

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
