sql statements plz

Within the university, a professor is affiliated to a department, and a department is affiliated to a college. A department can offer many majors and students enroll in a major of their choice. PROFESSOR (ProfID. ProfName, ProfAddr, ProfEmail, DeptCode) PROFESSOR.ProfID is the university-provided ID number for a professor (e.g., 1000, 1001, 1002 etc.) PROFESSOR.DeptCode represents the departmental affiliation of a professor (e.g., AMIS, ASOR, MGMT etc.) DEPARTMENT (DeptCode DeptName, DeptAddress, CollegeCode) DEPARTMENT.DeptCode is the unique code for a department (e.g., AMIS, ASOR, MGMT etc.) DEPARTMENT.CollegeCode is the college to which the department is affiliated (e.g., BUSINESS, EDUCATION, SCIENCE etc.) COLLEGE (CollegeCode, CollegeName, College Address) COLLEGE.CollegeCode is the unique code for a college (eg, BUSINESS, EDUCATION, SCIENCE etc.) STUDENT (StudentID. StudentName, StudentAddress, StudentGPA) STUDENT.StudentID is the university-provided ID number for a student (eg., 10000, 10001, 10002 etc.) STUDENT.MajorID represents the major of a student (eg., MKTG, ACCT, MIS, MATH etc.) Code the SQL statement(s) that will retrieve the following information from the database. In some cases, you might need to code more than one SQL statement. If it is not possible to code an SQL to retrieve the information being requested, please state so, and explain why, a) The names and addresses of professors belonging to the MKTG, ASOR, and MGMT departments. [15 pts.) SELECT ProfName Rrafadde FROM Professor WHERE Dertade in ('MKTGY ASOR', 'MGMT"); b) The names and addresses of students having gpa greater than 3.2. (15 pts.) c) The department names of departments having more than 10 professors. [25 pts) d) The names and addresses of professors affiliated to the SCIENCE, BUSINESS, and EDUCATION colleges. [25 pts]