Query 8 - Write a SQL Query

For the students that are currently studying in UK or USA display the following information:

Student_id, student_name, last_name and the total amount of scholarships that student receives

HIGH_SCHOOL (high school_code, city_code, high_school_name, no_foreign_lang) STUDENT(student id, name, father_name, last_name, gender, birth_date, birth_place, highschool_code, leaving_date, graduation_year) NOTE: Specifications for graduation year attribute: a) If the student is already graduated from bachelor program and he doesn't study anymore abroad, this field contains simply information for graduation year. (c.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 he continues to study abroad in master program, the value of this attribute will have the following format: "graduation year (master)". e.g "2018(master)" The attribute Student_ID has the follow convention: Let assume that : 009034060109 is one student ID: 0090009034009034060090340601CountrycodeCityCodeUniversityCodeFacultyCode * RESIDENCE_PERMISSION (country_code, country_name, validation_period, renewal_duration, fee) CITY (city_code, city_name, capital, population, official_lang, no_universities, municipality_scholarship) ADDRESS_ABROAD (student id, city_code, resident_perm_no, address, phone_no) UNIVERSITY (univ_code, univ_name, foundation_year, no_of_faculty. no_of_inst, ) UNIVERSITY (univ_code, univ_name, foundation_year, no_of_faculty, no_of_inst, ) *FACULTY(faculty_code, foundation_date, no_of_departments, teaching_lang, campus_address, faculty_scholarship) * EDUCATION_INFO(student id, university_code, faculty_code, registration_date, department_name, program_type, study_duration, grade, tuition_fee, GPA) Note: Possible Values of program type: "master" or "bachelor