text: CREATE TABLE city (Status VARCHAR) -- List the most common type of Status across cities. SELECT Status FROM city GROUP BY Status ORDER BY COUNT(*) DESC LIMIT 1 CREATE TABLE farm_competition (Official_Name VARCHAR, City_ID VARCHAR, Host_city_ID VARCHAR); CREATE TABLE city (Official_Name VARCHAR, City_ID VARCHAR, Host_city_ID VARCHAR) -- List the official names of cities that have not held any competition. SELECT Official_Name FROM city WHERE NOT City_ID IN (SELECT Host_city_ID FROM farm_competition) CREATE TABLE city (Status VARCHAR, Population INTEGER) -- Show the status shared by cities with population bigger than 1500 and smaller than 500. SELECT Status FROM city WHERE Population > 1500 INTERSECT SELECT Status FROM city WHERE Population < 500 CREATE TABLE city (Official_Name VARCHAR, Population VARCHAR) -- Find the official names of cities with population bigger than 1500 or smaller than 500. SELECT Official_Name FROM city WHERE Population > 1500 OR Population < 500 CREATE TABLE city (Census_Ranking VARCHAR, Status VARCHAR) -- Show the census ranking of cities whose status are not "Village". SELECT Census_Ranking FROM city WHERE Status <> "Village" CREATE TABLE courses (course_name VARCHAR, course_id VARCHAR); CREATE TABLE student_course_registrations (course_Id VARCHAR) -- which course has most number of registered students? SELECT T1.course_name FROM courses AS T1 JOIN student_course_registrations AS T2 ON T1.course_id = T2.course_Id GROUP BY T1.course_id ORDER BY COUNT(*) DESC LIMIT 1