Please write Relational Algebra expressions according to the following queries a

ID: 3114907 • Letter: P

Question

Please write Relational Algebra expressions according to the following queries and the above schema.

[7] Select all staff with a salary greater than $20,000.

[8] List all staff with a salary between $10,000 and $20,000

[9] Produce a list of staff number, first name, last name, and salaries from the staff table.

[10]How many properties cost more than $400 per month to rent?

[11] Find the minimum, maximum and average staff salary.

[12] Find the average salary for each branch. (please use grouping)

[13] List the staffs who work in the branch at ‘163 Main St’.

[14] List the properties that are handled by staff who work in the branch at ‘163 Main St’.

[15] List the names of all clients who have viewed a property and leave comments.

[16] For each branch, list the branch number, number of staff members, and sum of their salary.

you have posted half question only.

please post the upper half portion of the question also.