(Solved) : Please Help Database Relational Algebra Example Need Answer Format Concat Fname Lname Full Q35375313 . . . .

Please help me with this database relational algebra(forexample, I need answer to have this format. “πconcat(Fname,Lname)->fullname,Bdate,Sex σSuper_ssn=333445555(Employee)” questions refer to the table given below.Thank you

1) Provide the average number of people that have been on eachflight number.

Hint – Project the difference of the total number of seats lessnumber of available seats. Use the arrow notation -> to assignthis a virtual column name. Then take the average.

2) What is the most expensive restricted flight. Show a singleresult using the appropriate math function (use Gammaoperator).

3) List the ids and number of seats for all airplanes that canland at any of the airports