SC_AC16_CS1-3a_FirstLastName_2

SELECT Counselor_Session.SessionID, Counselor.CounselorID, Counselor.FirstName, Counselor.LastName FROM Counselor INNER JOIN Counselor_Session ON Counselor.CounselorID = Counselor_Session.CounselorID ORDER BY Counselor_Session.SessionID, Counselor.CounselorID;

SELECT [FirstName] & " " & [LastName] AS StudentName, [_GradingReport].ProjectName, "Submission #" & [SubmissionNum] AS SubmissionCt, [_GradingReport].Score, [_GradingReport].MaxScore, "Score is: " & [Score] & " out of " & [MaxScore] AS Grade, [_GradingReportSteps].[StepNumber] & ". " & [Description] AS Step, [_GradingReportSteps].[StepScore] & "/" & [_GradingReportSteps].[StepMaxScore] AS StepGrade, [_GradingReportSteps].ActionName, IIf([ifsuccessful]=True,Null,[ErrorText]) AS Feedback, [_GradingReportSteps].IfSuccessful, [_GradingIcons].GA_Status_Icon, [_GradingReportSteps].StepNumber, [_GradingReportSteps].StepActionOrder, [_GradingReportSteps].ID, [_GradingIcons].SAM_Logo, [_GradingReportSteps].Description, [_GradingReport].EngineVersion FROM _GradingReport, _GradingIcons INNER JOIN _GradingReportSteps ON [_GradingIcons].[IfSuccessful_Status] = [_GradingReportSteps].IfSuccessful;

SELECT Parent.ParentID, Parent.LastName, Camper.CamperID, Camper.FirstName, Camper.Age FROM Parent INNER JOIN Camper ON Parent.ParentID = Camper.ParentID WHERE (((Camper.Age)<21));

SELECT Reservation.ReservationID, Reservation.Adults, Reservation.Children, Parent.ParentID, Parent.FirstName, Parent.LastName, Parent.City, Parent.State FROM Parent INNER JOIN Reservation ON Parent.ParentID = Reservation.ParentID WHERE (((Reservation.SessionID)=1));

SELECT Reservation.SessionID, Reservation.ReservationID FROM Reservation;

SELECT Parent.ParentID, Parent.LastName, Parent.FirstName, Parent.State FROM Parent;

SELECT Camper.CamperID, Camper.LastName, Camper.FirstName, Camper.Gender, Camper.Age, Camper.ParentID FROM Camper;