Members statistic

Create a query that displays members statistics for each club showing club name, state, the total number of members, number of active members, number of on hold members, number of inactive members.

Club timetable Create a query that displays the classes timetable for a club. The query result has to display day,

time, class name, instructor name sorted by day, followed by time.

ClubFacility Facility FacilityID (PK) # ClubID (PK, FK1) FacilityID (PK, FK2) Manager StaffID (PK, FK) Specialisation SpeciD (PK) Club IH ClubID (PK) Managerid (FK) Staff StaffID (PK) of Trainer Membership MemberTypeID (PK) StaffID (PK, FK) TrainerSpec 04 StaffID (PK, FK1) SpecID (PK, FK2) Status Member MemberID (PK) HomeClub (FK1) MemberTypeID (FK2) StatusID (FK3) # ClassRegistration Status TypeID (PK) HE MemberID (PK, FK1) bo EventID (PK, FK2) Personal Training Class Timetable EventID (PK) ClassID (FK1) TrainerID (FK2) ClubID (FK3) MemberID (PK, FK1) StaffID (PK, FK2) AllAccessMember MemberID (PK, FK) E Class SID (PK)