Description
A. Create a variable avg_cred to store the average of total credits of students. Show names of the students with total credit more than twice the average of total credits using variable avg_cred.[1] B. show the details of the departments which have budgets more than the average budget across all departments. First show it without defining any function, then show it by defining a function avg_budget that return average budget across all departments.[1] C. Create a procedure top_budg that when called will accept a number N and return budgets of top N departments. Use N=3 and N=5 to verify your procedure.[1] D. Create a procedure which will be used by a system admin whenever a new student joins. The procedure will create a view such that, each student can see details of all students except their total credit, but the student can see all information about him/her. Demonstrate this procedure with examples[atleast 2 examples].[2]