Cities - Answers

Final Answer: as sql eat bad
Solved Anagram: sql database

----------------------------

a - Hamamatsu
1) SELECT city FROM cities WHERE lat LIKE 34.7167 AND lng LIKE 137.733;

s - South Africa
2) SELECT country FROM cities WHERE city = "Hermanus";

s - Serbia
3) SELECT country FROM cities WHERE city = "Belgrade" AND capital = "primary";

q - Quito
4) SELECT city FROM cities WHERE city LIKE "%o" AND lat >= -1 AND lat <= 1 AND lng >= -79 AND lng <= -78 ORDER BY population DESC LIMIT 1;

l - Puerto Williams
5) SELECT city FROM cities ORDER BY lat ASC LIMIT 1;

e - Greenland
6) SELECT country FROM cities ORDER BY lat DESC LIMIT 1

a - Alexandria
7) SELECT city FROM cities WHERE iso2 = "EG" ORDER BY population DESC LIMIT 2, 1;

t - Haiti
8) SELECT country FROM cities WHERE country LIKE "H%i%" GROUP BY country;

b - Brazil
9) SELECT country, SUM(population) FROM cities GROUP BY country ORDER BY SUM(population) DESC LIMIT 3, 1

a
10) SELECT country, COUNT(city) FROM cities WHERE population > 1000000 GROUP BY country ORDER BY COUNT(city) DESC LIMIT 6;

d - Christmas Island
11) SELECT country, city FROM cities WHERE capital = 'primary' ORDER BY population ASC;1