text: CREATE TABLE farm_competition (Hosts VARCHAR, Theme VARCHAR) -- What are the hosts of competitions whose theme is not "Aliens"? SELECT Hosts FROM farm_competition WHERE Theme <> 'Aliens' CREATE TABLE farm_competition (Theme VARCHAR, YEAR VARCHAR) -- What are the themes of farm competitions sorted by year in ascending order? SELECT Theme FROM farm_competition ORDER BY YEAR CREATE TABLE farm (Working_Horses INTEGER, Total_Horses INTEGER) -- What is the average number of working horses of farms with more than 5000 total number of horses? SELECT AVG(Working_Horses) FROM farm WHERE Total_Horses > 5000 CREATE TABLE farm (Cows INTEGER) -- What are the maximum and minimum number of cows across all farms. SELECT MAX(Cows), MIN(Cows) FROM farm CREATE TABLE city (Status VARCHAR) -- How many different statuses do cities have? SELECT COUNT(DISTINCT Status) FROM city CREATE TABLE city (Official_Name VARCHAR, Population VARCHAR) -- List official names of cities in descending order of population. SELECT Official_Name FROM city ORDER BY Population DESC CREATE TABLE city (Official_Name VARCHAR, Status VARCHAR, Population VARCHAR) -- List the official name and status of the city with the largest population. SELECT Official_Name, Status FROM city ORDER BY Population DESC LIMIT 1 CREATE TABLE city (Official_Name VARCHAR, City_ID VARCHAR); CREATE TABLE farm_competition (Year VARCHAR, Host_city_ID VARCHAR) -- Show the years and the official names of the host cities of competitions. SELECT T2.Year, T1.Official_Name FROM city AS T1 JOIN farm_competition AS T2 ON T1.City_ID = T2.Host_city_ID