For the table Students, Enrollments, Courses and Departments: 1. write a SQL sta

Question

For the table Students, Enrollments, Courses and Departments: 1. write a SQL statement that deletes the records of students from Students table whose average score for CS' courses is less than 80%. 2. Write a SQL query that returns the current Students table. Note that, you need to write the statements in given order, first delete statement, then SQL query Input Format The Students, Enrollments, Courses and Departments table are defined as follows: Students Column NameType Netld FirstNameVARCHAR(255) LastName Department VARCHAR(100) VARCHAR(10) VARCHAR(255)

Explanation / Answer

/*If you have any query do comment in the comment section else like the solution*/

1. Delete from students where Netid=(select e.NetId from Enrollments e, students s, courses s where s.NetId=e.NetId and e.CRN=c.CRN and c.Department='CS' and AVG(e.Score)<80);

2. Select * from students;

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.