Question: Write a SQL Query for each country that contains at least one student studying or graduated in Computer Science, display the total number of students
Write a SQL Query for each country that contains at least one student studying or graduated in Computer Science, display the total number of students that fulfill these criteria
Assignment for SQL. Queries 1) Database structure The following databoe contains information related to Allanian studeoss who arc tudying abroad in bachelor or master programs. This database will be wised by our Ministry of Education and otber interested institutions. This database contains 9 tables as following: * HIGH_SCHOOL. fhigh_whoal cosks. Eity_code, high_school_name, no_forcign_lang ) * STUDENT(Ludade id, namse, father name, last name, gender, birh dalc. birth_place, highischool_code, leaving_datc, grabation year) NOTE: Spocifications for graduation year attribute: a) If the stadent is alrealy gradualed from bachelor program and be docsn'y stably anymore abcoad, this ficld contains sinply infornation for graduation year. (cg 2017) b) If the student isn't gradiated yet from hacheloo program, the valoe of this atribute will be: "On Going" c) If the student has completed the bachelor program and he continues to stady abeoad in master program, the valoe of this atribute will huve the folloning format: "ghatuation year (matar)", e.g "2018(master)" The attribute Sesent_ID has the follow conventien: Let assume that : 009034080109 is one student ID: 0090009034009034060090340601CountrycodeCityCodeUniversityCodeFacultyCode * RESIDENCE_FERMISSION iocuctry_code, country_namc, validation_period, renewal_duration, fee) * CITY Gity soob, city name, capital, population, official_lang, do_ univeritics. municipality_scholarship) * ADDRESS_ABROAD istudett_id, sify_code, resident_perm_no, address. phone_pol 2 ENIVERSITY (univ_sods, univ_name, foundation_year, Bo_of_faculty, no_of_inst, ) * EACULTY (ficulty_code, foundation_date, no_of_departinents, 1eaching_lang, campus_address, faculty_scbolarship) * EDUCATION_INFO/studed_id, university_code, faculty_code, regivtration_date, departmem_name, peogram_type, stady_daration, grade, tuition_fee, GPA) Note: Possible Values of program fype: "master" or "bachelar
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
