Data Base

SELECT Min(tblContract.Cost) AS [Minimum Cost], Avg(tblContract.Cost) AS [Average Cost], Max(tblContract.Cost) AS [Maximum Cost] FROM tblContract;

SELECT Student.City, Min(Contract.Cost) AS [Minimum Cost], Avg(Contract.Cost) AS [Average Cost], Max(Contract.Cost) AS [Maximum Cost] FROM Student INNER JOIN Contract ON Student.StudentID = Contract.StudentID GROUP BY Student.City;

SELECT Tutor.LastName, Contract.StudentID, Contract.ContractDate, Contract.Length, Contract.Cost FROM Tutor INNER JOIN Contract ON Tutor.TutorID = Contract.TutorID WHERE (((Contract.SessionType)="Group")) ORDER BY Tutor.LastName, Contract.StudentID;

SELECT tblStudent.[FirstName], tblStudent.[LastName], tblStudent.[City], tblStudent.[HomePhone] FROM tblStudent WHERE (((tblStudent.[LastName]) Like "M*")) ORDER BY tblStudent.[LastName];

SELECT tblContract.[StudentID], tblContract.[SessionType], tblContract.[ContractID], tblContract.[TutorID], tblContract.[ContractDate], tblContract.[Length], tblContract.[NumSessions], tblContract.[Cost], tblContract.[Assessment] FROM tblContract WHERE (((tblContract.[StudentID]) In (SELECT [StudentID] FROM [tblContract] As Tmp GROUP BY [StudentID],[SessionType] HAVING Count(*)>1 And [SessionType] = [tblContract].[SessionType]))) ORDER BY tblContract.[StudentID], tblContract.[SessionType];

SELECT tblStudent.[FirstName], tblStudent.[LastName], tblStudent.[City], tblStudent.[HomePhone] FROM tblStudent WHERE ((Not (tblStudent.[City])=("South Bend"))) ORDER BY tblStudent.[City];

SELECT Student.StudentID, Student.FirstName, Student.LastName, Contract.ContractDate, Contract.Cost FROM Student INNER JOIN Contract ON Student.StudentID = Contract.StudentID WHERE (((Student.City)="Oscela")) OR (((Contract.SessionType)="Semi-private")) ORDER BY Contract.ContractDate DESC;

SELECT tblTutor.FirstName, tblTutor.LastName, tblTutor.Degree FROM tblTutor WHERE (((tblTutor.Degree)="BA")) OR (((tblTutor.Degree)="MA")) ORDER BY tblTutor.LastName;

SELECT Tutor.LastName, Contract.StudentID, Contract.ContractDate, Contract.SessionType, Contract.Length, Contract.Cost FROM Tutor INNER JOIN Contract ON Tutor.TutorID = Contract.TutorID ORDER BY Tutor.LastName, Contract.StudentID;

TRANSFORM Count(tblContract_Crosstab.[2]) AS CountOf2 SELECT tblContract_Crosstab.SessionType, Count(tblContract_Crosstab.[2]) AS [Total Of 2] FROM tblContract_Crosstab GROUP BY tblContract_Crosstab.SessionType PIVOT tblContract_Crosstab.[Total Of ContractID];

SELECT tblContract.[ContractID], tblContract.[StudentID], tblContract.[TutorID], tblContract.[ContractDate], tblContract.[SessionType], tblContract.[Length], tblContract.[NumSessions], tblContract.[Cost], tblContract.[Assessment] FROM tblContract WHERE (((tblContract.[SessionType]) Like [Type a Session Type:] & "*"));

SELECT Student.StudentID, Student.LastName, Student.FirstName, Contract.ContractDate FROM Student INNER JOIN Contract ON Student.StudentID = Contract.StudentID WHERE (((Student.City)="South Bend") AND ((Contract.SessionType)="Private")) ORDER BY Student.LastName;

SELECT Tutor.[FirstName], Tutor.[LastName], Tutor.[HireDate] FROM Tutor;

SELECT Student.LastName, Student.FirstName, Student.CellPhone FROM Student;

SELECT tblStudent.StudentID, tblStudent.FirstName, tblStudent.LastName, tblStudent.Address, tblStudent.City, tblStudent.State, tblStudent.Zip, tblStudent.HomePhone, tblStudent.CellPhone, tblStudent.BirthDate, tblStudent.Gender FROM tblStudent LEFT JOIN tblContract ON tblStudent.[StudentID] = tblContract.[StudentID] WHERE (((tblContract.StudentID) Is Null));

SELECT tblTutor.[TutorID], [FirstName] & " " & [LastName] AS TutorName, tblTutor.[Degree], tblTutor.[School], tblTutor.[HireDate], tblTutor.[Groups] FROM tblTutor ORDER BY [FirstName] & " " & [LastName], tblTutor.[FirstName], tblTutor.[LastName];

TRANSFORM Count(tblContract.[ContractID]) AS CountOfContractID SELECT tblContract.[SessionType], Count(tblContract.[ContractID]) AS [Total Of ContractID] FROM tblContract GROUP BY tblContract.[SessionType] PIVOT tblContract.[Length];

TRANSFORM Count(tblContract.[ContractID]) AS CountOfContractID SELECT Count(tblContract.[ContractID]) AS [Total Of ContractID], tblContract.[SessionType] FROM tblContract GROUP BY tblContract.[SessionType] PIVOT tblContract.[Length];

SELECT tblTutor.FirstName, tblTutor.LastName, tblContract.StudentID, tblContract.ContractID, tblContract.SessionType, tblContract.Length, tblContract.Cost FROM tblTutor INNER JOIN tblContract ON tblTutor.[TutorID] = tblContract.[TutorID];

SELECT DISTINCTROW * FROM tblTutor;

SELECT [tblContract].[ContractID], [tblContract].[StudentID], [tblContract].[TutorID], [tblContract].[ContractDate], [tblContract].[SessionType], [tblContract].[Length], [tblContract].[NumSessions], [tblContract].[Cost], [tblContract].[Assessment] FROM tblContract;

SELECT [tblTutor].[TutorID], [tblTutor].[LastName], [tblTutor].[FirstName] FROM tblTutor ORDER BY [LastName], [FirstName];

SELECT [tblStudent].[StudentID], [tblStudent].[FirstName], [tblStudent].[LastName] FROM tblStudent ORDER BY [LastName], [FirstName];

SELECT DISTINCTROW * FROM tblContract;