Student.dept indicates the departments of the students, Enroll.grade represents the GPA, Course.dept contains just the departmental acronym, e.g., CSE, indicating the departments that offer the courses, write following SQL queries

Question - For every department, list the department name and the total number of courses such that more than half of the students enrolled in such a course are from outside of the department that offers the course.

CREATE TABLE student(

sno varchar(10) PRIMARY KEY,

name varchar(20),

dept varchar(10));

CREATE TABLE course(

cno varchar(5) PRIMARY KEY,

dept varchar(10));

CREATE TABLE enroll(

cno varchar(5) REFERENCES course(cno),

sno varchar(10) REFERENCES student(sno),

grade numeric(3,2),

PRIMARY KEY (cno, sno));