(Solved) : Define Sql View Q9 Year Num Unit Gives Unit Year Greatest Number Distinct International St Q37103008 . . . .

Define SQL view Q9(year, num, unit), which gives, for each unit,the year with the greatest number of distinct internationalstudents enrolled, and the number of distinct internationalstudents enrolled for this year. The view should return thefollowing details about each unit: • year should be taken fromSemesters.year field. • num counts the total number ofinternational students enrolled. • unit should be taken fromOrgUnits.longname field. Note: • you should ignore the units withno international student. • In the case of ties, the same unit withdifferent years should all be included in the result.

Expert Answer

An answer will be send to you