text: CREATE TABLE cinema (LOCATION VARCHAR, capacity INTEGER) -- Find the locations that have more than one movie theater with capacity above 300. SELECT LOCATION FROM cinema WHERE capacity > 300 GROUP BY LOCATION HAVING COUNT(*) > 1 CREATE TABLE film (title VARCHAR) -- How many films have the word 'Dummy' in their titles? SELECT COUNT(*) FROM film WHERE title LIKE "%Dummy%" CREATE TABLE discount_coupons (coupon_id VARCHAR, coupon_amount VARCHAR); CREATE TABLE customers (good_or_bad_customer VARCHAR, coupon_id VARCHAR) -- Are the customers holding coupons with amount 500 bad or good? SELECT T1.good_or_bad_customer FROM customers AS T1 JOIN discount_coupons AS T2 ON T1.coupon_id = T2.coupon_id WHERE T2.coupon_amount = 500 CREATE TABLE bookings (customer_id VARCHAR); CREATE TABLE Customers (customer_id VARCHAR, first_name VARCHAR) -- How many bookings did each customer make? List the customer id, first name, and the count. SELECT T1.customer_id, T1.first_name, COUNT(*) FROM Customers AS T1 JOIN bookings AS T2 ON T1.customer_id = T2.customer_id GROUP BY T1.customer_id CREATE TABLE Payments (customer_id VARCHAR, amount_paid INTEGER) -- What is the maximum total amount paid by a customer? List the customer id and amount. SELECT customer_id, SUM(amount_paid) FROM Payments GROUP BY customer_id ORDER BY SUM(amount_paid) DESC LIMIT 1 CREATE TABLE Payments (booking_id VARCHAR); CREATE TABLE Bookings (booking_id VARCHAR, amount_of_refund VARCHAR) -- What are the id and the amount of refund of the booking that incurred the most times of payments? SELECT T1.booking_id, T1.amount_of_refund FROM Bookings AS T1 JOIN Payments AS T2 ON T1.booking_id = T2.booking_id GROUP BY T1.booking_id ORDER BY COUNT(*) DESC LIMIT 1