SC_AC16_CS8-10a

SELECT DISTINCTROW * FROM Camper;

SELECT DISTINCTROW * FROM Activity;

SELECT DISTINCTROW * FROM Camper;

SELECT DISTINCTROW * FROM Parent;

SELECT DISTINCTROW * FROM Parent;

SELECT DISTINCTROW * FROM Parent;

SELECT [Parent].[FirstName], [Parent].[LastName], [Reservation].[ReservationID], [Reservation].[SessionID], [Reservation].[LodgingFee], [Parent].[ParentID] FROM Parent INNER JOIN Reservation ON [Parent].[ParentID] =[Reservation].[ParentID];

SELECT ActivityID, Description, SkillLevel, Fee FROM Activity;

SELECT Parent.ParentID, Parent.FirstName, Parent.LastName, Payments.ReservationID, Payments.AdultTotal, Payments.ChildTotal, Payments.Lodging FROM (Parent INNER JOIN Reservation ON Parent.ParentID = Reservation.ParentID) INNER JOIN Payments ON Reservation.ReservationID = Payments.ReservationID;

SELECT CounselorID, FirstName, LastName, Specialty FROM Counselor;

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 Count(ParentID) AS NumberParents FROM Parent;

SELECT ReservationID, Parent.ParentID, LastName, FirstName FROM Reservation, Parent;

SELECT ParentID FROM Parent WHERE State = "MA";

SELECT ParentID, LastName, FirstName, State FROM Parent WHERE State = "PA";

SELECT ReservationID, TotalFees, Deposit FROM Payments;

SELECT ReservationID, Adults, Children, LodgingFee FROM Reservation;

SELECT ReservationID, SessionID, ParentID, LodgingFee FROM Reservation WHERE SessionID = 2;

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

SELECT Reservation.SessionID, Sum(Reservation.LodgingFee) AS SumOfLodgingFee, Sum(Reservation.AdultTotPrice) AS SumOfAdultTotPrice, Sum(Reservation.ChildTotPrice) AS SumOfChildTotPrice, Count(Reservation.ReservationID) AS CountOfReservationID FROM Session INNER JOIN Reservation ON Session.SessionID = Reservation.SessionID GROUP BY Reservation.SessionID;

SELECT CounselorID, FirstName, LastName, HireDate, State FROM Counselor;