1. Using the subquery, list the ID number, last name, first name, rank and salary of the BINS associate professor whose salary is higher than the highest salary of MGMT assistant professor. 
2. I want to know how many students a faculty member taught each term in 2022. List the term, faculty ID number, and the number of students taught (i.e., how many students). Include only the students living in the state of Arkansas (AR). 
3.  

Transcribed Image Text:

STUDENT StudNo → 123-45-6789 Mary Standing (FR, SO, JR or SR) FACULTY FacNo 098-76-5432 SFName SLName. SCity. Smith SCHEDULE CRN 1111 COURSE Department Rank (Assistant, Associate or Full) FFName FLName Tom Faulkner CRN 1234 CourseNo Title 12345 CourseNo Term 12345 Fall ENROLLMENT BINS 3307 .... SState Little Rock AR StudNo 123-45-6789 Dept Rank BINS Assistant GMT, ECON, MKTG, ACCT or FINC) Year 2022 Subject System Development EnrollmentDate 2022-01-01 Location RBUS 107 **** Major Standing GPA BINS FR 3.00 Grade 3.3 Salary 75000.00 .... Time 10:30 am Supervisor 654-32- 1098 ---- Description It introduces contemporary system development methodologies. HireDate 2020-04-10 FacNo 098-76-5432 Days MW Credits 3 STUDENT StudNo → 123-45-6789 Mary Standing (FR, SO, JR or SR) FACULTY FacNo 098-76-5432 SFName SLName. SCity. Smith SCHEDULE CRN 1111 COURSE Department Rank (Assistant, Associate or Full) FFName FLName Tom Faulkner CRN 1234 CourseNo Title 12345 CourseNo Term 12345 Fall ENROLLMENT BINS 3307 .... SState Little Rock AR StudNo 123-45-6789 Dept Rank BINS Assistant GMT, ECON, MKTG, ACCT or FINC) Year 2022 Subject System Development EnrollmentDate 2022-01-01 Location RBUS 107 **** Major Standing GPA BINS FR 3.00 Grade 3.3 Salary 75000.00 .... Time 10:30 am Supervisor 654-32- 1098 ---- Description It introduces contemporary system development methodologies. HireDate 2020-04-10 FacNo 098-76-5432 Days MW Credits 3

Answer rating: 100% (QA)

a SELECT FacNo FLName FFName Rank Salary FROM FACULTY WHERE Dept BINS AND Ra... View the full answer