title: Not able to display average
body: <p>i want to display an average score but its not getting displayed even though the code is executed, here is my code:</p>
  
  <pre><code>set serveroutput on size 10000;
  declare
   s_student_id grade.student_id%type;
   g_score grade.score%type;
  begin
   for c in (select distinct grade.student_id, avg(grade.score) into s_student_id, g_score from grade inner join class on grade.class_id = class.class_id group by grade.student_id having count(class.course_id) &gt; 4)
   loop
  
      dbms_output.put_line('Student' || c.student_id || ' :' || g_score);
  
   end loop;
   exception
       when no_data_found then dbms_output.put_line('There are no students who selected more than 4 courses');
  end;
  </code></pre>
  
  <p>/</p>
  
  <p><strong>Output:</strong></p>
  
  <pre><code>anonymous block completed
  Student1 :
  </code></pre>