SELECT
s.id_number,s.first_name,s.last_name,s.tckimlikno,gr.diploma_no,
f.decision_date,
ROUND( (sum(c.Credit*grade_points4)/sum(c.credit)) ,2 ) as
ortalama,sum(c.Credit*grade_points4),sum(c.credit)
FROM enrollment e, course c,Grade g,registration r,
student s,faculty_decision f,graduate gr
WHERE e.id_number=r.id_number
and e.id_number=s.id_number
and r.id_number=s.id_number
and r.id_number=f.id_number
and e.id_number=f.id_number
and s.id_number=f.id_number
and s.id_number=gr.id_number(+)
and f.decision_type=8
and s.id_number=4708012
and r.semester_status=4
and e.Course_code=c.Course_code
and e.program_code=r.program_code
and e.semester = c.semester
and e.semester = g.semester
and e.grade=g.grade
and e.course_status in ('R','E','A')
and e.grade in ('A ','A-','B+','B ','B-','C+','C ')
group by
s.id_number,s.first_name,s.last_name,s.tckimlikno,gr.diploma_no,
r.program_code,f.decision_date
order by r.program_code,ROUND((sum(c.Credit*grade_points4)/sum(c.credit)),2)
desc