human
Schema:
film (Film_ID, Title, Studio, Director, Gross_in_dollar)
market (Market_ID, Country, Number_cities)
film_market_estimation (Estimation_ID, Low_Estimate, High_Estimate, Film_ID, Type, Market_ID, Year)
Please answer with SQL.
assistant
Sure, I understand.
human
Find the number of cities in USA country?
assistant
SELECT Number_cities FROM market WHERE country = 'USA';
human
How many country's located in the world?
assistant
SELECT COUNT( country ) FROM market;
human
What are the market id of china?
assistant
SELECT market_id FROM market WHERE country = 'China';
human
What are the maximum and minimum number of cities in all markets.
assistant
SELECT MAX( Number_cities ) , MIN( Number_cities ) FROM market ;