1. Develop a SQL query to list details of Departments that offer more than 3 branches.

2. Develop a SQL query to list the details of Departments that offer more than 6 courses.

3. Develop a SQL query to list the details of courses that are common for more than 3 branches.

4. Develop a SQL query to list students who got S in more than 2 courses during single enrollment.

5. Create a view that will keep track of the roll number, name and number of courses, a student has completed successfully.

Student Rollno Name Dob Gender Doa Bcode Enrolls Rollno Ccode Sess Grade Course Ccode | Cname Cname Credits Dno Department Dno Dname Branch Course Bcode Ccode Semister Branch Bcode Bname Dno Student Rollno Name Dob Gender Doa Bcode Enrolls Rollno Ccode Sess Grade Course Ccode | Cname Cname Credits Dno Department Dno Dname Branch Course Bcode Ccode Semister Branch Bcode Bname Dno