SELECT name,kontinent FROM land;
Quelle: de.wikibooks.org
SELECT * FROM land WHERE kontinent = 'Europa';