Question: Given a table named universities which contains university data with these columns: name, address, Website, Type, Size. Return a SQL query that gives each type

Given a table named universities which contains university data with these columns: name, address, Website, Type, Size. Return a SQL query that gives each type and the average size of each university of that type in ascending order. Note: You only need to type the SQL query. It does not need to be in quotation marks SQL 4 -- Write your query here. Some clauses are provided to get you started. 2 SELECT * 3 FROM -- JOIN 5 ON 6 WHERE 7 GROUP BY 8 HAVING 9 ORDER BY 10 LIMIT Mac
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
