TABLE `t_entry` 
  `entry_id`           int(9) 
  `entry_sportart`     varchar(4) 
  `entry_ort`          varchar(17) 
  `entry_jahr`         int(4) 
  `entry_persid`       int(6) 
  `entry_stil`         varchar(2) 
  `entry_bahnlaenge`   varchar(1) 
  `entry_minuten`      varchar(7) 
  `entry_meter`        int(5) 

TABLE `t_pers` 
  `pers_id`            int(3) 
  `pers_kuerzel`       varchar(12) 
  `pers_email`         varchar(34) 
  `pers_nachname`      varchar(17) 
  `pers_vorname`       varchar(13) 
  `pers_sex`           varchar(1) 
  `pers_jg`            int(4) 


-- Alle Einträge finden--
SELECT * 
FROM `t_entry` AS E, `t_pers` AS P 
WHERE E.entry_persid = P.pers_id;

-- Beispielabfrage 1 --
SELECT pers_vorname, pers_nachname, pers_jg, entry_jahr, entry_minuten, entry_meter, entry_ort 
FROM t_entry, t_pers 
WHERE entry_persid = pers_id
AND entry_jahr >= 2018
AND entry_minuten > 40
AND entry_minuten < 70
AND pers_nachname LIKE 'Hun%';


-- Beispielabfrage 2 --
SELECT * 
FROM t_entry, t_pers 
WHERE entry_persid = pers_id
AND entry_jahr IN (2016, 2018, 2020)
AND entry_minuten BETWEEN 50 AND 70
AND entry_stil <> 'R'
AND pers_jg < 1962
ORDER BY entry_jahr, entry_ort;


-- Beispielabfrage 3 --
SELECT * FROM `t_pers` 
WHERE `pers_nachname` = 'Hunger'
ORDER BY `pers_id` ASC 


-- Personen, die kein Entry haben
SELECT pers_id, pers_vorname, pers_nachname, pers_sex, pers_jg
FROM t_entry, t_pers
WHERE pers_id NOT IN (SELECT `entry_persid` FROM t_entry)
GROUP BY pers_id

-- Bsp. um Aenderungen zu machen
UPDATE `t_entry` SET `entry_minuten`= 96
WHERE `entry_id` = 201800003


-- löschen eines Eintrages
DELETE FROM `t_pers` WHERE `pers_id` = 968