text: CREATE TABLE cinema (name VARCHAR, LOCATION VARCHAR, capacity VARCHAR) -- What are the name and location of the cinema with the largest capacity? SELECT name, LOCATION FROM cinema ORDER BY capacity DESC LIMIT 1 CREATE TABLE cinema (capacity INTEGER, openning_year VARCHAR) -- Show the average, minimum, and maximum capacity for all the cinemas opened in year 2011 or later. SELECT AVG(capacity), MIN(capacity), MAX(capacity) FROM cinema WHERE openning_year >= 2011 CREATE TABLE cinema (LOCATION VARCHAR) -- Show each location and the number of cinemas there. SELECT LOCATION, COUNT(*) FROM cinema GROUP BY LOCATION CREATE TABLE cinema (LOCATION VARCHAR, openning_year VARCHAR) -- What is the location with the most cinemas opened in year 2010 or later? SELECT LOCATION FROM cinema WHERE openning_year >= 2010 GROUP BY LOCATION ORDER BY COUNT(*) DESC LIMIT 1 CREATE TABLE cinema (LOCATION VARCHAR, capacity INTEGER) -- Show all the locations with at least two cinemas with capacity above 300. SELECT LOCATION FROM cinema WHERE capacity > 300 GROUP BY LOCATION HAVING COUNT(*) >= 2 CREATE TABLE film (title VARCHAR, directed_by VARCHAR) -- Show the title and director for all films. SELECT title, directed_by FROM film CREATE TABLE film (directed_by VARCHAR) -- Show all directors. SELECT DISTINCT directed_by FROM film CREATE TABLE film (directed_by VARCHAR) -- List all directors along with the number of films directed by each director. SELECT directed_by, COUNT(*) FROM film GROUP BY directed_by