#1
SELECT name, population FROM cities WHERE population <= 50000;

#2
SELECT name, population FROM cities WHERE population <= 50000 ORDER BY population ASC;

#3
SELECT name, population FROM cities ORDER BY population DESC LIMIT 2;

#4
SELECT COUNT(*) FROM cities WHERE population <= 50000;

#5
SELECT COUNT(*) FROM users, access 
  WHERE users.access_id = access.id AND access.name = "browse";

#6
SELECT first_name, last_name FROM users, cities WHERE (users.city_id = cities.id)
  AND ((cities.name = "Bozeman") OR (cities.name = "Billings"));
  
#7
SELECT first_name, last_name FROM users, cities, access WHERE (users.city_id = cities.id)
  AND (cities.name = "Bozeman") AND (users.access_id = access.id) AND (access.name = "admin");
  
#8
SELECT access.name, COUNT(*) FROM access, users WHERE access.id = users.access_id
  GROUP BY access.name;
  
#9
SELECT states.name, COUNT(states.name) FROM states, users WHERE states.id = users.state_id
  GROUP BY states.name;
  
#10
SELECT cities.name, COUNT(cities.name) FROM cities, users WHERE cities.id = users.city_id
  GROUP BY cities.name HAVING COUNT(cities.name) > 1 ORDER BY COUNT(cities.name) DESC, cities.name ASC;