SELECT country.Code, country.Name FROM country;

SELECT DISTINCT CountryCode FROM city;

SELECT * FROM city LIMIT 10 OFFSET 30;

SELECT * FROM city LIMIT 30, 10;