1
SELECT name from Department where max(budget)
***


2
SELECT StudentGrade.StudentID as Studentid,Person.(FirstName AND LastName) as StudentName, count(Course.Credits) as CreditHrs from StudentGrade join Person on StudentGrade.CourseID=Person.PersonID join Course on StudentGrade.CourseID=Course.CourseID where Person.HireDate='NULL' group by FirstName AND LastName
***


3
select Person.(FirstName AND LastName) as StudentName ,Course.Title as CourseTitle,StudentGrade.Grade as StudentGrade from StudentGrade join Person on StudentGrade.CourseID=Person.PersonID join Course on StudentGrade.CourseID=Course.CourseID where Person.HireDate='NULL'
***


4
select Department.name as DepartmentName ,Course.CourseID as CountOfCourses from Department join course on Department.DepartmentID=Course.DepartmentID 
***

5
select Person.(FirstName AND LastName) as StudentName, Person.(FirstName AND LastName) as InstructorName,Title as CourseTitle from 
***


6
select OnlineCourse.CourseID as CourseId ,Course.Title as CourseTitle from Course join OnlineCourse on Course.CourseID=OnlineCourse.CourseID
***


9
select Person.(FirstName AND LastName) as InstructorName,OfficeAssignment.Location as OfficeLocation from Person join OfficeAssignment where Person.EnrollmenttDate='NULL'



