CREATE OR REPLACE VIEW exam_area_count AS
         select exam_area,exam_year,exam_mode,count(id) as counter from exambank group by exam_area,exam_year,exam_mode order by     exam_mode,exam_area,exam_year

   select exam_mode,exam_year,count(id) as counter from exambank group by exam_mode,exam_year order by     exam_mode,exam_year