course(courseCode, title, creditHours) Faculty(empId, empName, designation, departmentName, salary, hireDate) Allocations(allocationNo, empId, 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 -- empId Allocations -- allocationNo students -- regno results -- regno, allocationNo

Show the number of failed students in each course in department of computer science