clear screen


--Aufgabe 1:
DESC player
PROMPT Tabelle player
SELECT name, forename
FROM player;
--Aufgabe 2:
SELECT forename, name
FROM player;
--Aufgabe 3:
SELECT name||' '||forename
FROM player;
--Aufgabe 4:
SELECT pid, name, forename, country
FROM player
WHERE country = 'Malaysia';
--Aufgabe 5:
SELECT pid, name, forename, country
FROM player WHERE NOT country = 'Malaysia' OR country = 'USA';
--Aufgabe 6:
SELECT pid, name, birth
FROM player
WHERE birth > '1.1.2000';
--Aufgabe 7:
SELECT pid, name, birth
FROM player
WHERE birth
BETWEEN '1.1.1990' AND '1.1.2000';
--Aufgabe 8:
SELECT pid, forename, name
FROM player
WHERE forename = 'Joakim';
--Aufgabe 9:
SELECT pid, forename, name
FROM player
WHERE forename LIKE '%i';
--Aufgabe 10: