text: CREATE TABLE university (affiliation VARCHAR, Enrollment INTEGER, founded INTEGER) -- Find the total number of students enrolled in the colleges that were founded after the year of 1850 for each affiliation type. SELECT SUM(Enrollment), affiliation FROM university WHERE founded > 1850 GROUP BY affiliation CREATE TABLE university (Enrollment INTEGER) -- What is the maximum enrollment across all schools? SELECT MAX(Enrollment) FROM university CREATE TABLE basketball_match (Id VARCHAR) -- List all information regarding the basketball match. SELECT * FROM basketball_match CREATE TABLE basketball_match (team_name VARCHAR, All_Home VARCHAR) -- List names of all teams in the basketball competition, ordered by all home scores in descending order. SELECT team_name FROM basketball_match ORDER BY All_Home DESC CREATE TABLE chip_model (Model_name VARCHAR, Launch_year INTEGER) -- the names of models that launched between 2002 and 2004. SELECT Model_name FROM chip_model WHERE Launch_year BETWEEN 2002 AND 2004 CREATE TABLE chip_model (Model_name VARCHAR, RAM_MiB VARCHAR) -- Which model has the least amount of RAM? List the model name and the amount of RAM. SELECT Model_name, RAM_MiB FROM chip_model ORDER BY RAM_MiB LIMIT 1 CREATE TABLE phone (chip_model VARCHAR, screen_mode VARCHAR, Hardware_Model_name VARCHAR) -- What are the chip model and screen mode of the phone with hardware model name "LG-P760"? SELECT chip_model, screen_mode FROM phone WHERE Hardware_Model_name = "LG-P760"