def METHOD_NAME( self ):
    # Queries 
    student_query = ActivePlanQueryWithReqTerm({'plans':['ENSCPRO']})
    students = student_query.result()
    subplan_query = SubplanQuery()
    subplans = subplan_query.result()
    subplans.flatten("EMPLID")
    students.left_join(subplans, "EMPLID")
    students.title = "Master Table" 
    def emplids_in_course(subject, catalog_nbr):
        course_query = SingleCourseQuery( {'subject': subject, 'catalog_nbr': catalog_nbr} )
        course = course_query.result()
        emplids = set(course.column_as_list('EMPLID'))
        del course_query
        del course
        return emplids
    ensc_194_emplids = emplids_in_course('ENSC', '194')
    ensc_195_emplids = emplids_in_course('ENSC', '195')
    ensc_196_emplids = emplids_in_course('ENSC', '196')
    ensc_295_emplids = emplids_in_course('ENSC', '295')
    ensc_296_emplids = emplids_in_course('ENSC', '296')
    students.compute_column('HAS_ENSC_194', lambda x: x['EMPLID'] in ensc_194_emplids)
    students.compute_column('HAS_ENSC_195', lambda x: x['EMPLID'] in ensc_195_emplids)
    students.compute_column('HAS_ENSC_196', lambda x: x['EMPLID'] in ensc_196_emplids)
    students.compute_column('HAS_ENSC_295', lambda x: x['EMPLID'] in ensc_295_emplids)
    students.compute_column('HAS_ENSC_296', lambda x: x['EMPLID'] in ensc_296_emplids)
    gpa_and_credit_query = CGPAQuery() 
    gpas = gpa_and_credit_query.result()
    email_query = EmailQuery()
    email = email_query.result()
    email.filter(EmailQuery.campus_email)
    email.remove_column("PREF_EMAIL_FLAG")
    name_query = NameQuery()
    names = name_query.result()
    students.left_join(names, "EMPLID")
    students.left_join(gpas, "EMPLID")
    students.left_join(email, "EMPLID")
    students_70 = copy.deepcopy( students )
    students_70.title = "Students with >70 Credits and no ENSC 194-196"
    def floaty(x):
        try:
            return float(x)
        except:
            return 0.0
    students_70.filter( lambda x: floaty(x['CREDITS']) > 69.9 )
    students_70.filter( lambda x: not x['HAS_ENSC_194'] or not x['HAS_ENSC_195'] or not x['HAS_ENSC_196'] )
    students_70.flatten("EMPLID")
    students_100 = copy.deepcopy(students)
    students_100.title = "Students with >100 Credits and no ENSC 295-296"
    students_100.filter( lambda x: floaty(x['CREDITS']) > 99.9 )
    students_100.filter( lambda x: not x['HAS_ENSC_295'] or not x['HAS_ENSC_296'] )
    students_100.flatten("EMPLID")
    self.artifacts.append(students)
    self.artifacts.append(students_70)
    self.artifacts.append(students_100)