You need to write SQL queries according to the given conditions

1. course(courseCode, title, credit Hours) Faculty empld, empName, designation departmentName, salary, hireDate) Allocations(allocation No, empld, courseCode, semester, classSection) Students(regno, stdName, Program, department, cgpa) Results(regno, allocationNo, marks, grade) Tables and their primary keys are given below: course ..coursecode faculty -- empld Allocations -- allocationNo students-regno results -- regno, allocationNo Show the number of failed students in each course in department of computer science. * DS (3 points) Enter your answer 2. course(courseCode, title, credit Hours) Faculty(empld, empName, designation departmentName, salary, hireDate) Allocations (allocationNo, empld, courseCode, semester, classSection) Students(regno, stdName, Program, department, cgpa) Results(regno, allocationNo, marks, grade) Tables and their primary keys are given below: course -- coursecode faculty -- empld Allocations -- allocationNo students -- regno results -- regno, allocationNo Which core courses of computer science department are taught by faculty of other department. (4 Points) Enter your