Table: cinema_chains
Columns: rank
circuit
headquarters
screens
sites

Question: what is the rank of the cinema when the number of sites is more than 62 and the circuit is cineplex entertainment?
SQL: SELECT SUM("rank") FROM cinema_chains WHERE "sites" > 62 AND "circuit" = 'cineplex entertainment'

Question: what is the number of sites when the number of screens is 687 and rank is more than 7?
SQL: SELECT AVG("sites") FROM cinema_chains WHERE "screens" = 687 AND "rank" > 7

Question: what is the lowest number of sites when the headquarters are in columbus, ga and the rank is smaller than 4?
SQL: SELECT MIN("sites") FROM cinema_chains WHERE "headquarters" = 'columbus, ga' AND "rank" < 4