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]