7 - Write a SQL Query

For the countries where more than 3 Albanian students are still studying or are graduated, display information related to average of tuition fees and total no of students in each country.

STUDENT(student id, name, father_name, last_name, gender, binth_date, birth_place, highschool_code, leaving_date, graduation year) NOTE: Specifications for graduathon yrar attribute: a) If the student is already graduated from bachelor program and he docse' r shady anymore abroad, this field contains simply information for graduation year. (e.g 2017) b) If the student isn't graduated yet from bachelor program, the value of this attribute will be: "On Going" c) If the student has completed the bachelor program and be continues to stady abroad in master program, the value of this attribute will have the following format: "gradiation year (master)", e.g "2018(master)" The atribute Student_ID has the follow coervention: Let assume that : 009034060109 is one student ID: 0090009034009034060090340601CountrycodeCityCodeUniversityCodeFacultyCode RESIDENCE_PERMISSION (country_code, country_namc, validation period, renewal_duration, fee ) CITY (city_cods, city_name, capital, population, official_lang, no_universitics, municipality scholarship) \$ ADDRESS_ABROAD (student_id, city_code, resident_perm_no, address, phone_no) UNIVERSITY (univ code, univ_name, foundation_year, no_of_facalty, no_of_inst, ) * FACULTY(faculty_code, foundation_date, no_of_departments, teaching_lang, campus address, faculty_scholarship) * EDUCATION_INFOEstudent id, aniversity_code, faculty_code, registration_date, department_name, program_type, study duration, grade, tuition_fec, GPA) Note: Possible Values of program type: "master" or "Bachelor