SELECT DISTINCT student.student_id, student.first_name, student.last_name, course.description,
CASE
grade_type_weight.drop_lowest
WHEN 'N' THEN CAST(average.added_grade AS DECIMAL)/CAST(grade_type_weight.number_per_section AS DECIMAL)*(grade_type_weight.percent_of_final_grade/100)
ELSE (CAST((average.added_grade-min_grade.min_grade) AS DECIMAL)/(CAST(grade_type_weight.number_per_section AS DECIMAL)-1))*(grade_type_weight.percent_of_final_grade/100)
END AS 'Numeric Grade'
FROM student, average, grade, min_grade, SECTION, course, grade_type_weight
WHERE (student.student_id = 124) AND (average.student_id = student.student_id) AND (average.section_id =116) AND (SECTION.course_no = 140)
AND (student.student_id = grade.student_id) AND (average.section_id = grade.section_id)
AND (student.student_id = min_grade.student_id) AND (average.section_id = min_grade.section_id) AND (average.grade_type_code = min_grade.grade_type_code)
AND (average.section_id = SECTION.section_id)
AND (SECTION.course_no = course.course_no)
AND (average.section_id = grade_type_weight.section_id AND average.grade_type_code = grade_type_weight.grade_type_code)