1. SELECT Name FROM city WHERE CountryCode = 'POL'; 2. SELECT Name FROM country ORDER BY Population DESC LIMIT 10; 3. SELECT AVG(city.Population), country.Name FROM city JOIN country ON CountryCode = city.CountryCode GROUP BY 2 ORDER BY 1 DESC; 4. SELECT Name FROM country WHERE LifeExpectancy > 75 LIMIT 1; 5. SELECT Name FROM country ORDER BY LifeExpectancy DESC LIMIT 1; 6. SELECT Name FROM country ORDER BY LifeExpectancy ASC LIMIT 1; 7. SELECT CountryCode, COUNT(*) AS urzedy FROM countrylanguage GROUP BY CountryCode ORDER BY urzedy DESC; 8. SELECT CountryCode, COUNT(*) AS rozne FROM countrylanguage GROUP BY CountryCode HAVING rozne > 5; 9. SELECT Name FROM city WHERE CountryCode = 'POL' ORDER BY Population DESC LIMIT 1; 10. SELECT city.Name, Country.Name FROM city JOIN Country ON Country.Code = city.CountryCode ORDER BY country.Name, city.Name ASC; 11. SELECT SurfaceArea, Name FROM country where Continent = 'Europe' GROUP BY SurfaceArea DESC; 12. SELECT LANGUAGE FROM countrylanguage JOIN country ON countrylanguage.CountryCode = country.Code WHERE IsOfficial = 'T' and country.LifeExpectancy BETWEEN 30 and 60; 13. INSERT INTO city(Name,CountryCode,District,Population) VALUES('Krosno', 'POL', 'Podkarpacie', '38 400'); 14. UPDATE city SET Population = '44323' WHERE Name = 'Krosno'; 15. INSERT INTO countrylanguage(Language, CountryCode, IsOfficial) VALUES('Kaszubski', 'POL', 'F');