Following are the entities and attributes of a university library database. The database records student enrollment in courses and the books adopted for each course. STUDENT(SID, SNAME, SMMAJOR, SBDATE) COURSE(CNO, CNAME, DEPT) ENROLL(SID, CNO, SEM, CLASS) BADOPT(CNO, SEM, ISBN) BOOK(ISBN, TITLE, PUB, AUTH) Note: SID= Student ID number, SNAME= Student name, SBDATE= Student date of birth, CNO= Course number, CNAME= Course name, DEPT= Name of department, SEM=Semester, CLASS= Students class, ISBN= Book Identification number, Title= Title of the book, PUB= Publishers name, AUTH= Authors name. Write the following queries using SQL. 1) List the number of courses taken by all students named Ahmed Jan in the Spring 2022 semester. 2) List detail of all textbooks for courses offered by the BS department that have used more than three textbooks. 3) List departments that has all its adopted books published by New Fortune Publishers. 4) List the courses which has adopted more than three textbooks.