Question: Write a SQL 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

Write a SQL 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
Use the table below
 Write a SQL 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 Use the table below STUDENT(student
id, name, father_name, last_name, gender, bth_date, birth_place, highschool_code, leaving_date, graduation_year) NOTE: Specifications

STUDENT(student id, name, father_name, last_name, gender, bth_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 stady anymore abroad, this field contains simply information for graduation year. (e.g 2017) b) If the student isn't graduated yet from bachelos 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: "gradiation year (master)". e.g "2018/master)" The attribute Student_ID has the follows convention: Let assume that : 009034060109 is one student ID: 0090009034009034060090340601CountrycodeCityCodeUniversityCodeFacultyCode \& RESIDENCE_PERMISSION (country_cods, country_name, validation_period, renewal_duration, fee) CITY (city_cods, city_name, capital, population, official_lang, no_ universities, municipality_ scholarship) * ADDRESS_ABROAD (student_io, city_code, resident_perm_no, address, phone_no) \$ UNIVERSITY (uniy code, univ_name, foundation_year, no_of_faculty, no_of_inst, ) * FACULTY(faculry_code, foundation_datc, no_of_departments, teaching_lang, campus_address, faculty_scholarship) * EDUCATION_INFO(stadent id, university_code, faculty_code, registration_date, department_name, program_type, study_duration, grade, tuition_fee, GPA) Note: Possible Values of program type: "miaster" or "hachelor" University_code 8

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!