text: CREATE TABLE user_profiles (followers INTEGER, UID VARCHAR); CREATE TABLE tweets (followers INTEGER, UID VARCHAR) -- Find the average number of followers for the users who do not have any tweet. SELECT AVG(followers) FROM user_profiles WHERE NOT UID IN (SELECT UID FROM tweets) CREATE TABLE user_profiles (followers INTEGER, UID VARCHAR); CREATE TABLE tweets (followers INTEGER, UID VARCHAR) -- Find the average number of followers for the users who had some tweets. SELECT AVG(followers) FROM user_profiles WHERE UID IN (SELECT UID FROM tweets) CREATE TABLE user_profiles (followers INTEGER) -- Find the maximum and total number of followers of all users. SELECT MAX(followers), SUM(followers) FROM user_profiles CREATE TABLE catalog_contents (catalog_entry_name VARCHAR) -- Find the names of all the catalog entries. SELECT DISTINCT (catalog_entry_name) FROM catalog_contents CREATE TABLE Attribute_Definitions (attribute_data_type VARCHAR) -- Find the list of attribute data types possessed by more than 3 attribute definitions. SELECT attribute_data_type FROM Attribute_Definitions GROUP BY attribute_data_type HAVING COUNT(*) > 3 CREATE TABLE Attribute_Definitions (attribute_data_type VARCHAR, attribute_name VARCHAR) -- What is the attribute data type of the attribute with name "Green"? SELECT attribute_data_type FROM Attribute_Definitions WHERE attribute_name = "Green" CREATE TABLE Catalog_Structure (catalog_level_name VARCHAR, catalog_level_number INTEGER) -- Find the name and level of catalog structure with level between 5 and 10. SELECT catalog_level_name, catalog_level_number FROM Catalog_Structure WHERE catalog_level_number BETWEEN 5 AND 10