Please Do the following question Using SQL

6. create a function (fn_NumberofStudentInDepartment) that accespts department name as an argument and count number of students in the department

^7. Create a stored procedure (usp_FemaleStudents) that displays female students who are taking accounting LAW and scored B or above (B=> mark>= 80 , A=> mark>=90)

8. create a view (FemaleStudentAgeInLinguistics_VW) that displays list of female students whose age greater than 25 and scored A in Linguistics

9. Create a stored procedure (usp_StudentsForEachCourse) that counts the number of students who are taking each course

10. Create a stored procedure(usp_StudentScoredAInDepartment) that accespts department nameas argument and count number of students scored A in each course in the department