Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

Why We Listen?

Answered: 1 week ago