[MyQuery] 3818 "lpattonq" "Course Tally by Gender" "Course Tally by Gender" [END] [MyQueryTables] 3818 3819 1 "EACH" "Student" no 3818 3821 2 "EACH" "StuRequest" no 3818 3823 3 "FIRST" "SchoolCourse" no 3818 3827 4 "FIRST" "Course" no 3818 3860 5 "FIRST" "CourseSection" no 3818 3829 6 "FIRST" "SchoolCourseDept" no 3818 3831 7 "FIRST" "Department" no 3818 3834 8 "FIRST" "Person" no 3818 3836 9 "FIRST" "EntryWithdrawl" no 3818 3840 10 "FIRST" "EntryWithdrawlCodes" no 3818 3842 11 "FIRST" "EnrollStatus" no 3818 3845 12 "FIRST" "RoomCatalog" no [END] [MyQueryWhere] 3818 "WHERE" "" "Student" "DeletedFlag" "=" "" "" "FALSE" "" 3820 "" 3819 1 3818 "WHERE" "" "StuRequest" "StudentID" "=" "Student" "StudentID" "" "" 3822 "" 3821 1 3818 "AND" "" "SchoolCourse" "SchoolProfileSeq" "=" "" "" "1" "" 3824 "" 3823 2 3818 "AND" "" "SchoolCourse" "CalendarYearSeq" "=" "" "" "1" "" 3825 "" 3823 3 3818 "WHERE" "" "SchoolCourse" "SchoolCourseSeq" "=" "StuRequest" "SchoolCourseSeq" "" "" 3826 "" 3823 1 3818 "WHERE" "" "Course" "CourseSeq" "=" "SchoolCourse" "CourseSeq" "" "" 3828 "" 3827 1 3818 "Where" "" "SchoolCourseDept" "SchoolCourseSeq" "=" "StuRequest" "SchoolCourseSeq" "" "" 3830 "" 3829 1 3818 "WHERE" "" "Department" "DepartmentSeq" "=" "SchoolCourseDept" "DepartmentSeq" "" "" 3833 "" 3831 1 3818 "Where" "" "Person" "PersonSeq" "=" "Student" "personSeq" "" "" 3835 "" 3834 1 3818 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" ">=" "" "" "09/01/2003" "" 3837 "" 3836 2 3818 "AND" "" "EntryWithdrawl" "EntryWithdrawlDate" "<=" "" "" "06/20/2004" "" 3838 "" 3836 3 3818 "WHERE" "" "EntryWithdrawl" "StudentID" "=" "Student" "StudentID" "" "" 3839 "" 3836 1 3818 "Where" "" "EntryWithdrawlCodes" "EntryWithdrawlCodeSeq" "=" "EntryWithdrawl" "EntryWithdrawlCodeSeq" "" "" 3841 "" 3840 1 3818 "WHERE" "" "EnrollStatus" "EnrollStatusSeq" "=" "EntryWithdrawlCodes" "EnrollStatusSeq" "" "" 3843 "" 3842 1 3818 "AND" "" "EnrollStatus" "EnrollStatusCode" "=" "" "" "E" "" 3844 "" 3842 2 3818 "OUTER-JOIN WHERE" "" "RoomCatalog" "RoomCatalogSeq" "=" "Student" "Homeroom" "" "" 3846 "" 3845 1 3818 "Where" "" "CourseSection" "SchoolCourseSeq" "=" "StuRequest" "SchoolCourseSeq" "" "" 3861 "" 3860 1 [END] [MyQueryFields] 3818 3847 "Student" "StudentID" "" "ZZZZZZZ9" "ID" no 3 3818 3848 "Person" "LastName" "" "x(15)" "Last Name" no 4 3818 3849 "Person" "FirstName" "" "x(15)" "First Name" no 5 3818 3850 "RoomCatalog" "RoomCode" "" "X(8)" "Home Room" no 8 3818 3851 "Student" "GradeLevel" "" "X(2)" "GL" no 7 3818 3852 "Course" "CourseTitle" "" "X(15)" "Course" no 1 3818 3862 "Student" "Gender" "" "Male/Female" "Gender" no 6 3818 3863 "CourseSection" "CourseSecDesc" "" "x(2)" "Section" no 2 [END] [MyQuerySort] 3818 3864 "Course" "CourseName" no "" 1 "" "" no 3818 3865 "Course" "CourseTitle" no "" 2 "" "" no 3818 3866 "CourseSection" "CourseSecDesc" no "" 3 "" "" no 3818 3854 "Person" "FirstName" no "" 6 "" "" no 3818 3855 "Person" "LastName" no "" 5 "" "" no 3818 3867 "Student" "Gender" yes "Count" 4 "" "" no [END] [MyQueryDocs] 3818 3856 2 "Portrait" 0 "" "" 3818 3857 6 "Portrait" 0 "" "" 3818 3858 1 "Portrait" 0 "" "" 3818 3859 4 "" 0 "" "" [END]