Please Following Question Using Sql 6 Create Function Fnnumberofstudentindepartment Accesp Q43797327
Please Do the following question Using SQL
6. create a function(fn_NumberofStudentInDepartment) that accesptsdepartment name as an argument and count number of students in thedepartment
7. Create a stored procedure(usp_FemaleStudents) that displays female studentswho are taking accounting “LAW” and scored B or above (B=>mark>= 80 , A=> mark>=90)
8. create a view(FemaleStudentAgeInLinguistics_VW) that displayslist of female students whose age greater than 25 and scored A in“Linguistics”
9. Create a stored procedure(usp_StudentsForEachCourse) that counts the numberof students who are taking each course
10. Create a storedprocedure(usp_StudentScoredAInDepartment) thataccespts department nameas argument and count number of studentsscored A in each course in the department
Expert Answer
Answer to Please Do the following question Using SQL 6. create a function (fn_NumberofStudentInDepartment) that accespts departmen…
OR