Data base i have only 10 mints left plzzz nees it fastttt plzzz its the 2nd time i post it

Consider the ERD schema below for keeping track of course registration of students in a university STUDENT 8 SSN REGISTERED 8 SSN COURSE 8 Code DEPARTMENT 8 DeplD DepName DepLocation Full Name Title GO 9 Code Year O DeplD Email Address GPA Grade 7. Retrieve the name and email of all students who are registered in all the courses that "John Smith" has registered * Your answer 8. For every course other than Networking", retrieve the title of the course along with the number of students registered in that course in the descending order of number of students. * Your