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
OR
PayPal Gateway not configured
OR
PayPal Gateway not configured